我在本地主机上的一个网站上工作,我得到了一个网站,并被要求以视觉/代码方式更新它。我有它的本地副本以及所有数据库数据,但我在尝试使用 mysql 管理员帐户连接到它时似乎遇到错误。
这是我收到的 WAMP 错误:
警告:mysql_pconnect() [function.mysql-pconnect]:在线访问 F:\wamp\www\xxxx\xxxxx\xxxxxxxxx.php 中的用户“temp”@“localhost”(使用密码:YES)被拒绝113
密码用户名和用户名正确并且具有完整的权限。
是否有任何日志显示拒绝的确切原因?或者有人也遇到过这种情况吗?
干杯
Im working on a website on my localhost, I was given a website, and have been asked to update it visually/code wise. I have a local copy of it, along with all of the database data but I seem to be getting an error trying to connect to it with an admin mysql account.
Here is the WAMP error im getting:
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'temp'@'localhost' (using password: YES) in F:\wamp\www\xxxx\xxxxx\xxxxxxxxx.php on line 113
The password and username are correct and have full privileges.
Are there any logs that show the exact reason why it was denied? or has anyone had this occur to them as well?
cheers
发布评论
评论(2)
听起来“localhost”和“127.0.0.1”之间的“主机”字段可能不匹配。 MySQL 区分了两者。
尝试再添加一个 MySQL 用户:[email protected]
It sounds like you might have a "host" field mismatch between "localhost" and "127.0.0.1". MySQL distinguishes the two.
Try adding one more MySQL user: [email protected]
假设您的安装位置为 c:\wamp,日志应位于 C:\wamp\logs 中。
您可以通过 phpmyadmin 连接吗?
logs should be in C:\wamp\logs assuming that your instalation is c:\wamp.
Can you connect via phpmyadmin ?