![]() ![]() This renders impressive usability and security but it also makes things intricate especially when you want to allow phpMyAdmin admin rights via the root database user. By default, the root database user authenticates via the unix_socket in a Debian system. It is wise if you use a different account to log in instead of logging in as phpmyadmin with the password set when configuring phpMyAdmin. ![]() ![]() This database user carries out some underlying process for this application. Once PhpMyAdmin is installed on Debian 9, it automatically creates a new user, phpmyadmin. Modifying Database User’s Privileges And Authentication However, before any of your MariaDB user can use this application, you need to adjust their privileges and authentication. $ sudo systemctl restart apache2īy now, the phpMyAdmin is installed and set up for first use. Now, issue the command below to restart Apache and implement the changes. To enable this extension, execute the command below: $ sudo phpenmod mbstring However, you should activate mbstring a PHP extension that converts strings into unique encodings and its vital in managing nonASCII strings. The installation will add a configuration file for phpMyAdmin into the directory, /etc/apache2/conf-enabled/, where it’s read automatically. Choose a password that is easy to remember but secure enough. ![]() Next, you will be requested to enter and retype a new MySQL database password for your phpMyAdmin. Note: If you fail to select apache2, the installer will not be able to transfer the required files during the installation.īesides, you will get another prompt asking you whether to utilize the dbconfig-common to configure your database. Once question prompt appears, press the space bar to select “apache2” the hit ENTER to allow the process to continue. You will be required to answer some questions to configure the installation correctly. Then, execute the command below to install phpMyAdmin and its required files: $ sudo apt install phpmyadmin php-mbstring php-gettext To install the phpMyAdmin tool from these repositories, first, issue the command below to update the package index: $ sudo apt update The default Debian system repositories avail the phpMyAdmin package. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |