Add new user _ MySQL for MySQL database

Add a new user to the MySQL database. there is only one default user in the newly installed MySQL database. this is root @ localhost. if you need to make the database accessible and used by more users, to add a new user, you can use the following two methods in windows:

Use the GRANT statement:

Grant select on test. * to 'yonghu' @ '%' identified by 'some _ Pass' with grant option;

The example shows adding a user named yonghu from any location. the password is some_pass, which can be used to select any table in the test database.

Insert users directly to the grant table:

Shell> mysql -- user = root mysql

Mysql> insert into user (Host, User, Password) values ('localhost', 'shagua ','');

Mysql> flush privileges; indicates to add a user from the local machine named shagua with a blank password to the database.