Quomodo administrare MySQL database? SSH mandatum administrare MySQL servo

quam administrareMySQL database? SSH imperium procuratioMySQLservo

MySQL Management

Incipere et prohibere in MySQL servo

Primum, necesse est ut si MySQL ministrator inspiciat, currendo mandatum sequens est:

ps -ef | grep mysqld

Si MySql iam incepit, mandatum superius ponet album processuum mysql, si mysql non incipiet, sequenti mandato uti potes ut servo mysql incipias:

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

Si vis claudere currentem MySQL cultorem, hoc mandatum exequi potes:

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

MySQL User Occasus

Si debes addere MySQL usorem, tantum debes addere novum usorem ad mensam usoris in mysql datorum.

Hoc exemplum est addendi utentis, nomen usoris hospes, tessera hospita est 123, usor licitum est ad operationes SELECT, INDO et UPDATE perficiendas;

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)

Cum usorem addens, nota quaeso tesseram encryptam esse utens Tesserae () munus a MySQL provisum.In exemplo superiore videre potes tesseram usoris encryptae esse: 6f8c114b58f2ce9e.

Note:In MySQL 5.7, tessera usoris mensam reposita estauthentication_string.

Note:Senti de necessitate ad efficiendum COMINUS DE PRIVILEGIIS editio.Post hoc mandatum exequitur mensa donatio reload.

Si hoc praecepto non uteris, usore novo creato uti non poteris servo mysql coniungere nisi servo mysql sileo.

Cum utentem creando, licentias usoris exprimere potes, in columna permissionis respondente, pone eam ad 'Y' in enuntiatione inserta.

• Select_priv
• Insert_priv
• Update_priv
• Delete_priv
• Create_priv
• drop_priv
• Reload_priv
• shutdown_priv
• Process_priv
• File_priv
• Grant_priv
• References_priv
• Index_priv
• Alter_priv

Alius modus utentes addendi est per SQL GRATIA IMPERIUM. Proximus mandatum utentem zaram addet TUTORIALS datorum specificatorum, et signum est 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';

Praeceptum mandatum utentis informationes recordum in tabula utentis in mysql database creabit.

note: MySQL SQL dicta cum semicolon terminantur (;).

/etc/my.cnf lima configuration

In communibus adiunctis, limam configurationem mutare non debes, tabellae configuratio default talis est:

[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

In lima configuration, directorium specificare potes ubi diversae tabellae errorum reponuntur. Plerumque non debes has conformationes mutare.

MySQL imperium administrare

Praecepta sequentia recenset in processu usus database Mysql communiter:

• USUS notitia repono nomen eius :
  Mysql database ad operandum Select. Hoc mandato, omnia Mysql mandata hoc modo datorum sunt.

  mysql> use chenweiliang;
  Database changed

• SHOW DATABASES: 
  Elenchum datorum MySQL database procurationis enumerat.

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

• Tabulas monstrare:
  Omnes tabulas datorum specificatorum expone. Priusquam hoc mandatum utaris, imperio uti debes ad operandum datorum deligendo.

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

• SHOW COLUMNA FROM 数据 表:
  Praestare tabulae datae attributa, genera attributa, praecipua indicia clavis, num nulla sit, pretii defectus et alia indicia.

  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)

• INDEX SHOW FROM * 数据 表:
  Praecipua indices informationes notitiarum tabularum, in quibus CLAVIS PRIMARIA (clavis primaria).

  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)

• SHOW TABLE STATUUM MODUM.
  Hoc mandatum outputabit in executione et mutant systematis database 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，查询结果按列打印