Isalathiso senqaku
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 startQaphela: 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 mariadbImiyalelo 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.
Ngethemba, inqaku elithi "Ungayifaka njani iDatabase yeMySQL? Isifundo seNyathelo ngeNyathelo" elabelwana ngaso kwibhlog kaChen Weiliang ( https://www.chenweiliang.com/ ) liza kuba luncedo kuwe.
Zive ukhululekile ukwabelana ngekhonkco leli nqaku: https://www.chenweiliang.com/cwl-451.html
