By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,334 Members | 2,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,334 IT Pros & Developers. It's quick & easy.

Access denied to mysql

P: 57
Hey everybody,
Problems everywhere ain't they?
Well this one is about mysql and when I open phpmyadmin, I get

"Access Denied.
Error!
Cannot connect: invalid settings.
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."
So I think the problem is in the user cause the default user that is opened by is I think 'ODBC'@'localhost' which I didn't create and I had a plan to create a user named ODBC.It worked on the command line but it has no permissions granted.So I think it's because of that.Any suggestions?
Dec 11 '15 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,035
somewhere in your configuration (most likely in config.inc.php) you should find something like this:

Expand|Select|Wrap|Line Numbers
  1. // MySQL user
  2. $cfg['Servers'][$i]['user']                = 'USERNAME';
  3.  
  4. // MySQL password (only needed with 'config' auth_type)
  5. $cfg['Servers'][$i]['password']            = 'PASSWORD';
  6.  
The values USERNAME, and PASSWORD should, of course, be changed to match a working user.
Dec 12 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.