Install Config Wiki

All about installing, configuring and troubleshooting

User Tools

Site Tools

Trace:
install_apache_mysql_php_linux_ubuntu_server

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
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] wikiadmininstall_apache_mysql_php_linux_ubuntu_server [2020/06/08 23:14] – [Create a new admin user or new root user and password with access from any IP remotely] wikiadmin
Line 283: Line 283:
 The SSH prompt should change to the MySQL console prompt that looks like this: The SSH prompt should change to the MySQL console prompt that looks like this:
  
-<BLOCK>mysql></BLOCK>+<QUOTE>mysql></QUOTE>
  
 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. 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.
Line 316: Line 316:
 Exit the MySQL console and return to the SSH user prompt, with the exit command: Exit the MySQL console and return to the SSH user prompt, with the exit command:
  
-<BLOCK>mysql> exit</BLOCK>+<QUOTE>mysql> exit</QUOTE>
  
 Now, open your web browser and 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.  Now, open your web browser and 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