Greetings! I recently built a Ubuntu 15.10 Perfect Server with ISPConfig 3. Everything seems to be working fine but when I try to log into PHPMYADMIN I can't with root. I get an error "Cannot log in to the MySQL server" I know I am using the correct password. Any suggestions as to where I can look to fix this? Thanks
FIXED! I needed this: echo "update user set plugin='' where User='root'; flush privileges;" | mysql --defaults-file=/etc/mysql/debian.cnf mysql
This command disables the Unix plugin in MySQL which configures MySQL to use the ssh root password instead of the MySQL root password for authentication.
SOLVED 1. service mysql stop 2. mysqld_safe --skip-grant-tables & 3. mysql -u root 4. mysql commands: mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD-HERE") where User='root'; mysql> flush privileges; mysql> quit 5. service mysql stop 6. service mysql start Try to login using your new password: 7. mysql -u root -p