MySQL Tutorial » Privilege » User

[VelMurugan]

Add a user

mysql>
INSERT INTO user VALUES('localhost','TestUser',PASSWORD('pass123'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
mysql>
mysql>

Add your database and users to the mysql database

mysql>
INSERT INTO db VALUES('localhost','sample_db','TestUser','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y')
mysql>

In the default setting of MySQL access privileges, every user is permitted to create databases on a local computer that begin with the word 'test.'

To set up the new database test_java2s, in mysql execute the command CREATE DATABASE.

mysql> CREATE DATABASE test_java2s;

Source : java2s

[VelMurugan]

SELECT host, user, select_priv, update_priv FROM user

mysql> use mysql
Database changed
mysql> SELECT host, user, select_priv, update_priv FROM user;
+------------+------+-------------+-------------+
| host       | user | select_priv | update_priv |
+------------+------+-------------+-------------+
| localhost  | root | Y           | Y           |
| production | root | Y           | Y           |
| 127.0.0.1  | root | Y           | Y           |
+------------+------+-------------+-------------+
3 rows in set (0.03 sec)

mysql>

select convert(SUBSTR(USER(),1,INSTR(USER(),'@')-1) using latin1)

mysql>
mysql> select convert(SUBSTR(USER(),1,INSTR(USER(),'@')-1) using latin1) ;
+------------------------------------------------------------+
| convert(SUBSTR(USER(),1,INSTR(USER(),'@')-1) using latin1) |
+------------------------------------------------------------+
| root                                                       |
+------------------------------------------------------------+
1 row in set (0.09 sec)

mysql>