Differences

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

--- 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
+++ install_apache_mysql_php_linux_ubuntu_server [2020/06/08 23:08] – [Create a new admin user or new root user and password with access from any IP remotely] wikiadmin
@@ Line 281: / Line 281: @@
 **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.
+The SSH prompt should change to the MySQL console prompt that looks like this:
+<BLOCK>mysql></BLOCK>
+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 for creating a new user from the MySQL console prompt; however, only the third choice may actually allow for logging into PhpMyAdmin as a root user from any remote IP.
 <code>