Access XAMPP Mysql database on local system using static IP.
Here i'm goging to Explain how to access XAMPP Mysql database on local system using static IP.
For Access Mysql Port must be open from server.
Step 1 – Go to your server where you have install Xampp with Mysql.
Step 2 – open phpmyadmin then window will display As –
Click on User Account Tab then window will display As-
Click on Add User Account then window will open here you provide Information As-
User Name - <User you want to create>
Host Name - here % means All system where you want to Access or
If you want to provide specific system then provide here IP Address of that System.
Password - Type password
In Database for user account Section.
Check the check box as per Required.
In Global Privilages section
Give the user Privilages as per Required here I have set All.
Now go to your drive where you have install XAMPP and go to phpMyAdmin Folder as below.
E:\xampp\phpMyAdmin
Here you will get config.inc.php File open it with Note Pad ++ or word pad and write below section.
$i++;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '103.205.66.80'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'einvuser'; //user name for your remote server
$cfg['Servers'][$i]['password'] = 'Shashi@123@'; //password
Now Restart Mysql from XAMPP. And refresh phpMyAdmin
Here left side you will get user Details as below screen.
Now Form Client Machine Install XAMPP and Configure below.
Now go to your drive where you have install XAMPP and go to phpMyAdmin Folder as below.
E:\xampp\phpMyAdmin
Here you will get config.inc.php File open it with Note Pad ++ or word pad and write below section.
$i++;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '103.205.66.80'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'einvuser'; //user name for your remote server
$cfg['Servers'][$i]['password'] = 'Shashi@123@'; //password
Now Restart Mysql from XAMPP. And refresh phpMyAdmin
You are able to access server mysql database on client system.