Hi there, First shutdown the running server.
mysqladmin shutdown or /etc/init.d/mysql.server stop or /etc/init.d/mysqld stop (depending on your Linux distribution) Then restart the mysql server with option "--skip-grant-tables" like this. safe_mysqld --skip-grant-tables You can then login without password. And then you reset your password with the update command like this: UPDATE user SET password='' WHERE user='root'; Restart the server again. Set a new password with mysqladmin like this: mysqladmin -u root password xxx mysqladmin -u root flush-privileges (xxx is your new password) That should be it. Mysql has a nice manual by the way where it is all described detailed, comes in very handy to have such a print close, just in case ;-) Best regards Nils Valentin Tokyo/Japan 2003年 8月 3日 日曜日 14:21、FT さんは書きました: > Hi everyone > I am quiet new to DB and MySql > I must have made a big mistake by changing the root @ localhost password > via phpMyAdmin and now it is impossible to connect from neither the mysql > prompt nor phpMyAdmin... > > Does anyone know how to recover this problem...I did try to reinstall MySql > after uninstalling it and rebooted the server but no luck so far... > > Thanks for the hand > > Fabrice -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
