Просмотр исходного текста страницы MySQL Tutorial/Privilege/User

== Add a user==



   
  <!-- start source code -->
   
    <source lang="sql">
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></source>
    
   

== Add your database and users to the mysql database.==



   
  <!-- start source code -->
   
    <source lang="sql">
mysql>
INSERT INTO db VALUES("localhost","sample_db","TestUser","Y","Y","Y","Y","Y","Y","Y","Y","Y", "Y")
mysql></source>
    
   

== 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."==

<p>To set up the new database test_sqle, in mysql execute the command CREATE DATABASE.</p>


   
  <!-- start source code -->
   
    <source lang="sql">
mysql> CREATE DATABASE test_sqle;</source>
    
   

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



   
  <!-- start source code -->
   
    <source lang="sql">
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></source>
    
   

== SELECT host, user, select_priv, update_priv FROM user==



   
  <!-- start source code -->
   
    <source lang="sql">
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></source>