Me pehea te whakahaere i te patengi raraunga MySQL? Nga Tono SSH ki te Whakahaere i nga Tūmau MySQL

me pehea te whakahaerepātengi raraunga MySQL? Whakahaere whakahau SSHMySQL服务器

MySQL Te whakahaere

Tīmatahia ka mutu te tūmau MySQL

Tuatahi, me tirotiro mena kei te eke te tūmau MySQL ma te whakahaere i te whakahau e whai ake nei:

ps -ef | grep mysqld

Mena kua timata a MySql, ko te whakahau i runga ake ka whakaputa i te rarangi o nga tukanga mysql, ki te kore e timata te mysql, ka taea e koe te whakamahi i te whakahau e whai ake nei hei timata i te tūmau mysql:

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

Mena kei te hiahia koe ki te kati i te tūmau MySQL e whakahaere ana i tenei wa, ka taea e koe te whakahaere i te whakahau e whai ake nei:

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

Tautuhinga Kaiwhakamahi MySQL

Mena ka hiahia koe ki te taapiri i tetahi kaiwhakamahi MySQL, me whakauru noa koe i te kaiwhakamahi hou ki te ripanga kaiwhakamahi kei roto i te papaarangi mysql.

Ko te tauira e whai ake nei mo te taapiri i tetahi kaiwhakamahi, ko te ingoa kaiwhakamahi he manuhiri, ko te kupuhipa he manuhiri123, ka whakamanahia te kaiwhakamahi ki te mahi i nga mahi SELECT, INSERT and 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)

I te taapiri i tetahi kaiwhakamahi, me mahara kei te whakamunatia te kupuhipa ma te whakamahi i te mahi PASSWORD() na MySQL.Ka taea e koe te kite i roto i te tauira i runga ake nei ko te kupuhipa kaiwhakamahi kua whakamunatia ko: 6f8c114b58f2ce9e.

Tuhipoka:I roto i te MySQL 5.7, kua whakakapihia te kupuhipa o te ripanga kaiwhakamahi eaho_whakamotuhēhē.

Tuhipoka:Kia mohio ki te hiahia ki te whakatinana WHAKAMAHI KAUPAPA korero.Ka oti tenei whakahau, ka utaina ano te ripanga tuku.

Ki te kore koe e whakamahi i tenei whakahau, kare e taea e koe te whakamahi i te kaiwhakamahi hou i hangaia hei hono atu ki te tūmau mysql mena ka timata ano koe i te tūmau mysql.

I te wa e hanga ana he kaiwhakamahi, ka taea e koe te tohu whakaaetanga mo te kaiwhakamahi. I roto i te pou whakaaetanga e rite ana, tautuhia ki 'Y' i roto i te tauākī whakauru. Ko te rarangi o nga whakaaetanga kaiwhakamahi e whai ake nei:

• Select_priv
• Insert_priv
• Update_priv
• Mukua_priv
• Waihanga_priv
• drop_priv
• Utaina_priv
• shutdown_priv
• Tukatuka_priv
• Kōnae_priv
• Grant_priv
• Tohutoro_priv
• Taurangi_priv
• Alter_priv

Ko tetahi atu huarahi ki te taapiri i nga kaiwhakamahi ko te whakahau GRANT o SQL. Ko te whakahau e whai ake nei ka taapirihia te kaiwhakamahi zara ki nga TUTORIALS raraunga kua tohua, ko te kupu huna ko 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';

Ko te whakahau i runga ake nei ka hanga he rekoata korero mo te kaiwhakamahi ki te ripanga kaiwhakamahi i roto i te papaunga raraunga mysql.

Panui: Ka mutu nga tauākī MySQL SQL ki te tohutoro (;).

/etc/my.cnf whirihoranga kōnae

I raro i nga ahuatanga noa, kaore koe e hiahia ki te whakarereke i te konae whirihoranga, ko te whirihoranga taunoa o te konae e whai ake nei:

[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

I roto i te konae whirihoranga, ka taea e koe te tautuhi i te raarangi e penapena ai nga konae raarangi hapa rereke. Ko te tikanga, kaore koe e hiahia ki te whakarereke i enei whirihoranga.

Nga whakahau ki te whakahaere MySQL

Ko enei e whai ake nei ka whakarārangihia nga whakahau e whakamahia nuitia ana i roto i te tukanga o te whakamahi i te papanga raraunga Mysql:

• WHAKAMAHI ingoa rokiroki raraunga :
  Tīpakohia te pātengi raraunga Mysql hei whakahaere. I muri i te whakamahi i tenei whakahau, ko nga tono Mysql katoa mo tenei putunga anake.

  mysql> use chenweiliang;
  Database changed

• WHAKAATU I NGA PAPA KAUPAPA: 
  Ka whakarārangihia te rārangi pātengi raraunga o te pūnaha whakahaere pātengi raraunga MySQL.

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

• Whakaaturia nga Ripanga:
  Whakaatuhia nga ripanga katoa o te putunga korero.

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

• Whakaaturia nga tīwae mai Whakaahuatanga:
  Whakaatuhia nga huanga ripanga raraunga, nga momo huanga, nga korero matua matua, ahakoa he NULL, he uara taunoa me etahi atu korero.

  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)

• WHAKAATU I TE WHAKATAUTANGA MAI Whakaahuatanga:
  Whakaatuhia nga korero taurangi taipitopito o te ripanga raraunga, tae atu ki te KEY TUATAHI (matua matua).

  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)

• WHAKAATU TE TURANGA TIPIPE PAI [MAI i te db_ingoa] [PAI ki te 'tauira'] \G:
  Ma tenei whakahau ka whakaputa i nga mahi me nga tatauranga o te punaha whakahaere papaa raraunga 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，查询结果按列打印