Mysql User creation, authorization, deletion, and password modification bitsCN.com
Mysql User creation, authorization, deletion, and password modification
First, declare that, in general, you need to have the root permission in MySQL to modify the mysql password and grant permissions.
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 table 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> login successful 2. authorize the user. If you want to allow myuser to connect to the mysql server from a host with ip address 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. modify 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