MariaDB : Install phpMyAdmin2019/04/26 |
Install phpMyAdmin to operate MariaDB on web browser from Client Computers.
|
|
[1] | |
[2] | |
[3] | Install phpMyAdmin. |
root@www:~#
apt -y install phpmyadmin php-gettext # select Web Server Software you'd like to use phpMyAdmin
+------------------------+ Configuring phpmyadmin +-------------------------+
| Please choose the web server that should be automatically configured to |
| run phpMyAdmin. |
| |
| Web server to reconfigure automatically: |
| |
| [*] apache2 |
| [ ] lighttpd |
| |
| |
| <Ok> |
| |
+---------------------------------------------------------------------------+
# answer [No] to proceed on this example
+------------------------+ Configuring phpmyadmin +-------------------------+
| |
| The phpmyadmin package must have a database installed and configured |
| before it can be used. This can be optionally handled with |
| dbconfig-common. |
| |
| If you are an advanced database administrator and know that you want to |
| perform this configuration manually, or if your database has already |
| been installed and configured, you should refuse this option. Details |
| on what needs to be done should most likely be provided in |
| /usr/share/doc/phpmyadmin. |
| |
| Otherwise, you should probably choose this option. |
| |
| Configure database for phpmyadmin with dbconfig-common? |
| |
| <Yes> <No> |
| |
+---------------------------------------------------------------------------+
# if you'd like to login to phpMyAdmin with root, change settings like follows root@www:~# mysql -u root -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 45 Server version: 10.3.13-MariaDB-2 Ubuntu 19.04 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [mysql]> update mysql.user set plugin='' where user='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> exit Bye
root@www:~#
vi /etc/phpmyadmin/apache.conf # line 8: add access permission
Require ip 127.0.0.1 10.0.0.0/24
systemctl restart apache2 |
[4] | Access to [http://(your hostname or IP address)/phpmyadmin/] with web browser from any Clients which are in the Network you set to allow. Then phpMyAdmin login form is shown, login with a user in MariaDB. This exmaple shows to login with root. |
[5] | Just logined. It's possible to operate MariaDB on here. |
Sponsored Link |