Nzira yekuisa sei MySQL database?Isa mysql nhanho nhanho dzidzo

sei kuisaMySQL database?Installmysqlnhanho nhanho Tutorial

MySQL 安装

Iyo Mysql yekurodha kero yemapuratifomu ese ndeiyi: MySQL downloadSarudza zvaunoda MySQL Community Server shanduro uye chikuva chinoenderana.

LinuxIsa Mysql pa /UNIX

Zvinokurudzirwa kushandisa RPM package yekuisa Mysql paLinux platform.MySQL AB inopa kero yekurodha yeinotevera RPM package:

• MySQL -MySQL server.Iwe unoda iyi sarudzo kunze kwekunge iwe uchingoda kubatana kune MySQL server inoshanda pane mumwe muchina.
• MySQL-client -MySQL mutengi chirongwa, chinoshandiswa kubatanidza uye kushanda Mysql server.
• MySQL-kuvandudza -Maraibhurari uye anosanganisira mafaera, kana iwe uchida kuunganidza vamwe MySQL vatengi, senge Perl modules, unofanirwa kuisa iyi RPM package.
• MySQL-yakagovaniswa - Unofanira软件Iyo pasuru ine maraibhurari akagovaniswa (libmysqlclient.so*) ayo mimwe mitauro nemashandisirwo anoda kurodha zvine simba, uchishandisa MySQL.
• MySQL-bhenji -Chiyereso uye mashandiro ekuyedza chishandiso cheMySQL dhatabhesi server.

Tinotevera isu cents Shandisa iyo yum command kuisa MySql pasi pehurongwa:

Tarisa kana iyo system inouya ne mysql yakaiswa:

rpm -qa | grep mysql

Kana system yako yaiisa, unogona kusarudza kuibvisa:

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

Isa mysql:

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

Kutanga mysql:

service mysqld start

Ongorora:Kana isu tikatanga iyo mysql sevhisi kekutanga, iyo mysql server inotanga kuita yekutanga kugadzirisa.

Kana iri yeCentOS 7 vhezheni, sezvo iyo MySQL dhatabhesi yakabviswa kubva pane yakasarudzika chirongwa rondedzero, mariadb inogona kushandiswa pachinzvimbo:

yum install mariadb-server mariadb 

Iyo yakakodzera mirairo yeiyo mariadb dhatabhesi ndeiyi:

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

Simbisa kuisirwa kweMysql

Mushure mekubudirira kuisirwa kweMysql, mamwe matafura ekutanga achatangwa. Mushure mekunge sevha yatangwa, unogona kuona kuti Mysql iri kushanda nemazvo nekuyedza nyore.

Shandisa iyo mysqladmin chishandiso kuti uwane mamiriro eseva:

Shandisa mysqladmin murairo kutarisa shanduro yevhavha, iyo bhinari iri pa / usr / bin pa linux pa linux uye C: \ mysql \ bin pamahwindo.

[root@host]# mysqladmin --version

Uyu murairo palinux unoburitsa zvinotevera mhedzisiro, zvichibva pane yako system ruzivo:

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

Kana pasina ruzivo rwakapinzwa mushure mekunge murairo wepamusoro waitwa, zvinoreva kuti Mysql yako haina kuiswa zvinobudirira.

Shandisa MySQL Client (Mysql mutengi) kuita zviri nyore SQL mirairo

Unogona kushandisa mysql command kuti ubatanidze kuMysql server muMySQL Client (Mysql client) By default, password yeMysql server haina chinhu, saka chiitiko ichi hachidi kuisa password.

Murairo ndeuyu:

[root@host]# mysql

Mushure mekunge murairo uri pamusoro waitwa, mysql> prompt ichabuda, zvinoreva kuti wakanyatsobatana neMysql server. Unogona kuita murairo weSQL pane mysql> nokukurumidza:

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

Chii chinoda kuitwa mushure mekunge Mysql yaiswa

Mushure mekunge Mysql yaiswa zvinobudirira, iyo default mudzi mushandisi password haina chinhu, unogona kushandisa unotevera kuraira kugadzira iyo mudzi mushandisi password:

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

Iye zvino unogona kubatana neMysql server nemurairo unotevera:

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

Ongorora:Paunenge uchiisa password, password haizoonekwe, unogona kuiisa nenzira kwayo.

Isa Mysql paWindows

Kuisa Mysql paWindows kuri nyore, iwe unongoda kudaro MySQL downloadDhawunirodha iyo Windows vhezheni yeiyo mysql yekuisa package uye decompress yekuisa pasuru.

Dzvanya kaviri setup.exe faira, ipapo iwe unongoda kuisa iyo yakasarudzika gadziriso uye dzvanya "inotevera".Nekusagadzikana, iyo yekuisa ruzivo ichave iri muC:\mysql dhairekitori.

Tevere, unogona kushandura kuC:\mysql\bin dhairekitori pane yekuraira nekukurumidza kuburikidza ne "Start" = "input"cmd" command mubhokisi rekutsvaga, uye isa murairo:

mysqld.exe --console

Kana iyo yekumisikidza ikabudirira, iwo murairo uri pamusoro unoburitsa imwe mysql yekutanga uye InnoDB ruzivo.