1. Create a user.
// Log on to MySQL
@> Mysql-u root-P
@> Password
// Create a user
Mysql> insert into mysql. User (host, user, password, ssl_cipher, x509_issuer, x509_sub
Ject) values ("localhost", "pppadmin", password ("passwd "),'','','');
In this way, a user named: phplamp password: 1234 is created.
Then log on.
Mysql> exit;
@> Mysql-u phplamp-P
@> Enter the password
Mysql> logon successful
2. Authorize the user.
// Log on to MySQL (with root permission ). I log on as root.
@> Mysql-u root-P
@> Password
// Create a database for the user (phplampdb)
Mysql> Create Database phplampdb;
// Authorize the phplamp user to have all the permissions of the phplamp database.
> Grant all privileges on phplampdb. * To phplamp @ localhost identified by '123 ';
// Refresh the system permission list
Mysql> flush privileges;
Mysql> other operations
/*
If you want to assign some permissions to a user, you can write as follows:
Mysql> grant select, update on phplampdb. * To phplamp @ localhost identified by '123 ';
// Refresh the system permission table.
Mysql> flush privileges;
*/
3. delete a user.
@> Mysql-u root-P
@> Password
Mysql> Delete from user where user = "phplamp" and host = "localhost ";
Mysql> flush privileges;
// Delete the user's database
Mysql> drop database phplampdb;
4. Modify the password of the specified user.
@> Mysql-u root-P
@> Password
Mysql> Update mysql. User SET Password = PASSWORD ('new password') where user = "phplamp" and host = "localhost ";
Mysql> flush privileges;
5. list all databases
Mysql> show database;
6. Switch the database
Mysql> Use 'database name ';
7. list all tables
Mysql> show tables;
8. display the data table structure
Mysql> describe table name;
9. Delete databases and data tables
Mysql> drop database database name;
Mysql> drop table data table name; <br>
However, if you log on locally with a password, an error is prompted:
Error 1045 (28000): Access denied for user 'xcj '@ 'localhost' (using password: Yes)
This is only because the access permission is insufficient.
Error 1045 (28000): Access denied for user 'xcj '@ 'localhost' (using password: Yes)
# The newly added user service xcj does not take effect immediately.
Mysql> grant all on *. * To xcj @ '%' identified by "xcj_passwd ";
Query OK, 0 rows affected (0.04 Sec)
# New User xcj permission activated
Mysql> flush privileges;
Query OK, 0 rows affected (0.03 Sec)
[Root @ openfire pai_spider] # mysql-uxcj-P 'xcj _ passwd'
Welcome to the MySQL monitor. commands end with; or \ G.
Your MySQL connection ID is 4593
Server version: 5.0.45-log MySQL Community Server (GPL)
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
Mysql>
# If it does not take effect, it will be a ghost.