anwoke8204
January 5th, 2009, 02:47 AM
Hi, I reinstalled my server and it got rid of all of the mail issues I was having in my other post, but now I am having issues with mysql. I set the password when I installed mysql, but now the password is blank, and I can't change it, I have tried through webmin, phpmyadmin, and through booting mysql into safe mode and editing the mysql table itself, no matter what I do, I can't change the password. everything was fine till I installed squirrelmail and phpmyadmin and then created my first virtual host. now neither of my mysql admin accounts have passwords, they are blank. and they are limited to the information_schema database. anyone know how I can fix this, I have tried uninstalling mysql-server mysql-client and all of teh dependancies (it also took dovecot and proftpd with it) and then reinstalled them, then reinstalled dovecot and proftpd. but still to no avail, no password on the admin accounts, and I am unable to create one. any help would be apprecieated. TIA I am running ubuntu server 8.04