Uyifaka njani idatabase yeMySQL?Faka i-mysql inyathelo ngesinyathelo isifundo

Uyifaka njani i-database ye-MySQL ? Isifundo sokufaka i -MySQL.

MySQL ufakelo

Idilesi yokukhuphela ye-MySQL kuzo zonke iiplatifomu yile: MySQL Download . Khetha inguqulelo ye-MySQL Community Server kunye neqonga elihambelanayo olifunayo .


LinuxFaka iMysql kwi/UNIX

Kucetyiswa ukuba usebenzise iphakheji yeRPM ukufaka iMysql kwiqonga leLinux.I-MySQL AB ibonelela ngedilesi yokukhuphela yale phakheji ilandelayo yeRPM:

  • MySQL -Iseva yeMySQL.Udinga olu khetho ngaphandle kokuba ufuna kuphela ukudibanisa kumncedisi we-MySQL osebenza komnye umatshini.
  • MySQL-umthengi -Inkqubo yomxhasi weMySQL, esetyenziselwa ukudibanisa nokusebenza iseva yeMysql.
  • MySQL-uphuhliso -Amathala eencwadi kunye nokubandakanya iifayile, ukuba ufuna ukuqokelela abanye abathengi beMySQL, njengeemodyuli zePerl, kufuneka ufake le phakheji yeRPM.
  • I-MySQL-kwabelwana ngayo - Kufuneka软件Iphakheji iqulathe amathala eencwadi ekwabelwana ngawo (libmysqlclient.so*) ukuba iilwimi ezithile kunye nezicelo kufuneka zilayishe ngokuguquguqukayo, usebenzisa i-MySQL.
  • MySQL-ibhentshi -Isixhobo sokuvavanya kunye nokusebenza kwiseva yedatha yeMySQL.

Okulandelayo, siza kusebenzisa umyalelo we-yum ukufaka i-MySQL kwinkqubo ye-CentOS :

Jonga ukuba inkqubo iza ne-mysql efakiweyo:

rpm -qa | grep mysql

Ukuba isixokelelwano sakho siyifakile, ungakhetha ukuyikhupha:

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

Faka i-mysql:

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

Qalisa i-mysql:

service mysqld start

Qaphela: Ukuba le yithuba lokuqala siqala inkonzo ye-MySQL, iseva ye-MySQL iya kuqala yenze uqwalaselo lokuqala.

Kwimeko ye-CentOS 7 version, ekubeni i-database ye-MySQL isusiwe kuluhlu lwenkqubo olungagqibekanga, i-mariadb ingasetyenziswa endaweni yoko:

yum install mariadb-server mariadb 

Imiyalelo efanelekileyo yesiseko sedatha ye-mariadb yile:

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

Qinisekisa ukufakwa kweMysql

Emva kofakelo oluyimpumelelo lweMysql, ezinye iitafile ezisisiseko ziya kuqaliswa Emva kokuba umncedisi eqalisiwe, unokuqinisekisa ukuba iMysql isebenza ngokufanelekileyo ngovavanyo olulula.

Sebenzisa isixhobo se-mysqladmin ukufumana ubume beseva:

Sebenzisa umyalelo we-mysqladmin ukujonga uguqulelo lomncedisi, i-binary ibekwe kwi / usr / bin kwi-linux kwi-linux kunye ne-C: \ mysql \ bin kwiifestile.

[root@host]# mysqladmin --version

Lo myalelo kwi-linux uya kuvelisa ezi ziphumo zilandelayo, ngokusekelwe kwindlela yakho yolwazi:

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

Ukuba akukho lwazi lungenisiweyo emva kokuba lo myalelo ungentla uphunyeziwe, kuthetha ukuba iMysql ayifakwanga ngempumelelo.


Sebenzisa i-MySQL Client (umxhasi weMysql) ukwenza imiyalelo elula yeSQL

Ungasebenzisa umyalelo we-mysql ukuxhuma kumncedisi we-Mysql kwi-MySQL Client (umxhasi we-Mysql) Ngokungagqibekanga, igama eliyimfihlo leseva ye-Mysql ayinanto, ngoko lo mzekelo awufuni ukufaka igama eliyimfihlo.

Lo myalelo ulandelayo:

[root@host]# mysql

Emva kokuba lo myalelo ungentla uphunyeziwe, mysql> ukukhawuleza kuya kuphuma, okuthetha ukuba uqhagamshele ngempumelelo kwiseva yeMysql Unokwenza umyalelo weSQL kwi-mysql> ngokukhawuleza:

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

Yintoni ekufuneka yenziwe emva kokuba iMysql ifakiwe

Emva kokuba iMysql ifakwe ngempumelelo, igama eliyimfihlo lomsebenzisi elingenasiphelo alinanto, ungasebenzisa lo myalelo ulandelayo ukwenza igama eligqithisiweyo lomsebenzisi:

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

Ngoku ungaqhagamshela kwiseva yeMysql ngalo myalelo ulandelayo:

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

Qaphela: Igama eligqithisiweyo alizukubonwa xa ulifaka; lifake ngokuchanekileyo.


Faka iMysql kwiWindows

Ukufaka i-MySQL kwiWindows kulula kakhulu. Udinga nje ukukhuphela inguqulelo yeWindows yesifaki se-MySQL kwiphepha lokukhuphela le-MySQL uze ukhuphe iphakheji.

Cofa kabini ifayile ye-setup.exe, emva koko kufuneka ufake kuphela ukucwangciswa okungagqibekanga kwaye nqakraza "olandelayo" Ngokungagqibekanga, ulwazi lofakelo luya kuba kwiC: \ mysql directory.

Okulandelayo, ungatshintshela kwi-C:\mysql\bin directory kwi-prompt prompt ngokusebenzisa "Qala" = "input "cmd" umyalelo kwibhokisi yokukhangela, kwaye ufake umyalelo:

mysqld.exe --console

Ukuba ukufakela kuphumelele, lo myalelo ungasentla uya kukhupha isiqalo se-mysql kunye nolwazi lwe-InnoDB.

Shiya uluvo

您的邮箱地址不会被公开。必填项已用*标注

Skrolela phezulu