Shulou(Shulou.com)06/01 Report--

The following is followed by the author to understand the MySQL user password and view the operation of the command, I believe that you will benefit a lot after reading, the text in the essence is not much, hope that the MySQL user password and view the command of the operation of this short content is what you want.

User part

MySQL user Settings

If you need to add MySQL users, you only need to add new users in the user table in the mysql database.

You can specify permissions for users when you create them. The list of user permissions is as follows:

Permission list:

ALTER: modify tables and indexes.

CREATE: create databases and tables.

DELETE: deletes existing records in the table.

DROP: discard (delete) databases and tables.

INDEX: create or discard indexes.

INSERT: inserts a new row into the table.

REFERENCE: not used.

SELECT: retrieve the records in the table.

UPDATE: modify existing table records.

FILE: read or write files on the cloud server.

PROCESS: view the thread information executed in the CVM or kill the thread.

RELOAD: reload the authorization table or empty the log, host cache, or table cache.

SHUTDOWN: shut down the CVM.

ALL: all permissions, synonymous with ALL PRIVILEGES.

USAGE: special "No permission" permission.

The user account consists of "username" and "host", which indicates where the user is allowed to access. Tom@'%' represents any address, which can be omitted by default. It can also be "tom@192.168.1.%", "tom@%.abc.com" and so on. The database format is db@table, which can be "test.*" or "*. *", the former representing all tables in the test database and the latter representing all tables in all databases.

The clause "WITH GRANT OPTION" indicates that the user can assign permissions to other users.

The following is an example of adding a user, with the user name test and password test123, and authorizing the user to operate SELECT, INSERT, and UPDATE:

First enter the table:

[root@localhost mysql] # mysql-u root-pEnter password: * mysql > use mysql;Database changed

View the user information in the MySQL native table:

Mysql > select user,authentication_string,host from user +-+ | user | authentication_string | host | +-+- -- +-+ | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | localhost | | mysql.sys | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost | | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A |% | +-+-- -+

Insert user test:

Mysql > grant select,insert,update,delete,create,drop-> on tutorials.*-> to 'test'@'localhost'-> identified by' test123';Query OK, 0 rows affected, 1 warning (0.01 sec)

View the list of users again:

Mysql > select user,authentication_string,host from user +-+ | user | authentication_string | host | +-+- -- +-+ | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | localhost | | mysql.sys | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost | | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A |% | test | * 676243218923905CF94CB52A3C9D3EB30CE8E20D | localhost | +-+-- -+-+ 4 rows in set (0.00 sec)

Delete a test01 user:

Mysql > select user,authentication_string,host from user +-+ | user | authentication_string | host | +-+- -- +-+ | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | localhost | | mysql.sys | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost | | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A |% | test02 | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | loaclhost | | test01 | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | loaclhost | +-- -+-+ 5 rows in set (0.00 sec) mysql > drop user test01@loaclhost Query OK, 0 rows affected (0.00 sec) mysql > select user,authentication_string,host from user +-+ | user | authentication_string | host | +-+- -- +-+ | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | localhost | | mysql.sys | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost | | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A |% | test02 | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | loaclhost | +-+-- -+-+ 4 rows in set (0.00 sec)

Rename test02 to test:

Mysql > rename user 'test02'@'loaclhost' to' test'@'192';Query OK, 0 rows affected (0.00 sec) mysql > select user,authentication_string,host from user +-+ | user | authentication_string | host | +-+- -- +-+ | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | localhost | | mysql.sys | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost | | root | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A |% | test | * 6691484EA6B50DDDE1926A220DA01FA9E575C18A | 192 | + -+-+ 4 rows in set (0.00 sec)

Revoke the update rights of the test user:

Mysql > revoke update on *. * from 'test'@'192';Query OK, 0 rows affected (0.01sec)

The operation of MYSQL basic view

SHOW DATABASES:

Lists the databases for the MySQL database management system.

Mysql > show databases;+-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | sys | +-+ 4 rows in set (0.00 sec)

USE database name:

Select the Mysql database you want to operate on, and after using this command, all Mysql commands are directed only to that database.

Mysql > use sys;Database changed

SHOW TABLES:

Displays all tables for the specified database, and you need to use the use command to select the database to operate on before using this command.

Mysql > show tables;+-+ | Tables_in_mood | +-+ | info | +-+ 1 row in set (0.00 sec)

SHOW COLUMNS FROM data sheet:

Displays the properties of the data table, attribute type, primary key information, whether it is NULL, default value and other information.

Mysql > show columns from info +-+ | Field | Type | Null | Key | Default | Extra | +-+ -+-+ | id | int (11) | NO | PRI | NULL | auto_increment | | name | char (10) | NO | | NULL | | score | decimal (5L2) | YES | | NULL | | hobby | int (2) | YES | NULL | | | | +-+-+ 4 rows in set (0.00 sec) |

SHOW INDEX FROM data sheet:

Displays detailed index information for the data table, including PRIMARY KEY (primary key).

Mysql > show index from info +- -+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +- -- + | info | 0 | PRIMARY | 1 | id | A | 0 | NULL | NULL | | BTREE | +-+- -+-+ 1 row in set (0.00 sec)

After reading this article on MySQL user password and how to view commands, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.