Use more navicat, now use the character interface to operate it. Reprinted from: http://www.cnblogs.com/analyzer/articles/1045072.html
first of all, to declare: In general, to modify the MySQL password, authorization, is required to have the root authority in MySQL.
Note:This operation is at the command prompt, and phpMyAdmin is also applicable.
User: NewUser user database: Newuserdb
1. Create a new user.
Log in to MySQL
@>mysql-u root-p
@> Password
Create user
mysql> INSERT INTO Mysql.user (Host,user,password) VALUES ("localhost", "NewUser", Password ("1234"));
Refresh System Permissions Table
Mysql>flush privileges;
This creates a user named: NewUser with a password of: 1234.
Then log in.
mysql>exit;
@>mysql-u newuser-p
@> Enter password
Mysql> Login Successful
2. Authorize the user.
Log in to MySQL (with root privileges). I am logged in as root.
@>mysql-u root-p
@> Password
First create a database for the user (NEWUSERDB)
Mysql>create database Newuserdb;
Authorizes the NewUser user to have all the permissions of the NewUser database.
>grant all privileges in newuserdb.* to [e-mail protected] identified by ' 1234 ';
Refresh System Permissions Table
Mysql>flush privileges;
Mysql> Other operations
/*
If you want to specify partial permissions to a user, you can write:
Mysql>grant select,update on newuserdb.* to [e-mail protected] identified by ' 1234 ';
Refreshes the System permissions table.
Mysql>flush privileges;
*/
3. Delete the user.
@>mysql-u root-p
@> Password
Mysql>delete from user WHERE user= "newuser" and host= "localhost";
Mysql>flush privileges;
Delete a user's database
Mysql>drop database Newuserdb;
4. Modify the specified user password.
@>mysql-u root-p
@> Password
Mysql>update Mysql.user Set Password=password (' New password ') where user= "NewUser" and host= "localhost";
Mysql>flush privileges;
MySQL new user, authorization, delete user, change password