Jump to content

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

From Wikipedia, the free encyclopedia
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

[edit]

Can't login through phpmyadmin

[edit]

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]