![]() ![]() Begin by first starting MariaDB and enabling it to start at boot time as shown. Likewise, you also need to secure your MariaDB instance. $ sudo dnf install httpd mariadb-server php php-cli php-json php-mysqli php-xml php-mbstring php-pdo php-pecl-zip php-mysqlnd -y Step 2) Secure MariaDB server This installs Apache, MariaDB, and PHP 7.2 alongside its modules. $ sudo dnf update -yĪnd just like in Ubuntu, install the LAMP stack by running the command shown. Step 1) Install LAMP serverįirst off, update all the system packages to their latest versions as shown. To install phpMyAdmin on CentOS 8 / RHEL 8, follow the steps shown. Let’s now switch gears and see how we can do the same for CentOS 8.x / RHEL 8.x phpMyAdmin Installation Steps on CentOS 8.x / RHEL 8.x ![]() This concludes the installation of phpMyAdmin on Ubuntu 20.04 LTS / 21.04. ![]() You can now log in as the root user and the root password you used when securing the MariaDB server in Step 2. The root user is now using the mysql_native_password plugin for authentication. Then flush privileges for the changes to come into effect. ![]() UPDATE er SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket' Run the command below to modify the plugin for the root user. We need to change this to the mysql_native_password plugin. SELECT user, authentication_string, plugin, host FROM er įrom the results, we see that the root user is using the unix_socket plugin for authentication. Next, list all the MariaDB users and their properties such as authentication string, plug, and host. We need to change this authentication method. Step 5) Configuring the password for the MariaDB root accountĪuthenticating as the root user requires the mysql_native_password plugin for authentication. Let’s now see how we can accomplish this. This is because we have not yet configured the mysql_native_password plugin for authentication for the root user. At this point, however, you cannot log in as the root user. NOTE: To have all the privileges on the databases and tables, you need to log in as the root user. This ushers you to the phpMyAdmin dashboard as shown. Log in using the user phpmyadmin and the password that you configured in Step 3. To log in to phpMyAdmin, browser the URL shown: $ sudo systemctl restart apache2 Step 4) Log in to phpMyAdmin When the installation is complete, restart the Apache webserver as shown. Then confirm it as shown and press ‘ ENTER’. The next step prompts you to provide a password for the phpmyadmin user. When the database is configured, a user called phpmyadmin is created. Next, hit ‘ YES’ to create the database for phpmyadmin. Since we are running Apache, press the SPACE key on the ‘ apache2’ option to select it and hit ENTER. $ sudo apt install phpmyadminĪlong the way, you will be prompted to select the web server. Once the LAMP stack is installed and the database secured, proceed and install phpmyadmin as follows. $ sudo mysql_secure_installationīe sure to set the root password as shown.įor the remainder of the prompts, simply type ‘Y’ for the most recommended options. We therefore need to go a step further and harden the MariaDB engine. The default settings for MariaDB are not secure and do not provide the degree of security recommended for the database server. When prompted press ‘Y’ and hit ENTER to install all the packages. $ sudo apt install apache2 apache2-utils mariadb-server php7.4 libapache2-mod-php7.4 php7.4-mysql php7.4-common php7.4-cli php7.4-json php7.4opcache php7.4-readline Launch your terminal and execute the command below to update the package lists $ sudo apt update ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |