Access denied to mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Toxicous8
    New Member
    • Oct 2015
    • 57

    #1

    Access denied to mysql

    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'@'localho st' 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?
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    somewhere in your configuration (most likely in config.inc.php) you should find something like this:

    Code:
    // MySQL user
    $cfg['Servers'][$i]['user']                = 'USERNAME';
    
    // MySQL password (only needed with 'config' auth_type)
    $cfg['Servers'][$i]['password']            = 'PASSWORD';
    The values USERNAME, and PASSWORD should, of course, be changed to match a working user.

    Comment

    Working...