View Single Post
  #1  
Old 9th February 2012, 20:05
kwickcut kwickcut is offline
Senior Member
 
Join Date: Nov 2005
Location: nj usa
Posts: 223
Thanks: 14
Thanked 11 Times in 10 Posts
Default DBI connect failed : Access denied for user 'root'@'%' to database 'mysql'

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
Code:
ernel panic - not syncing: VFS: Unable to mount root fs on unknown-block(0,0)
i used
Code:
dpkg --list | grep linux-image
to list the kernels and then used
Code:
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
Code:
information_schema
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
Code:
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
Code:
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


kwick
__________________
Operating system Ubuntu Linux 10.04.4
ISPConfig Version: 3.0.4.3
Webmin version 1.580
Kernel and CPU Linux 2.6.32-40-server on x86_64
Processor information AMD Phenom(tm) II X4 945 Processor, 4 cores
Real memory 4.0 GB total
Reply With Quote
Sponsored Links