Configuring the Password for the MySQL root accountĪccessing as a MySQL root user requires an authentication auth_socket instead of a simple password. You can either choose to configure only one of these two users or both. instead log in as a MySQL user root or as a database manager via phpMyAdmin interface. To use phpMyAdmin, do not log in as the user created automatically during the installation. To apply all the changes, restart Apache by typing: $ sudo systemctl restart apache2 Managing access privileges To do so type in: $ sudo phpenmod mbstring The only thing you will need to do is activating the PHP mbstring extension. Once the installation is completed, a phpMyAdmin configuration file will be added here: /etc/apache2/conf-enabled/nf The Just like beforehand, enter a new password, press TAB to select Ok and press Enter. Now enter and confirm a password for the application. Enter a new password, press Tab to select OK and press Enter. You are now required to enter a password for the administrator database. Once pressed Enter, the following screen will be displayed: If you do not press the spacebar, the files required for installation will not be transferred. To select it, press the spacebar and then press Enter. Select apache here, but be careful, the red dash does not select apache 2. $ sudo apt install phpmyadmin php-mbstring php-gettextīy typing Y and pressing Enter to confirm. PhpMyAdmin is on the standard Ubuntu repository.įirst update the apt index, and then download and install phpMyAdmin: $ sudo apt update In case of a local server, go to the next step and open the terminal of your server. If you haven’t done so yet, following our guide is recommended to securely connect with the SSH protocol. In this guide you will learn how to install phpMyAdmin and how to secure its access on Linux Ubuntu 18.04.įirst, connect to your server via an SSH connection. PhpMyAdmin is a GUI (Graphic User Interface) that allows to create, store and edit entire databases created with MySQL.
0 Comments
Leave a Reply. |