corona79 Posted October 24, 2015 Share Posted October 24, 2015 I've seen that a "fix" has again made things worse. I can start a CGI program that accesses a database, but it can't access any data and I can't see my Wordpress blog: Error establishing a database connection When logged in to cpanel and trying to run phpMyAdmin, I just get another login prompt Welcome to phpMyAdmin Using the cpanel login, it goes to Server errorThe website encountered an error while retrievinghttp://stevie.heliohost.org:2082/cpsess2551231495/3rdparty/phpMyAdmin/index.php. It may be down for maintenance or configured incorrectly. cpanel username is bcsadmin[/color] Link to comment Share on other sites More sharing options...
wolstech Posted October 24, 2015 Share Posted October 24, 2015 The first step is to change your cPanel password. Do that here: http://stevie.heliohost.org:2082/frontend/x3/passwd/index.html After that, check to see which databases are visible in phpmyadmin. If any of your databases are missing, post a list of the ones that aren't visible so Krydos can restore them for you. Once they're restored (or if they're already visible), go here: http://stevie.heliohost.org:2082/frontend/x3/sql/index.html and delete and recreate your database users. Be sure to use the database password found in your software's configuration file (for WordPress, it's wp-config.php). Then reassign each user to its databases. If you don't know what privileges to grant, select "All privileges". Link to comment Share on other sites More sharing options...
corona79 Posted October 24, 2015 Author Share Posted October 24, 2015 changed cpanel password, but no changeI can log in and try to start phpMyAdmin, but just get another login prompt, then the server error again Link to comment Share on other sites More sharing options...
wolstech Posted October 24, 2015 Share Posted October 24, 2015 That's odd. Normally changing the cPanel password should fix PHPMyAdmin. Escalating. Link to comment Share on other sites More sharing options...
corona79 Posted October 28, 2015 Author Share Posted October 28, 2015 changing cpanel password still changes nothing Link to comment Share on other sites More sharing options...
Krydos Posted October 28, 2015 Share Posted October 28, 2015 The password on the account bcsadmin has been manually reset, the new password has been tested, phpmyadmin on your account has been tested and verified to be working, and the new password has been emailed to your contact email address. Let us know if you need any further assistance. Link to comment Share on other sites More sharing options...
corona79 Posted October 28, 2015 Author Share Posted October 28, 2015 2 invisible databases:bcsadmin_fbs[don't know name (just user) of WP DB, but probably has "wp486" as part of it] Link to comment Share on other sites More sharing options...
Krydos Posted October 29, 2015 Share Posted October 29, 2015 The databases bcsadmin_fbs and bcsadmin_wp486 should now be visible to your root mysql account. You may need to delete, recreate, and reassign permissions to any database users that should have access to the affected databases. If phpmyadmin doesn't log in properly or you don't see the database there change your account password and this should sync up the mysql/cpanel passwords. Let us know if you're still having any issues accessing your data. Link to comment Share on other sites More sharing options...
Recommended Posts