As ROOT on linux goto /etc Edit my.cnf Enter skip-grant-tables Restart the mysql server Change the password.
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Parminder Singh Chauhan [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, October 28, 2003 10:34 AM -->To: [EMAIL PROTECTED] -->Subject: Change of root password --> -->After long struggle I (A newbee to linux) was able to setup mysql4.0.16 -->and I don't know what I have done, I set the root password which I don't -->know. Now I can't access the mysql. -->Is there anyway of changing root password.? and how? -->I tried to delete the content of /usr/local/mysql/var/mysql and run -->mysql_install_db again thinking it will remove the password but no -->effect. -->-- -->Parminder Singh Chauhan <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]