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 19:42] – [Install MySQL Database Server] wikiadmin | 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 | ||
---|---|---|---|
Line 253: | Line 253: | ||
When prompted to create the phpMyAdmin database, provide your admin user access details and take the remaining steps to complete the installation. | When prompted to create the phpMyAdmin database, provide your admin user access details and take the remaining steps to complete the installation. | ||
+ | ===== Workaround Errors in setting up phpmyadmin@localhost with all privileges involving dbconfig-common ===== | ||
+ | ==== Create a new admin user or new root user and password with access from any IP remotely ==== | ||
+ | Using SSH access to the Ubuntu Server, log into the mysql console using as the user root with the password for root that was established when installing MySQL database server on Ubuntu. | ||
+ | < | ||
+ | sudo mysql -u root -p | ||
+ | </ | ||
+ | **Enter password:** | ||
+ | |||
+ | Now, Create a new MySQL admin/root user with all privileges including GRANT privileges and make sure that the user can login from any IP remotely rather than only having privileges from @localhost. There are 3 choices of commands in the code block below, and the third choice will actually allow for logging into PhpMyAdmin as a root user. | ||
+ | |||
+ | < | ||
+ | CREATE USER ' | ||
+ | |||
+ | CREATE USER ' | ||
+ | |||
+ | CREATE USER ' | ||
+ | </ | ||
+ | |||
+ | So, for example, this should work (and ensure that you are logged into the console prompt at mysql> | ||
+ | |||
+ | < | ||
+ | CREATE USER ' | ||
+ | |||
+ | </ | ||
+ | |||
+ | Now, let's grant the new rootuser user all privileges including with Grant Option, like this: | ||
+ | |||
+ | < | ||
+ | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | |||
+ | FLUSH PRIVILEGES; | ||
+ | </ | ||
+ | |||
+ | 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. | ||
install_apache_mysql_php_linux_ubuntu_server.txt · Last modified: 2020/06/08 23:20 by wikiadmin