Otu esi ejikwa MySQL nchekwa data? Iwu SSH iji jikwaa sava MySQL

ka esi jikwaaMySQL nchekwa data? Njikwa iwu SSHMySQL服务器

MySQL Nchịkwa

Malite ma kwụsị ihe nkesa MySQL

Nke mbụ, anyị kwesịrị ịlele ma ọ bụrụ na ihe nkesa MySQL dị elu site na iji iwu a:

ps -ef | grep mysqld

Ọ bụrụ na amalitelarị MySql, iwu dị n'elu ga-ewepụta ndepụta nke usoro mysql, ọ bụrụ na mysql amaliteghị, ịnwere ike iji iwu na-esonụ iji malite ihe nkesa mysql:

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

Ọ bụrụ na ịchọrọ imechi ihe nkesa MySQL na-agba ọsọ ugbu a, ị nwere ike mezuo iwu a:

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

Ntọala onye ọrụ MySQL

Ọ bụrụ na ịchọrọ ịgbakwunye onye ọrụ MySQL, naanị ị ga-agbakwunye onye ọrụ ọhụrụ na tebụl onye ọrụ na nchekwa data mysql.

Ihe a bụ ọmụmaatụ ịgbakwunye onye ọrụ, aha njirimara bụ ọbịa, paswọọdụ bụ ọbịa123, yana onye ọrụ nyere ikike ịrụ ọrụ SELECT, INSERT na Mmelite:

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)

Mgbe ị na-agbakwunye onye ọrụ, biko mara na ezoro ezo paswọọdụ site na iji ọrụ PASSWORD() nke MySQL nyere.Ị nwere ike ịhụ na ihe atụ dị n'elu na paswọọdụ onye ọrụ ezoro ezo bụ: 6f8c114b58f2ce9e.

Mara:Na MySQL 5.7, ejirila dochie paswọọdụ nke tebụl onye ọrụnkwenye_string.

Mara:Mara na ọ dị mkpa imejuputa ya EZIGBO IKE nkwupụta.Mgbe emechara iwu a, a ga-ebugharị tebụl onyinye.

Ọ bụrụ na ijighị iwu a, ị gaghị enwe ike iji onye ọrụ emepụtara ọhụrụ jikọọ na sava mysql ọ gwụla ma ịmalitegharịa ihe nkesa mysql.

Mgbe ị na-eke onye ọrụ, ị nwere ike ịkọwapụta ikike maka onye ọrụ. Na kọlụm ikike kwekọrọ, tọọ ya na 'Y' na nkwupụta ntinye. Ndepụta ikike onye ọrụ bụ nke a:

• Họrọ_priv
• Tinye_priv
• Mmelite_priv
• Hichapụ_priv
• Mepụta_priv
• drop_priv
• Bugharịa_priv
• shutdown_priv
• Usoro_priv
• Faịlụ_priv
• Grant_priv
• Ntụaka_priv
• Index_priv
• Alter_priv

Ụzọ ọzọ ị ga-esi tinye ndị ọrụ bụ site na iwu GRANT nke SQL. Iwu na-esote ga-agbakwunye zara onye ọrụ na TUTORIALS nchekwa data akọwapụtara, na paswọọdụ bụ 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';

Iwu a dị n'elu ga-emepụta ndekọ ozi onye ọrụ na tebụl onye ọrụ na nchekwa data mysql.

Mara: Akwụsịla nkwupụta MySQL SQL site na nkeji nkeji (;).

/etc/my.cnf nhazi faịlụ

N'okpuru ọnọdụ nkịtị, ọ dịghị mkpa ka ị gbanwee faịlụ nhazi, nhazi ndabara nke faịlụ ahụ bụ nke a:

[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

Na faịlụ nhazi, ị nwere ike ịkọwa ndekọ ebe echekwara faịlụ ndekọ njehie dị iche iche. N'ozuzu, ịkwesighi ịgbanwe nhazi ndị a.

Iwu iji jikwaa MySQL

Ndị a na-edepụta iwu ndị a na-ejikarị na usoro iji nchekwa data Mysql:

• Jiri aha nchekwa data :
  Họrọ ebe nchekwa data Mysql ka a ga-arụ ọrụ.Mgbe ijiri iwu a, iwu Mysql niile bụ naanị maka nchekwa data a.

  mysql> use chenweiliang;
  Database changed

• Gosi data data: 
  Na-edepụta ndepụta nchekwa data nke sistemụ njikwa nchekwa data MySQL.

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

• Gosi tebụl:
  Na-egosiputa tebụl niile nke nchekwa data akọwapụtara tupu iji iwu a, ịkwesịrị iji iwu ojiji họrọ nchekwa data a ga-arụ ọrụ.

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

• Gosi kọlụm si akwụkwọ data:
  Gosipụta àgwà tebụl data, ụdị njirimara, ozi isi isi, ma ọ bụ NULL, ụkpụrụ ndabara na ozi ndị ọzọ.

  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)

• Gosi INDEX SITE akwụkwọ data:
  Gosipụta ozi ndeksi zuru ezu nke tebụl data, gụnyere igodo isi (isi igodo).

  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)

• Gosi ọnọdụ tebụl dị ka [Site na db_name] [Dị ka 'ụkpụrụ'] \ G:
  Iwu a ga-ewepụta arụmọrụ na ọnụ ọgụgụ nke sistemu njikwa nchekwa data 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，查询结果按列打印