In the same way, you just need to provide the address, it could be IP address as well. For example, in the below-given image, we used the address of a MySQL database created on Amazon Cloud. Host: Inside the two single columns given in front of the host value enter the address of the remote database. ⇒Press the INSERT key on the keyboard and add the following lines: $i++ ⇒User arrow key and scroll down to the end of the file. So, simply on your server command line terminal type the below command to edit the configuration file of this DB management system. Now, before logging in to phpMyAdmin, we need to perform some changes.
PHPSTORM 10 CONNECT TO REMOTE DATABASE INSTALL
Again its installation is not a cumbersome job.įor Ubuntu servers: sudo apt install phpMyAdminįirst and EPEL repository and then run yum install phpmyadmin. Next, step is to set up this PHP based open-source MySQL database management application. Or dnf install mysql Step 3: Install phpMyAdmin locally or on a remote server Hence, use the below command:įor Debian, Ubuntu or similar Linux uses an APT package manager sudo apt install mysql-server Step 2: Install MySQLĪs phpMyAdmin itself needs a database to work, thus we a one for it on the local machine or server where you are planning to use phpMyAdmin. In case you already have installed WSL 1 or WSL 2 on your system then move to the next step otherwise see this tutorial first on installing WSL.
PHPSTORM 10 CONNECT TO REMOTE DATABASE WINDOWS 10
Those are using Windows 10 system can install phpMyAdmin on its built-in Linux system safely with just a single command. Step 1: Enable WSL on Window 10 ( Linux user skip this)