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 22:49] – [Installing phpMyAdmin] 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 255: | Line 255: | ||
===== Workaround Errors in setting up phpmyadmin@localhost with all privileges involving dbconfig-common ===== | ===== 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. | + | Are you getting errors when trying to login to PhpMyAdmin as root? |
+ | |||
+ | < | ||
+ | Cannot log in to the MySQL server | ||
+ | |||
+ | mysqli_real_connect(): | ||
+ | |||
+ | Connection for controluser as defined in your configuration failed. | ||
+ | |||
+ | mysqli_real_connect(): | ||
+ | |||
+ | or | ||
+ | |||
+ | #1698 - Access denied for user ' | ||
+ | </ | ||
+ | ==== Create a new PhpMyAdmin root user and password having PhpMyAdmin access from any IP remotely ==== | ||
+ | |||
+ | 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 265: | 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 278: | Line 298: | ||
< | < | ||
- | CREATE USER ' | + | CREATE USER ' |
</ | </ | ||
+ | Now, let's grant the new user named ' | ||
+ | |||
+ | < | ||
+ | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | </ | ||
+ | |||
+ | And lastly, run this command: | ||
+ | |||
+ | < | ||
+ | FLUSH PRIVILEGES; | ||
+ | </ | ||
+ | |||
+ | Exit the MySQL console and return to the SSH user prompt, with the exit command: | ||
+ | |||
+ | < | ||
+ | |||
+ | Now, open your web browser and log into PhpMyAdmin through a webpage on a remote device with the username ' | ||
install_apache_mysql_php_linux_ubuntu_server.1591656565.txt.gz · Last modified: 2020/06/08 22:49 by wikiadmin