This allows for some greater security and usability in many cases, but it can also complicate things when you need to allow an external program - like phpMyAdmin - to access the user. In Ubuntu systems running MySQL 5.7 (and later versions), the root MySQL user is set to authenticate using the auth_socket plugin by default rather than with a password. Configuring Password Access for the MySQL Root Account
Rather than logging in as this user with the administrative password you set during installation, it’s recommended that you log in as either your root MySQL user or as a user dedicated to managing databases through the phpMyAdmin interface.
When you installed phpMyAdmin onto your server, it automatically created a database user called phpmyadmin which performs certain underlying processes for the program. Step 2 - Adjusting User Authentication and Privileges However, before you can log in and begin interacting with your MySQL databases, you will need to ensure that your MySQL users have the privileges required for interacting with the program. PhpMyAdmin is now installed and configured. The only thing you need to do is explicitly enable the mbstring PHP extension, which you can do by typing: $ sudo phpenmod mbstringĪfterwards, restart Apache for your changes to be recognized: $ sudo systemctl restart apache2
The installation process adds the phpMyAdmin Apache configuration file into the /etc/apache2/conf-enabled/ directory, where it is read automatically.
You will then be asked to choose and confirm a MySQL application password for phpMyAdmin. Select Yes when asked whether to use dbconfig-common to set up the database. For the server selection, choose apache2. Hit SPACE, TAB, and then ENTER to select Apache. If you do not hit SPACE to select Apache, the installer will not move the necessary files during installation. Warning: When the prompt appears, “apache2” is highlighted, but not selected. This will ask you a few questions in order to configure your installation correctly. This is done by updating your server’s package index and then using the apt packaging system to pull down the files and install them on your system: sudo apt update $ sudo apt install phpmyadmin php-mbstring php-gettext To get started, we will install phpMyAdmin from the default Ubuntu repositories. Once you are finished with these steps, you’re ready to get started with this guide. This will require you to register a domain name, create DNS records for your server, and set up an Apache Virtual Host. If you do not have an existing domain configured with an SSL/TLS certificate, you can follow this guide on securing Apache with Let’s Encrypt on Ubuntu 18.04. Executes and returns results for arbitrary SQL queriesįor these reasons, and because it is a widely-deployed PHP application which is frequently targeted for attack, you should never run phpMyAdmin on remote systems over a plain HTTP connection. Handles authentication using MySQL credentials. Communicates directly with your MySQL installation. If this is not completed yet, you can follow this guide on installing a LAMP stack on Ubuntu 18.04.įinally, there are important security considerations when using software like phpMyAdmin, since it: We’re also going to assume that you’ve completed a LAMP (Linux, Apache, MySQL, and PHP) installation on your Ubuntu 18.04 server. Prerequisitesīefore you get started with this guide, you need to have some basic steps completed.įirst, we’ll assume that your server has a non- root user with sudo privileges, as well as a firewall configured with ufw, as described in the initial server setup guide for Ubuntu 18.04. In this guide, we’ll discuss how to install and secure phpMyAdmin so that you can safely use it to manage your databases on an Ubuntu 18.04 system. PhpMyAdmin was created so that users can interact with MySQL through a web interface. While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt.
0 kommentar(er)
