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 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:13] – [Create a new admin user or new root user and password with access from any IP remotely] wikiadmin | ||
---|---|---|---|
Line 281: | Line 281: | ||
**Enter password:** | **Enter password:** | ||
- | Now, Create | + | The SSH prompt should change to the MySQL console prompt that looks like this: |
+ | |||
+ | < | ||
+ | |||
+ | Now, create | ||
< | < | ||
Line 294: | Line 298: | ||
< | < | ||
- | CREATE USER ' | + | CREATE USER ' |
</ | </ | ||
- | Now, let's grant the new rootuser | + | Now, let's grant the new user named ' |
< | < | ||
Line 304: | Line 308: | ||
</ | </ | ||
- | And, then run this command: | + | And lastly, run this command: |
< | < | ||
Line 310: | Line 314: | ||
</ | </ | ||
- | Now, go log into phpmyadmin | + | Exit the MySQL console and return to the SSH user prompt, with the exit command: |
+ | |||
+ | < | ||
+ | |||
+ | Now, open your web browser and log into PhpMyAdmin | ||
install_apache_mysql_php_linux_ubuntu_server.txt · Last modified: 2020/06/08 23:20 by wikiadmin