The next step is to shutdown mysqld, delete the mysql and temp tables from your /data/ folder, and then re-run the scripts/mysql_install_db. That will reinstall the mysql/hosts.frm, which will basically reset your root user and password. However, it will also kill any users you have created.
To reset the root password without "harming" other mysql users: Shell> kill cat /path/to/mysql/data/hostname.pid Shell> ./bin/mysqld_safe --user=mysql --skip-grant-tables & Shell> mysqladmin -u root password 'newpassword' Shell> mysqladmin shutdown Then restart the mysqld like normal. Hope this helps! J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
