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 |