Hello:
I just installed Virtualmin on a new server. At the prompt for MySQL password, I changed the default "admin" to root, and entered a password. However, in Virtualmin MySQL "Change administration password" it reports no password.
I have tried the procedure here: https://uk.godaddy.com/help/reset-your-root-mysql-password-linux-17548 and it seems to accept the root password, but again Virtualmin reports "no password".
I can login with no password:
[root@localhost mysql]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.1.73 Source distribution
However, when using password I get this:
[root@localhost mysql]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
[root@localhost mysql]#
What am I doing wrong? Thanks, Bill
Here is the logfile:
170516 18:28:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
170516 18:28:26 InnoDB: Initializing buffer pool, size = 8.0M
170516 18:28:26 InnoDB: Completed initialization of buffer pool
170516 18:28:26 InnoDB: Started; log sequence number 0 50971
170516 18:28:26 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
ibution
170516 18:34:06 [Note] /usr/libexec/mysqld: Normal shutdown
170516 18:34:06 InnoDB: Starting shutdown...
170516 18:34:07 InnoDB: Shutdown completed; log sequence number 0 50971
170516 18:34:07 [Note] /usr/libexec/mysqld: Shutdown complete
170516 18:34:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende
d
170516 18:34:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
170516 18:34:22 InnoDB: Initializing buffer pool, size = 8.0M
170516 18:34:22 InnoDB: Completed initialization of buffer pool
170516 18:34:23 InnoDB: Started; log sequence number 0 50971
170516 18:34:23 [Note] Event Scheduler: Loaded 0 events
170516 18:34:23 [Note] /usr/libexec/mysqld: ready for connections.