wamp server 2

最新推荐文章于 2025-10-21 22:09:11 发布

原创最新推荐文章于 2025-10-21 22:09:11 发布 · 349 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#server #permissions #database #command #user #security

本文介绍如何通过创建新用户并赋予特定数据库权限来加强MySQL的安全性，避免使用默认的root账户无密码登录，确保数据安全。

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'.