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Īs mentioned before, phpMyAdmin handles authentication using MySQL credentials. Your phpMyAdmin installation is now operational. sudo ln -s /usr/share/phpmyadmin /var/www/ your_domain/phpmyadmin.If you followed the prerequisite LEMP stack tutorial, your Nginx installation’s document root is /var/www/ your_domain/ However, for the Nginx web server to find and serve the phpMyAdmin files correctly, you’ll need to create a symbolic link from the installation files to Nginx’s document root directory. Once the apt install command completes, phpMyAdmin will be fully installed. INSTALL COMPONENT "file://component_validate_password".Once phpMyAdmin is installed, you can open the MySQL prompt once again with sudo mysql or mysql -u root -p and then run the following command to re-enable the Validate Password component: Then try installing the phpmyadmin package again and it will work as expected: UNINSTALL COMPONENT "file://component_validate_password" įollowing that, you can close the MySQL client:.Note that this won’t actually uninstall it, but just stop the component from being loaded on your MySQL server: Or, if you enabled password authentication for the root MySQL user, run this command and then enter your password when prompted:įrom the MySQL prompt, run the following command to disable the Validate Password component. To resolve this, select the abort option to stop the installation process. As of this writing, enabling this component will trigger an error when the phpMyAdmin installation process attempts to set a password for the phpmyadmin user: Note: Assuming you installed MySQL by following Step 2 of the prerequisite LEMP stack tutorial, you may have decided to enable the Validate Password plugin. You will be asked to define a new password for the phpmyadmin MySQL user, but because this isn’t a password you need to remember you can leave it blank and let phpMyAdmin randomly create a password. This will set up the internal database and administrative user for phpMyAdmin. Next, you’ll be prompted whether to use dbconfig-common for configuring the application database. Instead, press TAB to highlight the and then press ENTER to continue the installation process. However, because you are using Nginx as a web server you shouldn’t choose either of these options. phpMyAdmin can automatically make a number of configuration changes to ensure that it works correctly with either of these web servers upon installation. Now you can install phpMyAdmin by running the following command:ĭuring the installation process, you will be prompted to choose a web server (either Apache or Lighttpd) to configure. You can install phpMyAdmin by using APT to download the phpmyadmin package from the default Ubuntu repositories.īegin by updating the server’s package index: Once you have these prerequisites in place, you can begin following Step 1 of this guide. Warning: If you don’t have an SSL/TLS certificate installed on the server and you still want to proceed, please consider enforcing access via SSH Tunnels as explained in Step 5 of this guide. If you do not have an existing domain configured with a valid certificate, follow this guide on securing Nginx with Let’s Encrypt on Ubuntu 20.04 to set this up. To install and configure these components, follow our guide on How To Install Linux, Nginx, MySQL, PHP (LEMP stack) on Ubuntu 20.04.Īdditionally, because phpMyAdmin handles authentication using MySQL credentials, we strongly recommend that you install an SSL/TLS certificate to enable encrypted traffic between server and client.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |