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

Here's how to add new MYSQL users and specify a database. The secret of the text is to be relevant to the topic. So, forget the gossip, let's go straight to the following, and I'm sure you'll benefit from reading this article on how to add new MYSQL users and specify a database.

1.cd / d windows version cd Linux version / / switch to the installation location of MySQL.exe

2.mysql-uroot-p password

3.use mysql

4.insert into user (Host,User,Password) values ('localhost',' new user', password ('password'))

5.flush privileges

7.flush privileges

Is there anything you don't understand about how to add new MYSQL users and specify database-related content above? Or 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.