"MySQL" Linux create role information for MySQL

1. Enter the database

Mysql-u root-p

Enter password

2. Enter after entering:

Use MySQL;

3. Directly from the Connection Client tool, select the database mysql->user table inside copy Create, do not know how to configure remote connection, refer here 4. or refer to the configuration here: http://www.open-open.com/lib/view/ Open1425872518654.html 5. Modify the created MySQL user password after creation

>mysql-uroot-penter Password: "Enter your original password" MySQL> Usemysql;mysql> Update user set password= PassworD (" new password ") where user=' account to be modified '; MySQL> flush privileges;mysql > exit;      >service mysqld Restart;

"MySQL" Linux create role information for MySQL