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 (c) 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
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) .