My Professional Profile

I am Johnson Augustine Sr.Software Engineer and System Architect. I have 10 Yrs of hands on expertise in ASP.net 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 http://linkedin.com/in/johnsontaugustine Email : johnsonaugustine@live.com

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:
$i++;
$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.
$i++;
Incrementing variable for each server
$cfg['Servers'][$i]['host']
Server host name or IP
$cfg['Servers'][$i]['port']
MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']
Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']
How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']
The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']
Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['auth_type']
Method of authentication
$cfg['Servers'][$i]['user']
Account username
$cfg['Servers'][$i]['password']
Account password

No comments:

Post a Comment

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