必须通过phpMyAdmin或命令提示符在 Query prompt 中创建 new MySQL User 并分配如下所示的权限:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
完成所有四个查询后,它应该与 username / password 连接
RESTART WAMP / LAMP Server 它应该工作!
18
授予所有特权 . TO' YourUserName '@' your IP ' IDENTIFIED BY ' yourPassoword ';
2 回答
必须通过phpMyAdmin或命令提示符在
Query prompt
中创建new MySQL User
并分配如下所示的权限:完成所有四个查询后,它应该与
username / password
连接RESTART WAMP / LAMP Server
它应该工作!授予所有特权 . TO' YourUserName '@' your IP ' IDENTIFIED BY ' yourPassoword ';
flush PRIVILEGES;
它会好的,继续:)