Access denied to MySQL

Webmin
1

I cannot access MySQL Database Server from within Webmin, though it is running according to the System and Server Status section. I have already reinstalled both LAMP and Webmin, yet the problem is not solved and therefore I cannot install Virtualmin as a module. This is Webmin 1.520 installed in Ubuntu 10.10 via Synaptic, and after, to access, did /usr/share/webmin/changepass.pl /etc/webmin root PASSWORD Thanks in advance.

Here is the output:

MySQL Database Server
Login failed : Incorrect administration username or password
The full MySQL error message was : DBI connect failed : Access denied for user ‘root’@‘localhost’ (using password: YES)

And here is some more info:

mysql -h mysql -p
ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (1)

mysql -p -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1773
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)
Copyright © 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql>

mysqladmin status
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@‘localhost’ (using password: NO)’

mysqladmin -p status
Uptime: 1226 Threads: 1 Questions: 5267 Slow queries: 0 Opens: 11885 Flush tables: 1 Open tables: 64 Queries per second avg: 4.296

service mysql status
mysql start/running, process 28524

/etc/init.d/apache2 start

  • Starting web server apache2
    httpd (pid 7384) already running

netstat -ln | grep mysql
unix 2 [ ACC ] FLUJO ESCUCHANDO 91277 /var/run/mysqld/mysqld.sock

mysql -p -h localhost -P 3306
Welcome to the MySQL monitor…
Your MySQL connection id is 1303
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)
mysql>

mysql -u root -h localhost –p
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

sudo ps aux | grep mysql
mysql 7062 0.0 1.0 194804 39892 ? Ssl 21:05 0:05 /usr/sbin/mysqld
jmm 16835 0.0 0.0 11348 872 pts/0 S+ 23:41 0:00 grep --color=auto mysql

2

To make a probably long story short: It is highly recommended, instead of trying to manually install Virtualmin into an already partly working system, to use the automated installer script available on the vmin web page, on a freshly set up grade-A supported system (without LAMP or anything).

In your case, the system you should consider using is Ubuntu Server 10.04, which is an LTS version.

That will have two advantages: 1) a flawless and easy automatic installation and configuration of all necessary packages (doing that manually is complex and error-prone), and 2) OS updates for 5 years, as opposed to the non-LTS versions (1 or 2 years I think) .