this all started when i found out that my boot was 98% full and the system asked for a reboot. when i rebooted this is the error on the monitor
ernel panic - not syncing: VFS: Unable to mount root fs on unknown-block(0,0)
dpkg --list | grep linux-image
to list the kernels and then used
apt-get remove linux-image-2.6.15-27-386 linux-headers-2.6.15-27-386
to remove the old kernels and header info and recovered 50% of my boot
now when i try to log into phpmyadmin as root i only see the
data base and nothing else. now if i log into each site account i can see there database.
then when i log into webmin and select servers/MySQL Databases i only see 2 data bases and there should be 20 i checked under /var/lib/mysql and all of the databases are listed and all of the sites are up and running and also when i click on User Permissions,Database Permissions,Host Permissions,Table Permissions,Field Permissions,Database Connections,or MySQL System Variables i receive the following error
DBI connect failed : Access denied for user 'root'@'%' to database 'mysql'
from what i have read i need to reset my root password for mysql and i have done so using this
Stop the MySQL Server.
sudo /etc/init.d/mysql stop
Start the mysqld configuration.
sudo mysqld --skip-grant-tables &
Login to MySQL as root.
mysql -u root mysql
Replace YOURNEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;
but i am still getting the same error and i can not log into phpmyadmin as root and see all of the databases
would love some input thanks