我可能有个不可思议的愚蠢问题..。
我有下面的代码,它应该能工作。所有凭证都正常工作,我用不同的脚本测试了它们。但是,我看不出代码哪里错了.
有人能帮我找到问题吗,这样我才能更好地理解它?
define("HOST", "localhost"); // The host you want to connect to.
define("USER", "deb63058_DomiSec"); // The database username.
define("PASSWORD", "ypPN7UY6aaxLxw7D6qwTrkJ3"); // The database password.
define("DATABASE", "deb63058_Domi"); // The database name.
$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE) ;
// If you are connecting via TCP/IP rather than a UNIX socket remember to add the port number as a parameter.
$con=mysqli_connect("localhost","deb63058_DomiSec","ypPN7UY6aaxLxw7D6qwTrkJ3","deb63058_Domi");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL !!!: " . mysqli_connect_error();
}给出以下错误:
Failed to connect to MySQL !!!: Access denied for user 'deb63058_DomiSec'@'%' to database 'deb63058_Domi''@'%‘在错误消息中是什么意思?我连接到本地交钥匙linux服务器。
发布于 2013-10-04 13:26:52
'deb63058_DomiSec'@'%'意味着已经创建了用户,以便它可以从任何主机访问数据库。%是mysql通配符。错误Access denied for user 'deb63058_DomiSec'@'%' to database 'deb63058_Domi'表示密码是正确的,但用户没有访问该数据库的权限。使用以下命令检查mysql中该用户的特权:SHOW GRANTS FOR 'deb63058_DomiSec'@'%';,然后添加所需的必要特权。
https://stackoverflow.com/questions/19182332
复制相似问题