wamp server 2

最新推荐文章于 2024-02-07 22:09:49 发布

Leonard61

最新推荐文章于 2024-02-07 22:09:49 发布

阅读量315

点赞数 1

文章标签： server permissions database command user security

本文链接：https://blog.csdn.net/leonarddc/article/details/6319984

版权

It/'s also a good thing to create one or more users and associate them with individual databases for the purposes of developing scripts or using your own script. This command let/'s you create a new user and give that user permissions to use a database called test_db you created with the command CREATE DATABASE test_db:

GRANT ALL ON test_db.* TO testusr@localhost IDENTIFIED BY /"testusrpw/";

Nickname: gizmola on: 2003-12-13 17:07:12

--http://en.phpfans.net/qa/31288123620.html

这样可以绕过这个root密码为空的问题。

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.