You can install phpMyAdmin for administrating MySQL/MariaDB databases from the comfort of a web browser using the following command: Now, let’s access it from the web browser: # echo “” | sudo tee /var/www/html/info.php Once PHP installed, for testing purpose, create a simple info.php page using following command: # apt install php php-common php-mysql php-gd php-cli -y Here we are installing the default PHP version 7.2 and other modules for web deployments using the following command: Remove test database and access to it? : y Then enter yes/y to the following security questions: It will ask you to enter the current password for root (enter for none): Once the script gets executed, it will ask multiple questions. Let’s secured the installation using the following command: The default configuration of the MariaDB will not be secured. # apt install mariadb-server mariadb-client -y Now, let’s verify the Apache installation. In case, you enabled firewall and firewall block requests of the apache web server, open a port in the firewall. It is known as LAMP and installs on the Linux system environment. In this post, we will show you how to install and secure PhpMyAdmin on Ubuntu 20.04.Ī root password is set up on your server.īefore starting, the MariaDB database server must be installed in your server.In this article, we will learn to install Apache, MariaDB, PHP, and PHPMyAdmin in Ubuntu 18.04 server.Īpache, MySQL/MariaDB, and PHP are composed of packages. PhpMyAdmin allows you to perform several database operations including, create, copy, rename, alter and drop databases, perform table maintenance, add, edit and drop fields, browse through databases and tables, export data to SQL, CSV, XML, Word, Excel, PDF and LaTeX formats, manage MySQL users and privileges, execute any SQL-statement and many more. It is designed for those who can not interact with MySQL through a command-line interface. It is written in PHP and supports 72+ languages. PhpMyAdmin is a free, open-source, web-based tool for managing MySQL and MariaDB databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |