Me pehea te whakauru i te papanga raraunga MySQL?Tāutahia te akoranga mysql ma te taahiraa

me pehea te whakaurupātengi raraunga MySQL?Tāutamysqltaahiraa i te taahiraa akoranga

MySQL Tuhinga

Ko te wahitau tango Mysql mo nga papaaho katoa ko: Tikiake MySQLWhiriwhiria taau e hiahia ana MySQL Community Server putanga me te turanga e rite ana.

LinuxTāutahia a Mysql ki runga /UNIX

E taunaki ana ki te whakamahi i te kete RPM hei whakauru i a Mysql ki runga i te papaaho Linux. Ka tukuna e MySQL AB te wahitau tangohanga o te kete RPM e whai ake nei:

• MySQL – tūmau MySQL.Ka hiahia koe ki tenei whiringa mena ka hiahia koe ki te hono atu ki tetahi tūmau MySQL e rere ana i runga i tetahi atu miihini.
• MySQL-kiritaki – Hotaka kiritaki MySQL, i whakamahia hei hono me te whakahaere i te tūmau Mysql.
• MySQL-whakawhanake – Wharepukapuka me te whakauru i nga konae, mena ka hiahia koe ki te whakahiato i etahi atu kaihoko MySQL, penei i nga waahanga Perl, me whakauru koe i tenei kete RPM.
• MySQL-tiritiri - Me软件Kei roto i te kete nga whare pukapuka tiritiri (libmysqlclient.so*) e hiahia ana etahi reo me etahi tono ki te uta i runga i a MySQL.
• MySQL-paepae – He tohu tohu me te taputapu whakamatautau mahi mo te tūmau pātengi raraunga MySQL.

Ko tatou kei muri Nga pokapū Whakamahia te whakahau yum hei whakauru i a MySql i raro i te punaha:

Tirohia mehemea ka tae mai te punaha me te whakauru mysql:

rpm -qa | grep mysql

Mena kua whakauruhia e to punaha, ka taea e koe te whiriwhiri ki te tango:

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

Tāuta mysql:

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

Tīmatahia te mysql:

service mysqld start

Tuhipoka:Mena ka timata tatou i te ratonga mysql mo te wa tuatahi, ka mahia e te tūmau mysql te whirihoranga tuatahi.

Mo te CentOS 7, i te mea kua tangohia te paataka raraunga MySQL mai i te rarangi taunoa o nga papatono, ka taea e koe te whakamahi mariadb hei utu:

yum install mariadb-server mariadb 

Ko nga whakahau e tika ana mo te papaa raraunga mariadb ko:

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

Manatokohia te whakaurunga Mysql

I muri i te whakaurunga angitu o Mysql, ka arawhiti etahi ripanga taketake.I muri i te tiimata o te tūmau, ka taea e koe te manatoko kei te mahi tika a Mysql ma te whakamatautau ngawari.

Whakamahia te taputapu mysqladmin ki te tiki i te mana tūmau:

Whakamahia te whakahau mysqladmin ki te tirotiro i te putanga o te tūmau, kei te /usr/bin i runga i linux i runga i linux me C:\mysql\bin on windows.

[root@host]# mysqladmin --version

Ko tenei whakahau i runga i te linux ka puta nga hua e whai ake nei, i runga i to korero punaha:

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

Mena kaore he korero i whakauruhia i muri i te whakahaerenga o te whakahau i runga ake nei, ko te tikanga kaore to Mysql i whakauru pai.

Whakamahia te Kiritaki MySQL (Mysql client) ki te whakahaere i nga whakahau SQL ngawari

Ka taea e koe te whakamahi i te whakahau mysql ki te hono atu ki te tūmau Mysql i roto i te Kiritaki MySQL (Mysql client) Ma te taunoa, ka noho kau te kupuhipa o te tūmau Mysql, no reira kaore tenei tauira e hiahia ki te whakauru i te kupuhipa.

Ko te whakahau e whai ake nei:

[root@host]# mysql

I muri i te whakahaerenga o te whakahau i runga ake nei, ka puta te mysql> prompt, te tikanga kua hono pai koe ki te tūmau Mysql. Ka taea e koe te whakahaere i te whakahau SQL i te mysql> prompt:

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

He aha me mahi i muri i te whakaurutanga o Mysql

I muri i te whakaurunga a Mysql, ka noho kau te kupuhipa kaiwhakamahi taunoa, ka taea e koe te whakamahi i te whakahau e whai ake nei hei hanga i te kupuhipa kaiwhakamahi pakiaka:

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

Ka taea e koe te hono atu ki te tūmau Mysql me te whakahau e whai ake nei:

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

Tuhipoka:A, no te whakauru i te kupuhipa, kaore te kupuhipa e whakaatuhia, ka taea e koe te whakauru tika.

Tāutahia a Mysql ki Windows

He ngawari noa te whakauru i a Mysql ki Windows, me mahi noa koe Tikiake MySQLTikiake i te putanga Windows o te mōkihi tāutanga mysql ka whakakore i te mōkihi tāutanga.

Patohia-rua te konae setup.exe, katahi ka hiahia koe ki te whakauru i te whirihoranga taunoa ka paato "panuku" Ma te taunoa, ka uru nga korero whakaurunga ki te raarangi C:\mysql.

I muri mai, ka taea e koe te huri ki te raarangi C:\mysql\bin i runga i te whakahau whakahau ma te "Tīmata" = "whakauru "cmd" whakahau ki te pouaka rapu, ka uru ki te whakahau:

mysqld.exe --console

Mena kua angitu te whakaurunga, ko te whakahau i runga ake nei ka whakaputa etahi korero whakaoho mysql me nga korero InnoDB.