Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    Iran
    Posts
    695
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I can't set up phpMyAdmin to recognize my new root password!

    Hi all

    I didn't want to change my MySQL root password because I was using it only on my own system. But since yesterday that we made a sort of network and others got connected to me, I thought it's really a good idea to set up a password if I don't want them to login to my MySQL server! So, I used this command at windows shell to change my password (after login in)
    Code:
    SET PASSWORD FOR root@localhost=PASSWORD('my_new_password');
    and it works just fine. I tested it in shell and MySqlCC and I had no problem log into my MySQL as root. But then I have the following setting in config.inc.php ( phpMyAdmin configuration file ):
    Code:
    $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
    $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
    $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
    $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
    $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                        // (requires PHP >= 4.3.0)
    $cfg['Servers'][$i]['controluser']   = 'root';          // MySQL control user settings
                                                        // (this user must have read-only
    $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                        // and "mysql/db" tables).
                                                        // The controluser is also
                                                        // used for all relational
                                                        // features (pmadb)
    $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
    $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
    $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
    I changed the last line ( $cfg['Servers'][$i]['password'] = ''; ) to:
    Code:
    $cfg['Servers'][$i]['password']      = 'my_new_password';
    and it doesn't work. It tells me:
    Your client doesn't support authentication protocol requested by server; consider upgrading MySQL client
    So, what does it mean? What am I supposed to do?

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,106
    Thanks
    11
    Thanked 101 Times in 99 Posts
    just to get back in , set $cfg['Servers'][$i]['auth_type'] to 'http' and login that way , otherwise not a clue , though perhaps its a host issue , try

    SET PASSWORD FOR root@"%"=PASSWORD('my_new_password');
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    Senior Coder missing-score's Avatar
    Join Date
    Jan 2003
    Location
    UK
    Posts
    2,194
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This is how I set my root password:

    Code:
    cd C:\Server\mysql\bin\
    mysql> use mysql;
    mysql> DELETE FROM user WHERE Host='localhost' AND User='';
    mysql> FLUSH PRIVILEGES;
    mysql> QUIT
    C:\> C:\Server\mysql\bin\mysqladmin -u root password rootpass
    Maybe it will be of some help to you.

  • #4
    New Coder
    Join Date
    Apr 2004
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Oh man, my head hurts



    I installed SWAMP, and I started toying around in /localhost/phpmyadmin...
    I deleted two default users, and set passwords for another two, but everytime I hit "Reload mysql" it all of a sudden looked like I never did a thing! The deleted users came right back! Then I tried deleting even more users and adding a new one, then it denied me access all of a sudden! I entered every password and username... NOTHING. I tried editing the config.inc.php file, putting in all different user names, and authorizations (http, config, etc) and different passwords, or no password... No matter what I do I can't get back into /localhost/phpmyadmin. I've tried restarting everything, getting the newest phpmyadmin, and reinstalling it... The install.txt doesn't give much help here. I did everything it told me to, and this is where I'm at. I've even searched the forums for similar issues... HELP!

    (EDIT: By the way, I'm ULTRA NEW to this in case you didn't know, but I'm not afraid to read volumes to learn what I need to know.)

  • #5
    New Coder
    Join Date
    Apr 2004
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Just so you know...

    Well I got it working. I don't know how exactly, but I figured I'd give it another try another day, and whammo: Everything fell into place. Now I'm hosting my own web server, and MySQL is working like a charm.

  • #6
    Regular Coder
    Join Date
    Jul 2002
    Location
    Iran
    Posts
    695
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Congratz! I really didn't know any remedy for your case that I didn't answer, but I'm happy that you could fix it. I'm still stuck with my original problem!


  •  

    Posting Permissions

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