This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

DBI connect failed : Access denied for user 'middenbrabantse-'@'localhost' to database 'mysql'

2 posts / 0 new

Topic locked

Last post

#1 Thu, 01/03/2013 - 11:21

rubbere

DBI connect failed : Access denied for user 'middenbrabantse-'@'localhost' to database 'mysql'

I cannot access MySQL DB anymore. Don't know exactly what was the cause but I tried to set the remote access for another database. Ever since I cannot access the MySQL DB anymore and within virtualmin going to Webmin MySQL database it gives me the above message. Using phpmyadmin I cannot logon with root and the password. How can I reset this root MySQL password? I have root command line access. Any help would be greatly appreciated.

Rob

#2 Wed, 01/09/2013 - 02:45

tpnsolutions

Hi,

The steps for resetting the MySQL root password can be found in the documentation over at mysql.com.

Here's the direct link:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

*** depending on the version of MySQL you have installed, you may need to use the "Table of Contents" on the left to switch between the document version for the appropriate instructions. ***

-Peter

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist

Topic locked