johnh100 Posted March 18, 2016 Posted March 18, 2016 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 Posted March 18, 2016 Posted March 18, 2016 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 Posted March 18, 2016 Author Posted March 18, 2016 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 Posted March 18, 2016 Posted March 18, 2016 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now