Wikipedia:Reference desk/Archives/Computing/2018 September 10
| 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
editCan't login through phpmyadmin
editI'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)
- Is this helpful? --jpgordon𝄢𝄆 𝄐𝄇 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)