How to create User in Mysql
Create new user in Mysql
We can create MySQL accounts in two ways, By using statements such as Create user and Grant.
1.CREATE USER
Syntax
CREATE USER 'user_name'@ 'host_name' [IDENTIFIED BY [PASSWORD] 'password']
Example
CREATE USER 'senthil'@ 'localhost' identified by 'admin';
Note
It must be noted that CREATE USER command was added in the MySQL version 5.0.2. In earlier versions, users could be created automatically when assigning permissions using the GRANT command or by manually inserting records in the mysql database.
It must be noted that CREATE USER command was added in the MySQL version 5.0.2. In earlier versions, users could be created automatically when assigning permissions using the GRANT command or by manually inserting records in the mysql database.
2.Grant User
Syntax
GRANT [PRIVILIAGES] ON 'database_name'.'table_name' TO ''user_name'@ ''host_name' IDENTIFIED BY 'password';
Example
GRANT ALL ON 'test'.* TO ''senthil'@ ''localhost' IDENTIFIED BY 'admin';
To see a list of the userd and their privileges.
use mysql;
select * from mysql.user where User='user' \G;
