Am 18 Dec 2001 14:35:07 -0800 schrieb Jeremiah Jester: > Well it seems as though i may have mistyped my root password for mysql since > nothing seems be working. Anybody no how to set a new root password or how > to reset the old password in mysql? Already tried uninstalling the RPM from > in hopes to redo the install but when i try it tells me the package hasn't > been installed. odd. When i try to install (reinstall) the RPM it tells me > the package cannot install because it is already installed. Grrr.
Simply uninstall wouldn't help as most distros will let the data tables on the system. You have to uninstall AND go to /var/mysql/... or wherever Mysql stores your Tables and remove them, too. You can, without uninstalling, remove all the mysql tables from /var/lib/mysql/mysql/ or wherever mysql stores your tables, they are called *.MYD, *.MYI, *.frm and then run mysql_install_db again. That will set up new user tables without any root password set. but maybe somebody else knows a better way... greets,henning --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
