To create, authorize, delete, and modify a mysql user's password, you must first declare that, in general, you must have the root permission in MySQL to modify the mysql password and authorize it. 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;