dongwei1895 2014-04-28 18:36
浏览 86

无法通过PHP连接到MySQL数据库

I'm building a website with a login using php and mysql. When I try to connect to the database I keep getting error:

Notice: Could not connect to MySQL: Access denied for user 'User'@'localhost' (using password: YES)

I have tried to set a new password or no password but keep getting this error. Does somebody know how to fix this?

I noticed this error also occurs when using mysql with java apps

I'm using phpMyAdmin with wamp

Edit: Here is the code. I replaced Username, Pass and Database by User, Pass and Database

DEFINE('DATABASE_USER', 'Username');
DEFINE('DATABASE_PASSWORD', 'Pass');
DEFINE('DATABASE_HOST', 'localhost');
DEFINE('DATABASE_NAME', 'Database');
date_default_timezone_set('Europe/Brussels');

DEFINE('EMAIL', 'user@email.com');

DEFINE('WEBSITE_URL', 'localhost/wadistjom');

$dbc = @mysqli_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME);

if (!$dbc) {
   trigger_error('Could not connect to MySQL: ' . mysqli_connect_error());
}
  • 写回答

2条回答 默认 最新

  • dongshuo9350 2014-04-28 18:39
    关注

    If you are using PhpMyAdmin then you should be able to see all users under the "Users" tab on the PMA startpage. You can also create a new user there.

    评论

报告相同问题?

悬赏问题

  • ¥20 delta降尺度方法,未来数据怎么降尺度
  • ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
  • ¥15 高德地图点聚合中Marker的位置无法实时更新
  • ¥15 DIFY API Endpoint 问题。
  • ¥20 sub地址DHCP问题
  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错