Ungayifaka kanjani i-database ye-MySQL?Faka isifundo se-mysql ngesinyathelo ngesinyathelo

indlela yokufakaMySQL database?Fakamysqlisinyathelo ngesinyathelo isifundo

MySQL ukufakwa

Ikheli lokulanda le-Mysql lawo wonke amapulatifomu lithi: Landa i-MySQLKhetha okudingayo Iseva Yomphakathi ye-MySQL inguqulo kanye nesiteji esihambisanayo.

LinuxFaka i-Mysql ku-/UNIX

Kunconywa ukusebenzisa iphakheji ye-RPM ukuze ufake i-Mysql kuplathifomu ye-Linux. I-MySQL AB inikeza ikheli lokulanda lephakheji ye-RPM elandelayo:

• MySQL - Iseva ye-MySQL.Udinga le nketho ngaphandle uma ufuna kuphela ukuxhuma kuseva ye-MySQL esebenza komunye umshini.
• MySQL-client - Uhlelo lweklayenti le-MySQL, elisetshenziselwa ukuxhuma nokusebenzisa iseva ye-Mysql.
• I-MySQL-develop - Imitapo yolwazi kanye namafayela, uma ufuna ukuhlanganisa amanye amaklayenti e-MySQL, njengamamojula we-Perl, udinga ukufaka le phakheji ye-RPM.
• I-MySQL-yabiwe - Kufanele软件Iphakheji iqukethe amalabhulali abiwe (libmysqlclient.so*) izilimi ezithile nezinhlelo zokusebenza ezidinga ukulayishwa ngamandla, kusetshenziswa i-MySQL.
• MySQL-bench - Ithuluzi lokulinganisa kanye nokusebenza kwe-MySQL database server.

Okulandelayo thina I-Centos Sebenzisa umyalo we-yum ukufaka i-MySql ngaphansi kwesistimu:

Hlola ukuthi uhlelo luza ne-mysql efakiwe:

rpm -qa | grep mysql

Uma isistimu yakho iyifakile, ungakhetha ukuyikhipha:

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

Faka i-mysql:

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

Qala i-mysql:

service mysqld start

Qaphela:Uma siqala isevisi ye-mysql okokuqala, iseva ye-mysql izoqala ukwenza ukumisa kokuqala.

Ku-CentOS 7, njengoba i-database ye-MySQL isusiwe ohlwini oluzenzakalelayo lwezinhlelo, ungasebenzisa i-mariadb esikhundleni salokho:

yum install mariadb-server mariadb 

Imiyalo efanele yesizindalwazi se-mariadb yilena:

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

Qinisekisa ukufakwa kwe-Mysql

Ngemva kokufaka ngempumelelo i-Mysql, amanye amathebula ayisisekelo azoqaliswa. Ngemva kokuthi iseva isiqalile, ungaqinisekisa ukuthi i-Mysql isebenza kahle ngokuhlolwa okulula.

Sebenzisa ithuluzi le-mysqladmin ukuze uthole isimo seseva:

Sebenzisa umyalo we-mysqladmin ukuhlola inguqulo yeseva, kanambambili itholakala ku-/usr/bin ku-linux ku-linux kanye no-C:\mysql\bin kumafasitela.

[root@host]# mysqladmin --version

Lo myalo ku-linux uzokhipha imiphumela elandelayo, ngokusekelwe kulwazi lwesistimu yakho:

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

Uma kungekho lwazi olufakiwe ngemuva kokuthi umyalo ongenhla ukhishwe, kusho ukuthi i-Mysql yakho ayifakiwe ngempumelelo.

Sebenzisa i-MySQL Client (iklayenti le-Mysql) ukuze wenze imiyalo elula ye-SQL

Ungasebenzisa umyalo we-mysql ukuze uxhume kuseva ye-Mysql kuKlayenti le-MySQL (iklayenti le-Mysql). Ngokuzenzakalelayo, igama-mfihlo leseva ye-Mysql ayinalutho, ngakho lesi sibonelo asidingi ukufaka iphasiwedi.

Umyalo umi kanje:

[root@host]# mysql

Ngemva kokukhishwa komyalo ongenhla, i-mysql> prompt izophuma, okusho ukuthi uxhume ngempumelelo kuseva ye-Mysql.Ungenza umyalo we-SQL ku-mysql> ngokushesha:

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

Okufanele kwenziwe ngemuva kokufakwa kwe-Mysql

Ngemuva kokuthi i-Mysql ifakwe ngempumelelo, iphasiwedi yomsebenzisi ezenzakalelayo ayinalutho, ungasebenzisa umyalo olandelayo ukudala iphasiwedi yomsebenzisi wempande:

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

Manje usungakwazi ukuxhuma kuseva ye-Mysql ngomyalo olandelayo:

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

Qaphela:Uma ufaka iphasiwedi, iphasiwedi ngeke iboniswe, ungayifaka ngendlela efanele.

Faka i-Mysql ku-Windows

Ukufaka i-Mysql ku-Window kulula, udinga kuphela Landa i-MySQLLanda inguqulo ye-Windows yephakheji yokufaka ye-mysql bese ucindezela iphakheji yokufaka.

Chofoza kabili ifayela le-setup.exe, bese udinga kuphela ukufaka ukucushwa okuzenzakalelayo bese uchofoza "okulandelayo" Ngokuzenzakalelayo, imininingwane yokufaka izoba ku-C:\mysql lwemibhalo.

Okulandelayo, ungashintshela kumkhombandlela we-C:\mysql\bin ku-command prompt ngokusebenzisa umyalo othi "Start" = "input "cmd" ebhokisini lokusesha, bese ufaka umyalo:

mysqld.exe --console

Uma ukufakwa kuphumelele, umyalo ongenhla uzokhipha ukuqaliswa kwe-mysql kanye nolwazi lwe-InnoDB.