Create, authorize, and delete mysql users at the WIN command prompt, and change the password _ MySQL

At the WIN Command Prompt, create, authorize, and delete mysql Users. to change the password to bitsCN.com, you must first declare: In general, modify the MySQL password and authorize, it requires the root permission in mysql.
Note: this operation is performed at the WIN command prompt, and phpMyAdmin is also applicable.
User: phplamp user database: phplampDB

1. create a user

// Log on to MYSQL
@> Mysql-u root-p
@> Password
// Create a user
Mysql> insert into mysql. user (Host, User, Password) values ("localhost", "phplamp", password ("1234 "));
// Refresh the system permission list
Mysql> flush privileges;
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

If you want to allow myuser to connect to the mysql server from a host whose ip address is 192.168.1.6, and use mypassword as the password

Grantall privileges on *. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' withgrant option;

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. change the password of a 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; bitsCN.com