[Answered] Remote Mysql Access Error Establishing A Database Connection

[johnh100]

Firstly, I have read http://wiki.helionet.org/MySQL_Databases

 

My wordpress wp_config.php reads

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'johnh100_crepair');

/** MySQL database username */
define('DB_USER', 'johnh100_crepair');

/** MySQL database password */
define('DB_PASSWORD', '************');

/** MySQL hostname */
define('DB_HOST', 'stevie.heliohost.org');
/** also tried
define('DB_HOST', 'johnny.heliohost.org');
*/

 

Error establishing a database connection

 

I have put a % in remote mysql

 

This I am sure has been asked before, but can not find any solved answers.

I have changed

[yashrs]

For wordpresss, localhost as the DB_HOST would be fine.

 

Also, have you tried changing the password of the user or deleting and recreating it in the cPanel ?

[johnh100]

For wordpresss, localhost as the DB_HOST would be fine. Also, have you tried changing the password of the user or deleting and recreating it in the cPanel ?

Yes, localhost is fine, locally, I would like to access the database from elsewhere. Or what is the database server url?

 

May have found the answer!!

Account Queued

 

Ahoy! You're seeing this page because HelioHost has not gotten about to installing and configuring your account yet. This process usually takes about 24 hours, and once it is complete your website should show up properly. While the account is being created we suggest taking a look at your control panel.

 

So I am guessing patients!

[wolstech]

If you're just seeing that now, your DNS isn't set up yet. That takes several days on Johnny, but shouldn't matter for remote mysql. Scripts accessing MySQL remotely should use a host name of johnny.heliohost.org for your account. As yashrs said, local scripts using mysql should use localhost.

 

I noticed in your example that the database name and username are the same. Is this correct? Did you create that database user? Did you assign it to the database? Verify the password is correct.