How to Manage or Access Multiple MySQL server using one PhpMyAdmin ?

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions. In this tutorial I will show you how to configure PhpMyAdmin to administrate various MySQL database servers.

To install and run PhpMyAdmin we need to install LAMP stack or indivudual each component on the server. After complete installation we need to modify the PhpMyAdmin configuration file. 

1) If installed LAMP Statck Navigate to below path. Assume you installed LAMP
    in /opt directory.

         cd  /opt/lampp/phpmyadmin/

2) In not installed LAMP Stack then Navigate to below path.

         cd  /etc/phpmyadmin/

3) Open config.inc.php file using below command.

        sudo nano config.inc.php

4) Search for the below content:

// First server

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

5) Now we will add our external MySQL database server like the above pattern.

Append below lines to the config files.
   
// Second server

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '192.168.2.100';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

// Third server

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '192.168.2.101';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Finally we need to restart the Apache web server

    1) If installed LAMP       : sudo /opt/lamp/lamp restart

    2) If not installed LAMP : sudo service apache2 restart

Now you should be able to open the PHPmyAdmin via web browser at http://192.168.2.103/phpmyadmin . You can select MySQL servers you want to connect from the “Server Choice” drop box and access it using your credentials. Thanks!! 
Have Fun.
 


Comments

Post a Comment

Popular posts from this blog

How to Install AnyDesk remote desktop client on Ubuntu

1)  Download AnyDesk.deb file from below site as per your system os (32/64)           https://anydesk.com/download 2) open terminal and login with root sudo su Enter password for root user 3) Go to Download Directory           cd Download 4) Change file permission using below command   chmod 777 anydesk.deb 5) Install package using below command           dpkg - i anydesk.deb 6) Search AnyDesk in search area
Read more

How to install Jaspersoft Studio on Eclipse

What is Jaspersoft Studio ?              Jaspersoft Studio is the new Eclipse-based report designer for JasperReports and JasperReports Server. It is a full rewrite of iReport Designer, available as Eclipse plugin, and as a standalone application. Jaspersoft Studio allows you to create sophisticated layouts containing charts, images, subreports, crosstabs and much more. You can access your data through JDBC, TableModels, JavaBeans, XML, Hibernate, CSV, and custom sources, then publish your reports as PDF, RTF, XML, XLS, CSV, HTML, XHTML, text, DOCX, or OpenOffice.                      Jaspersoft Studio's primary goal is to provide the features in the well-known Jaspersoft Report Editor, available as a port of iReport Designer. Installation Steps 1)  Go to Help->Eclipse Marketplace... 2)  Type "Jaspersoft Studio" in search field and press enter 3)  Click on "install" button in Jaspersoft Studio 4)  Follow the process
Read more

What is Advanced Encryption Standard (AEC) and online tool to encrypt and decrypt data using AEC.

How to use AES encryption? If you want to encrypt a text put it in the white textarea above, set the key of the encryption then push the Encrypt button.The result of the encryption will appear in base64 encoded to prevent character encoding problems.If you want to decrypt a text be sure it is in base64 encoded and is encrypted with AES algorithm!Put the encrypted text in the white textarea, set the key and push the Decrypt button. When is helpful to use AES encryption? When you want to encrypt a confidential text into a decryptable format, for example when you need to send sensitive data in e-mail.The decryption of the encrypted text it is possible only if you know the right password. What is AES encryption? AES (acronym of Advanced Encryption Standard) is a symmetric encryption algorithm.The algorithm was developed by two Belgian cryptographer Joan Daemen and Vincent Rijmen. AES was designed to be efficient in both hardware and software, and supports a block leng
Read more