我有11个2提供的托管,我刚刚创建了一个新的
MySQL用户,并允许它访问列出的每个操作.
我收到以下错误
Warning: mysql_connect() [function.mysql-connect]: Access denied for user '(username is here, removed for posting)' (using password: YES) in /home/.../public_html/config.php on line 10
这是我的配置文件
//connection details have been removed for posting purposes
define('SQL_SERVER',''); // Database Server
define('SQL_USER',''); // User
define('SQL_PASS',''); // Password
define('SQL_DB',''); // database
mysql_connect(SQL_SERVER,SQL_USER,SQL_PASS) or die("Error: ".mysql_error()); // Connection to the server
mysql_select_db(SQL_DB) or die("Error: ".mysql_error()); // Connecting to the database
?>
GRANT ALL PRIVILEGES ON databasename.* TO 'bookorama'@'%' IDENTIFIED BY 'yourpassword';
FLUSH PRIVILEGES;
但我收到以下错误“#1044 – 用户拒绝访问”.当我登录到CPanel并检出数据库用户时,它会显示我尝试登录的用户,因此我很困惑为什么它不起作用.
编辑 – 我得到了它的工作.服务器出了问题.与主人联系,他们负责处理.谢谢你的回复.