SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Zealot
    Join Date
    Oct 2009
    Posts
    141
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Password problem my phpmyadmin

    Hi

    I updated the root password for my mysql installation, and then I updated my config.inc.php file in my phpmyadmin directory with the new password. (Before this root had no password)

    If I now go to localhost/phpmyadmin , I cannot access the top level (where I can create databases, edit priveleges etc), but I can access any of the databases I have already created. When I try go to the top level I get:

    #1045 - Access denied for user 'root'@'localhost' (using password: NO)


    Quite sure this is a simple problem! Thanks
    -------------------------------
    http://www.divinglogs.net
    The free online diving community

  2. #2
    SitePoint Addict kduv's Avatar
    Join Date
    May 2012
    Location
    Maui, HI
    Posts
    211
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    In config.inc.php, change:
    PHP Code:
    $cfg['Servers'][$i]['user']          = 'root';
    $cfg['Servers'][$i]['password']      = 'cbb74bc';
    $cfg['Servers'][$i]['auth_type']     = 'config'
    To:
    PHP Code:
    $cfg['Servers'][$i]['auth_type']     = 'cookie'
    That way it will prompt you to log-in with credentials. Use the root user/pass to access the root account, and whatever DB user account you have to use just that user.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •