The author selected the Diversity in Tech Fund to receive a donation as part of the Write for DOnations program. Show IntroductionThe phpMyAdmin tool allows users to interact with MySQL database management through a web interface that can handle the administration tasks. This tool provides a web interface to create, store, and edit entire databases created with MySQL. You can use the script interface to run PHP scripts to connect to MySQL databases for customized operations rather than using the command line interface. In this tutorial, you will install phpMyAdmin and use it to connect to a MySQL Managed Database cluster on your Ubuntu 20.04 server. PrerequisitesTo complete this guide, you will need:
Step 1 — Installing phpMyAdmin and Configuring ApacheIn this step, you will install the First, log in to your Ubuntu server and update it with the latest packages:
Then install phpMyAdmin from the default Ubuntu repositories:
During the installation process, you will be prompted to choose a web server: Apache or Lighttpd. Select Next, you will be prompted to select Choose Once the
Add the following line to the bottom of the file: /etc/apache2/apache2.conf
This line will set up phpMyAdmin under the Apache web server. Save and close the file. You have now updated your server by installing phpMyAdmin and configuring Apache. Next, you will configure phpMyAdmin with the MySQL Managed Database credentials. Step 2 — Configuring phpMyAdmin with MySQL Managed DatabaseIn this step, you will configure phpMyAdmin with your MySQL Managed Database connection details. Navigate to your MySQL Managed Database panel and find the Connection Details section. Click the Download CA certificate link to download the
In a new terminal session from your local machine, copy the certificate file to
Back in the terminal session for your server, open the phpMyAdmin configuration
file named
At the bottom of the /etc/phpmyadmin/config.inc.php
The initial Because phpMyAdmin supports the administration of multiple MySQL servers, the
If you want to add another MySQL Managed Database, you can add lines from Save and close the configuration file. Then restart
Now you can access the web interface by visiting your server’s public IP address or your domain name followed by
You will have to supply your MySQL Managed Database username and password to log in to the MySQL Database. Once you have logged in to the database, you will see the following administration screen: You can add the IP address of the server where you have installed phpMyAdmin as a trusted source. This modification will limit access to the database to this specific IP address. ConclusionYou have now configured phpMyAdmin to connect to a MySQL Managed Database cluster on your Ubuntu 20.04 server. Using this interface, you can create databases, users, and tables and perform the usual operations like deleting and modifying structures and data. You can review other database tutorials, such as securing your phpMyAdmin instance in Step 3 of How To Install and Secure phpMyAdmin on Ubuntu 20.04. What is the URL to access phpMyAdmin?The standard URL for a phpMyAdmin installation is https://ipaddress/phpMyAdmin, where ipaddress is the IP address that you added to the configuration file in the previous section. If you want to change the URL, you can set an alias. Open the /etc/httpd/conf.
How do I connect to phpMyAdmin remotely?Contents hide. Step 1: Enable WSL on Window 10 ( Linux user skip this). Step 2: Install MySQL.. Step 3: Install phpMyAdmin locally or on a remote server.. Step 4: Edit configuration file.. Step 5: Run phpMyAdmin to access a remote database.. How do I find my phpMyAdmin IP address?For connecting remotely using the IP address/domain of your MySQL database, open the Variables menu from your phpMyAdmin homepage and search for “hostname” to get the actual domain or IP address of the database server: The phpMyAdmin homepage can be accessed by clicking on the logo in the top-left corner.
How do I log into MySQL on phpMyAdmin?Open your browser and go to localhost/PHPMyAdmin or click “Admin” in XAMPP UI. Now click Edit privileges and go to Change Admin password, type your password there and save it. Remember this password as it will be used to connect to your Database.
|