Shulou(Shulou.com)06/01 Report--

This article is mainly about how to achieve user management in Mysql database. If you are interested, let's take a look at this article. I believe it is of some reference value to everyone after reading how to achieve user management in Mysql database.

Mysql users manage new users

Mysql-u root-p / / Log in to mysql

Use mysql; / / enter the database mysql

Command format create user 'username'@'localhost' identified by' password'

Use ciphertext as the user's password

Select password (123123)

View users

Use mysql; / / enter the database mysql

Select user,authentication_string,host from user; / / View users

Delete user > drop user 'abc'@'localhost'; / / Delete user abc rename user > rename user' abc'@'localhost' to 'msq'@'localhost'; (/ / rename user abc to msq) set password > set password=password (' 123456'); (set current user password to 123456) > set password for 'abc'@'localhost'=password (' abc123') (/ / set the password of other users abc to abc123) solution for forgetting the password of root users when using Mysql. Shut down database systemctl stop mysqld.service / / shut down mysql service 2. Use mysqld-- skip-grant-tables to start the database mysqld-- skip-grant-tables / / start Mysql3. After startup, you need to log in to Mysql on a terminal and use update to change the root password. Source / etc/profile / / Refresh the environment variable mysql / / enter the database > update mysql.user set authentication_string=password ('123123') where user='root'; (/ / modify the mysql library user table root user's password is 123123) 4: refresh the database > flush privileges; / / refresh the database 5: login test with the new password

Mysql-u root-p 123123

The above details about how to achieve user management in Mysql database are helpful to everyone? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.