Add a new user for MySQL configuration in Linux

When building a web application in Linux, You need to remotely access the MySQL database. We do not recommend using root in Linux to log on, but to add new users. 1) Log On As A root user # mysql-uroot

When building a web application in Linux, You need to remotely access the MySQL database. We do not recommend using root in Linux to log on, but to add new users. 1) Log On As A root user # mysql-u root

When building a web application in Linux, You need to remotely access the MySQL database.

We do not recommend using root to log on in Linux, but adding new users.

1) Log On As A root user
# Mysql-u root-p

2) Insert a new user, host: %; user: jason; pssword: jason
Mysql> insert into mysql. user (host, user, password) values ('%', 'jason ', PASSWORD ('jason '));

3) Update the password
Mysql> update user set password = password ('jason ') where user = 'jason'

4) grant permissions
Mysql> grant all on neuzjs. * to jason @ '%' identified by 'jason ';
Specifically, neuzjs is the database name;

5) Refresh Permissions
Mysql> flush previleges;