首页 > 数据库技术 > 详细

Access denied

时间:2015-05-26 17:58:49      阅读:357      评论:0      收藏:0      [点我收藏+]

Problem:

Below error encounterred when connecting to remote server in PHP code.

Access denied for user ‘root‘@‘192.168.233.163‘ (using password: YES)

Solution:

Run below command under root 

Command 1

GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME‘@‘IP‘ IDENTIFIED BY ‘PASSWORD‘;

  

where IP is the IP you want to allow to access and USERNAME is the user you use to connect

If you want to allow access from any IP just put % instead of your IP

 

Command 2

FLUSH PRIVILEGES;

  

This command is to make setting take effect.

Access denied

原文:http://www.cnblogs.com/binglong/p/4531021.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!