![]() In the next two sections, we’ll take steps to secure our new phpMyAdmin web console. You should then be able to access the administrative interface:Ĭlick around to get familiar with the interface. For example, the root user and MySQL administrative password is a good choice to get started. To sign in, use a set of credentials for a valid MySQL user. ![]() To access the interface, go to your server’s domain name or public IP address followed by /phpmyadmin in your web browser: server_domain_or_IP/phpmyadmin With that, our phpMyAdmin installation is now operational. This was installed with phpMyAdmin, so we’ll toggle it on and restart our PHP processor: sudo ln -s /usr/share/phpmyadmin /var/www/htmlįinally, we need to enable the mcrypt PHP module, which phpMyAdmin relies on.For the Nginx web server to find and serve the phpMyAdmin files correctly, we’ll need to create a symbolic link from the installation files to our Nginx document root directory: Choose and confirm a secure password and make note of it. You will now be asked to choose and confirm a password for the phpMyAdmin application and its database (which will be created in this step). You’ll need to enter the database administrator password that you configured during the MySQL installation to allow these changes. The next prompt will ask if you would like dbconfig-common to configure a database for phpMyAdmin to use. Since Nginx, the web server we’re using, isn’t one of the available options, you can just hit TAB, and then ENTER to bypass this prompt. It will ask you which web server you would like the software to automatically configure. Then, we’ll use the apt packaging tools to pull the software down from the repositories and install it on our system:ĭuring the installation, you will be prompted for some information. With our LEMP platform already in place, we can begin by installing phpMyAdmin, which is available from Ubuntu’s default repositories.įirst, we’ll update the server’s local package index to make sure it has a fresh set of references to available packages. Once you’ve completed these prerequisite steps, you’re ready to get started with this guide. If you do not have an existing domain configured with an SSL/TLS certificate, you can follow this guide on securing Nginx with Let’s Encrypt on Ubuntu 16.04. Be sure to note your MySQL database administrator password.įinally, there are important security considerations to be aware of when using software like phpMyAdmin: it communicates directly with your MySQL installation, handles authentication using MySQL credentials, and executes and returns results for arbitrary SQL queries.įor these reasons, and because it is a widely-deployed PHP application that is frequently targeted for attack, you should never run phpMyAdmin on remote systems over a plain HTTP connection. If you haven’t done this yet, you can follow the guide on installing a LEMP stack on Ubuntu 16.04. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |