I was trying to install Hoard webmail. I ran it's mysqlcreate.sql script and got hosed. Now MySQL doesn't see any databases except information_schema. Looking in the /var/lib/mysql/ directories it appears all the data is still there. phpmyadmin says I have No Privileges when logged in as root!?!?! Anyone know how to get it back? Thanks.
Found a solution elsewhere. In case this happens to anyone else... http://www.webmasterworld.com/databases_sql_mysql/3150519.htm Code: My init file (/root/mysql-init) read like: ====================================== GRANT ALL privileges ON *.* TO 'root'@'localhost' IDENTIFIED BY 'shinynewpasswd'; ===================================== My commands in shell: ====================================== shell> kill `cat /var/run/mysqld/mysqld.pid` shell> mysqld_safe --skip-kill-mysqld --init-file=/root/mysql-init & ====================================== ====================================== # mysql -u root -pshinynewpasswd Welcome to the mysql monitor. Commands end with ; or \g. Your mysql connection id is 8 to server version: 4.1.20 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('shinynewpasswd'); Query OK, 0 rows affected (0.00 sec) mysql> FLUSH privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye ======================================
