Wikipedia:Reference desk/Archives/Computing/2018 September 10

= September 10 =

Can't login through phpmyadmin
I've installed Ubuntu in VirtualBox and I have installed Apache, MySQL, PHP, and PHPmyadmin. It did not ask me to set a root password for MySQL but phpMyAdmin requires a password. So I opened up MySQL in a terminal and assigned a new password to root. However, I still can't login through phpMyAdmin. I get the following error messages: How do I fix this? --Polyknot (talk) 15:44, 10 September 2018 (UTC)
 * \#1698 - Access denied for user 'root'@'localhost'
 * mysqli_real_connect: (HY000/1698): Access denied for user 'root'@'localhost'
 * Is this helpful? --jpgordon&#x1d122;&#x1d106; &#x1D110;&#x1d107; 04:01, 12 September 2018 (UTC)
 * I have tried up to step 5. At step 6, MySQL gives the following error: "ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded". Also, the file /etc/my.cnf does not exist. I assumed he meant /etc/MySQL/my.cnf but this file had no [mysqld] so instead I found it on the file /etc/MySQL/MySQL.conf.d/mysqld.cnf. --Polyknot (talk) 14:28, 12 September 2018 (UTC)