Computing desk
< September 9	<< Aug \| September \| Oct >>	Current desk >

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

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:

\#1698 - Access denied for user 'root'@'localhost'
mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

How do I fix this? --Polyknot (talk) 15:44, 10 September 2018 (UTC)[reply]

Is this helpful? --jpgordon^{𝄢𝄆 𝄐𝄇} 04:01, 12 September 2018 (UTC)[reply]

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)[reply]