Mysql help

[mohamed.salem.el.idrissi.msi14]

Sorry for this silly question but How to know which mysql server from the cpanel
define('DB_HOST', 'localhost')?

---------- Post added at 10:39 PM ---------- Previous post was at 10:22 PM ----------

Please help me,

This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.

---------- Post added at 11:27 PM ---------- Previous post was at 10:39 PM ----------

still got no reply on my ticket that i posted a few hour back

 

[garrettroyce]

Are you using CpanelUserName_MySQLUserName for the user and CpanelUserName_MySQLDatabaseName for the database?

In example, if my CPanel name was gr and I named my user wordpress, the user name is actually gr_wordpress.

 

[mohamed.salem.el.idrissi.msi14]

full sized picture fron here https://lh5.googleusercontent.com/_...AAWU/yV5tAi9LlX8/s576/helpmewithsqlserver.png

 

[garrettroyce]

The host is indeed localhost.

 

[mohamed.salem.el.idrissi.msi14]

It dose notwork

 

[garrettroyce]

are you sure you've got the right username and password? You created the user using Cpanel's MySQL Databases tool?

 

[MaestroFX1]

Hey!

Database Name : cpanelusrname_databasename
User Name : cpanelusrname_databaseusrname
Password : for cpanelusrname_databaseusrname; not for cpanelusrname
Database Host : localhost
Table Prefix : usually wp_ (if you haven't changed it)

Grant the required privilege(s) for the database and the associated databaseusr
by linking them.

It should be under cpanel >> MySQL Databases >> MySQL Account Maintenance >> Manage User Privileges.

A word of caution for wordpress users, it has issues causing high resource usage thereby resulting in suspension.

Read More
http://x10hosting.com/wiki/High_Resource_Usage