kaedus Posted June 22, 2010 Share Posted June 22, 2010 I was attempting to allow remote connections to a MySQL database by following this guide here: http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html In the process of following step #5 I seem to have removed access to the database from myself? Now the website is broke and I'm at a loss on how to get my access back. Any help would be greatly appreciated. Any ideas at all. I am getting the error as follows: Warning: mysql_connect(): Access denied for user 'cboweb@localhost' (using password: YES in /opt/oasis/php/dbconnect.php on line 18 Could Not Connect: Access denied for user 'cboweb'@'localhost' (using password: YES) I have tried the root login and the other login. I can't even get through on phpMyAdmin now either. I don't know how to reverse the changes that I made and I can't connect. This has completely hosed my work site. I'm kind of freaking out. If anyone can give some help it would be greatly appreciated. Quote Link to comment https://forums.phpfreaks.com/topic/205506-access-denied-for-user/ Share on other sites More sharing options...
fenway Posted June 22, 2010 Share Posted June 22, 2010 Then you must be using the wrong password. Quote Link to comment https://forums.phpfreaks.com/topic/205506-access-denied-for-user/#findComment-1075755 Share on other sites More sharing options...
kaedus Posted June 22, 2010 Author Share Posted June 22, 2010 Actually after following this guide: www. cyberciti. biz/tips/recover-mysql-root-password.html I was able to get into phpMyAdmin without a password and I had somehow changed the root account to not be accessible by localhost. After changing that back I was once again able to log in. So, the password was correct. Quote Link to comment https://forums.phpfreaks.com/topic/205506-access-denied-for-user/#findComment-1075854 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.