install_apache_mysql_php_linux_ubuntu_server
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
install_apache_mysql_php_linux_ubuntu_server [2020/06/08 22:54] – [Create a new admin user or new root user and password with access from any IP remotely] 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 ===== | ===== 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? | ||
+ | |||
+ | < | ||
+ | Cannot log in to the MySQL server | ||
+ | |||
+ | mysqli_real_connect(): | ||
+ | |||
+ | Connection for controluser as defined in your configuration failed. | ||
+ | |||
+ | mysqli_real_connect(): | ||
+ | |||
+ | or | ||
+ | |||
+ | #1698 - Access denied for user ' | ||
+ | </ | ||
==== Create a new admin user or new root user and password with access from any IP remotely ==== | ==== Create a new admin user or new root user and password with access from any IP remotely ==== | ||
Line 286: | Line 302: | ||
< | < | ||
GRANT ALL PRIVILEGES ON *.* TO ' | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | </ | ||
+ | And, then run this command: | ||
+ | |||
+ | < | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
</ | </ |
install_apache_mysql_php_linux_ubuntu_server.txt · Last modified: 2020/06/08 23:20 by wikiadmin