SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard
    Join Date
    Jun 2005
    Posts
    1,438
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Changing the password for a phpmyadmin database ?

    Can anyone, in plain noob lingo, please explain how to change the password for a phpmyadmin database please ?

    Any help appreciated.

    Dez.

  2. #2
    SitePoint Wizard rguy84's Avatar
    Join Date
    Sep 2005
    Location
    Durham, NC
    Posts
    1,659
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    Do you know the current password?

    Once you log in it should say change password on the right-hand side.
    Ryan B | My Blog | Twitter

  3. #3
    It's all Geek to me silver trophybronze trophy
    ralph.m's Avatar
    Join Date
    Mar 2009
    Location
    Melbourne, AU
    Posts
    24,301
    Mentioned
    460 Post(s)
    Tagged
    8 Thread(s)
    Quote Originally Posted by rguy84 View Post
    Once you log in it should say change password on the right-hand side.
    I don't see that in my version.

    I don't know much about SQL, but I successfully changed my password via phpMyAdmin by doing this:

    In phpMyAdmin home page, click on DB name.

    Click on the SQL tab.

    In the large textarea, type (with words in red altered to suit, as shown below):

    GRANT ALL PRIVILEGES ON dbname.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION

    dbname = the data base name
    username = the username you have chosen
    password = the password you want to use

    Click Go.

    As I say, this worked nicely while I was working on a local installationóbut I didn't have any critacal data I couldn't afford to lose. It might be worth googling a bit to get a second opinion, or wait for more replies.

  4. #4
    It's all Geek to me silver trophybronze trophy
    ralph.m's Avatar
    Join Date
    Mar 2009
    Location
    Melbourne, AU
    Posts
    24,301
    Mentioned
    460 Post(s)
    Tagged
    8 Thread(s)
    Actually, Googled it myself and found this, which is probably better:

    Code:
    SET PASSWORD FOR 'username'@'localhost' = PASSWORD('newpassword');
    For information on the SET PASSWORD command see: dev.mysql.com/doc/refman/5.0/en/set-password.html


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
  •