Differences

This shows you the differences between two versions of the page.

--- install_apache_mysql_php_linux_ubuntu_server [2020/06/08 22:49] – [Installing phpMyAdmin] wikiadmin
+++ install_apache_mysql_php_linux_ubuntu_server [2020/06/08 23:02] – [Workaround Errors in setting up phpmyadmin@localhost with all privileges involving dbconfig-common] wikiadmin
@@ Line 255: / Line 255: @@
 ===== Workaround Errors in setting up phpmyadmin@localhost with all privileges involving dbconfig-common =====
+Are you getting errors when trying to login to PhpMyAdmin as root?
+<QUOTE>
+Cannot log in to the MySQL server
+mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
+Connection for controluser as defined in your configuration failed.
+mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
+or
+#1698 - Access denied for user 'root'@'localhost'
+</QUOTE>
 ==== Create a new admin user or new root user and password with access from any IP remotely ====
@@ Line 282: / Line 298: @@
 </code>
+Now, let's grant the new rootuser user all privileges including with Grant Option, like this:
+<code>
+GRANT ALL PRIVILEGES ON *.* TO 'rootuser'@'%' WITH GRANT OPTION;
+</code>
+And, then run this command:
+<code>
+FLUSH PRIVILEGES;
+</code>
+Now, go log into phpmyadmin through a webpage on a remote device with the username rootuser and the password you installed for rootuser. You should have success now.