HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Technical (http://www.howtoforge.com/forums/forumdisplay.php?f=8)
-   -   DBI connect failed : Access denied for user 'root'@'%' to database 'mysql' (http://www.howtoforge.com/forums/showthread.php?t=56111)

kwickcut 9th February 2012 20:05

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

falko 10th February 2012 17:29

Can you check your syslog for MySQL errors?

kwickcut 10th February 2012 21:51

var/log/mysql.err 0 bytes
var/log/mysql.log 0 bytes

for sys logs do you have an email i can send the logs to dont want to display this information on the open net



kwick

falko 11th February 2012 13:48

Quote:

Originally Posted by kwickcut (Post 273352)
for sys logs do you have an email i can send the logs to dont want to display this information on the open net

Can you replace your IP addresses or hostnames and post the excerpt here?


All times are GMT +2. The time now is 08:00.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.