Mokhoa oa ho tsamaisa database ea MySQL? Litaelo tsa SSH ho Laola Li-server tsa MySQL

mokhoa oa ho laolaMySQL database? Tsamaiso ea taelo ea SSHMySQL服务器

MySQL Tsamaiso

Qala le ho emisa seva sa MySQL

Ntlha ea pele, re hloka ho hlahloba hore na seva sa MySQL se phahame ka ho sebelisa taelo e latelang:

ps -ef | grep mysqld

Haeba MySql e se e qalile, taelo e ka holimo e tla hlahisa lethathamo la mekhoa ea mysql, haeba mysql e sa qalisoa, u ka sebelisa taelo e latelang ho qala seva sa mysql:

root@host# cd /usr/bin
./mysqld_safe &

Haeba u batla ho koala seva sa MySQL se sebetsang hona joale, u ka phethahatsa taelo e latelang:

root@host# cd /usr/bin
./mysqladmin -u root -p shutdown
Enter password: ******

Litlhophiso tsa Basebelisi ba MySQL

Haeba o hloka ho eketsa mosebelisi oa MySQL, o hloka feela ho kenyelletsa mosebelisi e mocha tafoleng ea mosebelisi ho database ea mysql.

Se latelang ke mohlala oa ho eketsa mosebelisi, lebitso la mosebelisi ke moeti, phasewete ke moeti123, mme mosebelisi o lumelletsoe ho etsa ts'ebetso ea KHETHA, HO INSERT le UPDATE:

root@host# mysql -u root -p
Enter password:*******
mysql> use mysql;
Database changed

mysql> INSERT INTO user 
          (host, user, password, 
           select_priv, insert_priv, update_priv) 
           VALUES ('localhost', 'guest', 
           PASSWORD('guest123'), 'Y', 'Y', 'Y');
Query OK, 1 row affected (0.20 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 1 row affected (0.01 sec)

mysql> SELECT host, user, password FROM user WHERE user = 'guest';
+-----------+---------+------------------+
| host      | user    | password         |
+-----------+---------+------------------+
| localhost | guest | 6f8c114b58f2ce9e |
+-----------+---------+------------------+
1 row in set (0.00 sec)

Ha o eketsa mosebelisi, ka kopo hlokomela hore phasewete e ngotsoe ka mokhoa oa PASSWORD() o fanoeng ke MySQL.U ka bona mohlaleng o ka holimo hore password ea mosebelisi e kentsoeng ke: 6f8c114b58f2ce9e.

Tlhokomeliso:Ho MySQL 5.7, phasewete ea tafole ea basebelisi e nkeloe sebaka keauthentication_string.

Tlhokomeliso:Hlokomela tlhoko ea ho kenya ts'ebetsong LITS'ELISITSOE LITOKELO polelo.Ka mor'a hore taelo ena e phethoe, tafole ea liphallelo e tla tsosolosoa hape.

Haeba u sa sebelise taelo ena, u ke ke ua khona ho sebelisa mosebelisi ea sa tsoa bōptjoa ho hokahanya le seva sa mysql ntle le haeba u qala seva sa mysql hape.

Ha o theha mosebelisi, o ka hlakisa litumello bakeng sa mosebelisi. Khomong ea tumello e tsamaellanang, e behe ho 'Y' polelong e kentsoeng. Lenane la tumello ea mosebelisi le tjena:

• Khetha_priv
• Insert_priv
• Update_priv
• Hlakola_priv
• Create_priv
• drop_priv
• Reload_priv
• shutdown_priv
• Tshebetso_priv
• File_priv
• Grant_priv
• Litšupiso_priv
• Index_priv
• Alter_priv

Mokhoa o mong oa ho eketsa basebelisi ke ka taelo ea GRANT ea SQL.Taelo e latelang e tla kenya mosebelisi zara ho database e boletsoeng TUTORIALS, mme password ke zara123.

root@host# mysql -u root -p password;
Enter password:*******
mysql> use mysql;
Database changed

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    -> ON TUTORIALS.*
    -> TO 'zara'@'localhost'
    -> IDENTIFIED BY 'zara123';

Taelo e kaholimo e tla theha rekoto ea tlhaiso-leseling ea mosebelisi tafoleng ea mosebelisi ho database ea mysql.

Hlokomela: Lipolelo tsa MySQL SQL li felisitsoe ka semicolon (;).

/etc/my.cnf faele tlhophiso

Tlas'a maemo a tloaelehileng, ha ho hlokahale hore u fetole faele ea tlhophiso, tlhophiso ea kamehla ea faele e tjena:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Ka faeleng ea tlhophiso, o ka hlakisa bukana moo lifaele tse fapaneng tsa liphoso li bolokiloeng.Ka kakaretso, ha ho hlokahale hore u fetole litlhophiso tsena.

Litaelo tsa ho tsamaisa MySQL

Lintlha tse latelang li thathamisa litaelo tse sebelisoang hangata ts'ebetsong ea ho sebelisa database ea Mysql:

• SEBELISA lebitso la polokelo ya data :
  Khetha database ea Mysql e tla sebetsoa.Ka mor'a ho sebelisa taelo ena, litaelo tsohle tsa Mysql ke tsa database ena feela.

  mysql> use chenweiliang;
  Database changed

• BONTŠA DATABASE: 
  E thathamisa lethathamo la database la sistimi ea taolo ea database ea MySQL.

  mysql> SHOW DATABASES;
  +--------------------+
  | Database           |
  +--------------------+
  | information_schema |
  | chenweiliang             |
  | cdcol              |
  | mysql              |
  | onethink           |
  | performance_schema |
  | phpmyadmin         |
  | test               |
  | wecenter           |
  | wordpress          |
  +--------------------+
  10 rows in set (0.02 sec)

• BONTŠA TAFOLE:
  E bonts'a litafole tsohle tsa database tse boletsoeng Pele o sebelisa taelo ena, o hloka ho sebelisa taelo ea tšebeliso ho khetha polokelongtshebetso e tla sebetswa.

  mysql> use chenweiliang;
  Database changed
  mysql> SHOW TABLES;
  +------------------+
  | Tables_in_chenweiliang |
  +------------------+
  | employee_tbl     |
  | chenweiliang_tbl       |
  | tcount_tbl       |
  +------------------+
  3 rows in set (0.00 sec)

• BONTŠA LIKHOLOMO TŠOA leqephe la lintlha:
  Bontša litšoaneleho tsa tafole ea data, mefuta ea semelo, tlhaiso-leseling ea mantlha, hore na ke NULL, boleng ba kamehla le tlhaiso-leseling e ngoe.

  mysql> SHOW COLUMNS FROM chenweiliang_tbl;
  +-----------------+--------------+------+-----+---------+-------+
  | Field           | Type         | Null | Key | Default | Extra |
  +-----------------+--------------+------+-----+---------+-------+
  | chenweiliang_id       | int(11)      | NO   | PRI | NULL    |       |
  | chenweiliang_title    | varchar(255) | YES  |     | NULL    |       |
  | chenweiliang_author   | varchar(255) | YES  |     | NULL    |       |
  | submission_date | date         | YES  |     | NULL    |       |
  +-----------------+--------------+------+-----+---------+-------+
  4 rows in set (0.01 sec)

• BONTŠA INDEX TSOA leqephe la lintlha:
  Hlahisa lintlha tse qaqileng tsa index tsa tafole ea data, ho kenyeletsoa PRIMARY KEY (senotlolo sa mantlha).

  mysql> SHOW INDEX FROM chenweiliang_tbl;
  +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  | Table      | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
  +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  | chenweiliang_tbl |          0 | PRIMARY  |            1 | chenweiliang_id   | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
  +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  1 row in set (0.00 sec)

• BONTŠA MAEMO A TABELA JOALOKA [HO TSOA db_name] [LIKE 'pattern'] \G:
  Taelo ena e tla hlahisa ts'ebetso le lipalo-palo tsa sistimi ea taolo ea database ea Mysql.

  mysql> SHOW TABLE STATUS  FROM chenweiliang;   # 显示数据库 chenweiliang 中所有表的信息
  
  mysql> SHOW TABLE STATUS from chenweiliang LIKE 'chenweiliang%';     # 表名以chenweiliang开头的表的信息
  mysql> SHOW TABLE STATUS from chenweiliang LIKE 'chenweiliang%'\G;   # 加上 \G，查询结果按列打印