Shulou(Shulou.com)05/31 Report--

This article is about how to add users and change passwords in mysql. Xiaobian thinks it is quite practical, so share it with you. I hope you can gain something after reading this article. Let's not say much. Let's take a look at it together with Xiaobian.

mysql Add User Method

Create Gamesp

create database gamesp;

add users

grant all on database name.* to username @localhost identified by password;

grant all on gamesp.* to identified by password;

Description:

(1) grant all rights granted

（2）gamesp.* All tables in database gamesp

(3) Newuser username

(4)@localhost Server on local computer

(5) identifiedby password

delete user

use mysql

mysql>Delete FROM user Where User="xxxxx" and Host="localhost";

mysql>flush privileges;

change the password

mysqladmin -uroot -plk317921web password "111111"

The above is how to add users and change passwords in mysql. Xiaobian believes that some knowledge points may be seen or used in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.