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 revision | ||
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 | install_apache_mysql_php_linux_ubuntu_server [2020/06/08 23:20] (current) – [Create a new admin user or new root user and password with PhpMyAdmin access from any IP remotely] wikiadmin | ||
---|---|---|---|
Line 271: | Line 271: | ||
#1698 - Access denied for user ' | #1698 - Access denied for user ' | ||
</ | </ | ||
- | ==== Create a new admin user or new root user and password | + | ==== Create a new PhpMyAdmin |
- | 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. | + | Using SSH access to the Ubuntu Server, log into the mysql console using as the MySQL user 'root' and with the password for the user root that was established when installing MySQL database server on Ubuntu. |
< | < | ||
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> | + | <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 298: | Line 298: | ||
< | < | ||
- | CREATE USER ' | + | CREATE USER ' |
</ | </ | ||
- | Now, let's grant the new rootuser | + | Now, let's grant the new user named ' |
< | < | ||
Line 308: | Line 308: | ||
</ | </ | ||
- | And, then run this command: | + | And lastly, run this command: |
< | < | ||
Line 314: | 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.1591657690.txt.gz · Last modified: 2020/06/08 23:08 by wikiadmin