access-xampp-mysql-database-on-local-system-using-static-ip

11/06/2020

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.