Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Technical

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 9th February 2012, 20:05
kwickcut kwickcut is offline
Senior Member
Join Date: Nov 2005
Location: nj usa
Posts: 226
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
ernel panic - not syncing: VFS: Unable to mount root fs on unknown-block(0,0)
i used
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!

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

Operating system Ubuntu Linux 10.04.4
ISPConfig Version:
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


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix doesn't have Nolan Installation/Configuration 5 13th April 2011 06:00
Cannot login to SquirrelMail sellotape Installation/Configuration 13 26th October 2010 12:03
Failed during pvmove, howto: set up software raid 1 on running LVM system sbh77 HOWTO-Related Questions 2 8th October 2010 01:11
Problem with services!! banzaiwebstudio.com Installation/Configuration 7 19th May 2010 22:13
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 19:26

All times are GMT +2. The time now is 05:16.

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