#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    13
    Rep Power
    0
    Hi ...

    I've forgot my root password to connect to Mysql ...pls help......
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    From the manual:

    18.9 How to reset a forgotten password.

    If you have forgotten the root user password for MySQL, you can restore it with the following procedure.

    Take down the mysqld server by sending a kill (not kill -9) to the mysqld server. The pid is stored in a .pid file which is normally in the MySQL database directory:
    kill `cat /mysql-data-directory/hostname.pid`
    You must be either the UNIX root user or the same user the server runs as to do this.
    Restart mysqld with the --skip-grant-tables option.
    Connect to the mysqld server with mysql -h hostname mysql and change the password with a GRANT command. See section 7.26 GRANT and REVOKE syntax. You can also do this with mysqladmin -h hostname -u user password 'new password'
    Load the privilege tables with: mysqladmin -h hostname flush-privileges or with the SQL command FLUSH PRIVILEGES.

    Bye,
    Peter

Similar Threads

  1. Apache installation/configuration problem
    By MrSlappyPants in forum Apache Development
    Replies: 32
    Last Post: July 14th, 2005, 04:36 PM
  2. Apache freezing- help
    By mhoyt01 in forum Apache Development
    Replies: 8
    Last Post: July 22nd, 2003, 12:19 PM
  3. Why is mysql an unknown command in SSH?
    By JohnSaunders in forum MySQL Help
    Replies: 14
    Last Post: July 15th, 2002, 06:51 PM
  4. Replies: 9
    Last Post: May 23rd, 2002, 12:58 AM
  5. setting root password
    By Nezi in forum MySQL Help
    Replies: 2
    Last Post: July 27th, 2001, 03:27 AM

IMN logo majestic logo threadwatch logo seochat tools logo