settings for SQL connection

[jcolwell222]

I can't seem to connect to the SQL server. This problem arose without my making any changes to my settings , SQL tables, or scripts.

I have been using:
•sql-chopin.x10hosting.com for the host
•jcolwell_***** for the user
•/var/lib/mysql/mysql.sock for the default socket (set using ini_set in PHP)

This always worked before. But yesterday, I got the message:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'jcolwell_*****'@'chopin.x10hosting.com' (using password: YES) in /home/jcolwell/public_html/****************.php on line 37

I looked around the forums and knowledgebase, and it seemed that the host should simply be localhost. I tried this in place of sql-chopin.x10hosting.com, and got the message:

Access denied for user 'jcolwell_*****'@'chopin.x10hosting.com' to database 'jcolwell_*****'

I tried adding a new SQL user for the database, and changing my scripts accordingly, but got the same result.

•Should I be setting the default socket using ini_set?
•What host name should I use?
•Do you know what might have caused this problem?

 

[Zubair]

Use localhost as host

 

[danprobo]

This happen a few days ago with my Drupal website (server chopin), I can't fix it by myself and decided to delete the database and create new database again, now my site is working fine.