In this article, we have seen how our support engineers install Apache, MariaDB, PHP, and phpMyAdmin in Ubuntu 18.04 server. Now, we can log in to phpMyAdmin using the admin user. MariaDB > GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Search for Servers AllowNoPassword options and set the value to TRUE. Open phpMyAdmin configuration file using your preferred text editor. To create a new user, login into MariaDB using the following command: Steps to allow no-password login to MySQL or MariaDB in phpMyAdmin: Make sure your MySQL or MariaDB user is passwordless and accessible by phpMyAdmin s system user. We need to create a new user and grant all privileges to that user. Once everything installed, you can now restart the apache2 service to effect the recent changes. In this tutorial, we will see how to install phpMyAdmin with LAMP stack in Ubuntu 16.04 lTS server. Currently, It supports MySQL, MariaDB, and Drizzle database servers. Next, enter the password for the MySQL/MariaDB administrative user so the installer can create a database for phpmyadmin. Using phpMyAdmin, we can create, delete, rename, edit databases, tables, fields, and also we can directly execute any SQL commands. Through the package installation process, you will be asked to choose the web server that should be automatically configured to run phpMyAdmin, select apache by pressing the space bar and press Enter. 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: Now, open the phpmyadmin page on the web browser > -> Changing the default phpmyadmin page to custom name However, we have installed phpmyadmin and successfully now you can try to upload your website code and can access with your domain. 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 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |