Yadda ake shigar MySQL database?Shigar mysql mataki-mataki koyawa

如何 安装MySQL database?ShigarMySQLmataki-mataki koyawa

MySQL Ƙare

Adireshin zazzagewar Mysql na duk dandamali shine: MySQL downloadZaɓi abin da kuke buƙata Sabar Al'umma ta MySQL sigar da dandamali mai dacewa.

LinuxSanya Mysql akan /UNIX

Ana ba da shawarar yin amfani da kunshin RPM don shigar da Mysql akan dandalin Linux. MySQL AB yana ba da adireshin zazzagewar fakitin RPM mai zuwa:

• MySQL – uwar garken MySQL.Kuna buƙatar wannan zaɓi sai dai idan kuna son haɗawa zuwa uwar garken MySQL da ke gudana akan wata na'ura.
• MySQL-abokin ciniki – Shirin abokin ciniki na MySQL, ana amfani dashi don haɗawa da sarrafa uwar garken Mysql.
• MySQL-devel - Laburare kuma sun haɗa da fayiloli, idan kuna son tattara wasu abokan cinikin MySQL, kamar su Perl modules, kuna buƙatar shigar da wannan fakitin RPM.
• MySQL-shared - Ya kamata软件Kunshin ya ƙunshi ɗakunan karatu da aka raba (libmysqlclient.so*) waɗanda wasu harsuna da aikace-aikacen ke buƙatar ɗaukar nauyi, ta amfani da MySQL.
• MySQL - benci - Alamar alama da kayan aikin gwaji don uwar garken bayanan MySQL.

Na gaba mu ne Cibiyoyin Yi amfani da yum umarni don shigar da MySql a ƙarƙashin tsarin:

Duba ko tsarin ya zo tare da shigar mysql:

rpm -qa | grep mysql

Idan tsarin ku ya shigar, zaku iya zaɓar cire shi:

rpm -e mysql　　// 普通删除模式
rpm -e --nodeps mysql　　// 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除

Sanya mysql:

yum install mysql
yum install mysql-server
yum install mysql-devel

Fara mysql:

service mysqld start

Lura:Idan muka fara sabis na mysql a karon farko, uwar garken mysql zai fara aiwatar da saitin farko.

Don CentOS 7, tunda an cire bayanan MySQL daga jerin tsoffin shirye-shirye, zaku iya amfani da mariadb maimakon:

yum install mariadb-server mariadb 

Dokokin da suka dace don bayanan bayanan mariadb sune:

systemctl start mariadb  #启动MariaDB
systemctl stop mariadb  #停止MariaDB
systemctl restart mariadb  #重启MariaDB
systemctl enable mariadb  #设置开机启动

Tabbatar da shigarwar Mysql

Bayan an yi nasarar shigar da Mysql, za a fara fara wasu tebur na asali. Bayan an fara uwar garken, zaku iya tabbatar da cewa Mysql yana aiki da kyau ta hanyar gwaji mai sauƙi.

Yi amfani da kayan aikin mysqladmin don samun matsayin uwar garken:

Yi amfani da umarnin mysqladmin don bincika sigar uwar garken, binary yana a /usr/bin akan Linux akan linux da C: mysql bin akan windows.

[root@host]# mysqladmin --version

Wannan umarni akan Linux zai fitar da sakamako masu zuwa, dangane da bayanan tsarin ku:

mysqladmin  Ver 8.23 Distrib 5.0.9-0, for redhat-linux-gnu on i386

Idan ba a shigar da bayani ba bayan an aiwatar da umarnin da ke sama, yana nufin ba a shigar da Mysql ɗinku cikin nasara ba.

Yi amfani da Abokin ciniki na MySQL (abokin ciniki na MySQL) don aiwatar da umarnin SQL masu sauƙi

Kuna iya amfani da umarnin mysql don haɗawa da uwar garken Mysql a cikin MySQL Client (Mysql abokin ciniki) Ta hanyar tsoho, kalmar sirrin uwar garken Mysql ba ta da komai, don haka wannan misalin baya buƙatar shigar da kalmar sirri.

Umurnin shine kamar haka:

[root@host]# mysql

Bayan an aiwatar da wannan umarni na sama, za a fitar da sakon mysql> wanda ke nufin cewa kun yi nasarar haɗa uwar garken Mysql.

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.13 sec)

Abin da ya kamata a yi bayan an shigar da Mysql

Bayan an shigar da Mysql cikin nasara, tsoho kalmar sirrin mai amfani ba komai bane, zaku iya amfani da umarni mai zuwa don ƙirƙirar kalmar sirrin mai amfani:

[root@host]# mysqladmin -u root password "new_password";

Yanzu zaku iya haɗawa zuwa uwar garken Mysql tare da umarni mai zuwa:

[root@host]# mysql -u root -p
Enter password:*******

Lura:Lokacin shigar da kalmar wucewa, kalmar sirri ba za a nuna ba, za ku iya shigar da shi daidai.

Sanya Mysql akan Windows

Shigar da Mysql akan Windows abu ne mai sauƙi, kawai kuna buƙata MySQL downloadZazzage sigar Windows na fakitin shigarwa na mysql kuma ku rage fakitin shigarwa.

Danna fayil ɗin setup.exe sau biyu, sannan kawai kuna buƙatar shigar da tsoho tsarin sai ku danna "na gaba" Ta hanyar tsoho, bayanin shigarwa zai kasance a cikin C: \ mysql directory.

Na gaba, zaku iya canzawa zuwa C: \ mysql \ bin directory akan umarni da sauri ta hanyar "Start" = "shigar da umurnin"cmd" a cikin akwatin bincike, kuma shigar da umarnin:

mysqld.exe --console

Idan shigarwa ya yi nasara, umarnin da ke sama zai fitar da wasu farawa na mysql da bayanin InnoDB.