Search code examples
phpmysqlxampplocalhostaccess-denied

Switching mySQL to local server Access Denied using php script

I have been using php scripts to connect with a mySQL database on a remote server and I am trying to switch to using a local server. When I attempt to connect using the script below: 

<?php
mysql_connect("localhost", "vinylpsy_singles", "password") or die(mysql_error());
mysql_select_db("vinylpsy_singles") or die(mysql_error());

$resultNew = mysql_query("SELECT * FROM `table`"); 

?>

And am getting the following error

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'vinylpsy_singles'@'localhost' (using password: YES) in /Applications/XAMPP/xamppfiles/htdocs/chromeSave/thepopz/php/getSingles_11.php on line 2
Access denied for user 'vinylpsy_singles'@'localhost' (using password: YES)

Can any one suggest what adjustment I need to make?

Solution

  • Login as administrator on the SQL-server and run the following command:

    select * from `mysql`.`user` where `user` = 'vinylpsy_singles'

    Make sure there is either a line that has "localhost" in the Hosts column or the wildcard %. If neither of those are true then you have to add access to the specific user with a GRANT command. Users in MySQL are "locked" to a specific host (or wildcard).

    For full GRANT use the following:

    GRANT ALL PRIVILEGES ON *.* TO 'vinylpsy_singles'@'localhost'

    However this privileges should of course be the same as those you used to have for your old host.