My Professional Profile

I am Johnson Augustine Sr.Software Engineer and System Architect. I have 10 Yrs of hands on expertise in MVC 5 , Angular 5 , C# MVC Razor, WPF MVVM , Android , IOS Swift 3 , IOS11 MSSQL,MySQL Database,,PHP,C/C++/Visual C++/G++/QT++,Com,DirectX,Open CV,EMGU CV , embedded System Development , [Raspberry PI]. ,html,Javascript,Jquery,Ajax.CSS , Networking ,Cyber security, Ethical Hacking You can see my professional profile at Email :

Wednesday, 29 January 2014

How to access and manage mysql database from local system

Access and work on your remote database sever from localhost using phpMyAdmin. It only requires a few changes to the configuration file found in the phpMyAdmin folder.
 set of config options would look like  to this:
$cfg['Servers'][$i]['host']          = '';
$cfg['Servers'][$i]['port']          = '';
$cfg['Servers'][$i]['socket']        = '';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['extension']     = 'mysql';
$cfg['Servers'][$i]['compress']      = FALSE;
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'username';
$cfg['Servers'][$i]['password']      = 'password';

This might be a personal preference but when I edit config files, I add my own changes to the bottom of the file if I can, as this makes it easier to find later on.
Incrementing variable for each server
Server host name or IP
MySQL port - leave blank for default port
Path to the socket - leave blank for default socket
How to connect to MySQL server ('tcp' or 'socket')
The php MySQL extension to use ('mysql' or 'mysqli')
Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
Method of authentication
Account username
Account password

No comments:

Post a Comment

Note: only a member of this blog may post a comment.