Re: [PHP] I changed my root password and now can't connect to MySQL

On Tuesday, June 25, 2002, at 03:27 PM, Phil Schwarzmann wrote: > Now, whenever my script runs a MySQL command, I get this error > > Warning: MySQL Connection Failed: Access denied for user: 'root@MY_PC' > (Using password: YES) in C:\...\dbconnect.inc on line 3 > Cannot connect to The Datab

[PHP] I changed my root password and now can't connect to MySQL

Okay, so I changed my root password using this command C:\> C:\mysql\bin\mysql mysql mysql> DELETE FROM user WHERE Host='localhost' AND User=''; mysql> QUIT C:\> C:\mysql\bin\mysqladmin reload C:\> C:\mysql\bin\mysqladmin -u root password my_password Then I went into my dbconnect.inc file