How to access remote server with local phpMyAdmin client

Question

Assuming there is a remote server and I have phpMyAdmin client installed localy on my computer  How can I access this server and manage it via phpMyAdmin client  Is that possible

User · Answer

In Ubuntu  Just you need to modify a single file in PHPMyAdmin folder i e     config inc php    Just add below lines to your    config inc php      File location    var lib phpmyadmin config inc php OR                   etc phpmyadmin config inc php  Maybe you don t have the permission for editing that file  just give the permission using this command  sudo chmod 777  var lib phpmyadmin config inc php   OR  in different systems you may have to check with these two locations   sudo chmod 777  etc phpmyadmin config inc php   Then copy and paste the code in your config inc php file       i         cfg  Servers    i   auth type          cookie        cfg  Servers    i   verbose      Database Server 2        cfg  Servers    i   host      34 12 123 31        cfg  Servers    i   connect type       tcp        cfg  Servers    i   compress          false       cfg  Servers    i   AllowNoPassword     false    And make the appropriate changes with your server details

User · Answer

I would have added this as a comment  but my reputation is not yet high enough   Under version 4 5 4 1deb2ubuntu2  and I am guessing any other versions 4 5 x or newer   There is no need to modify the config inc php file at all   Instead go one more directory down conf d   Create a new file with the   php  extension and add the lines   This is a better modularized approach and isolates each remote database server access information

User · Answer

Delete complete entries of  etc http conf d phpMyAdmin conf  And below entires in above file    x000D   x000D   lt Directory  usr share phpMyAdmin  gt  x000D     AddDefaultCharset UTF-8 x000D   x000D      lt IfModule mod authz core c gt  x000D         Apache 2 4 x000D        lt RequireAny gt  x000D          ADD following line  x000D         Require all granted x000D         Require ip 127 0 0 1 x000D         Require ip   1 x000D        lt  RequireAny gt  x000D      lt  IfModule gt  x000D      lt IfModule  mod authz core c gt  x000D         Apache 2 2 x000D        CHANGE following 2 lines  x000D       Order Allow Deny x000D       Allow from All x000D       Allow from 127 0 0 1 x000D       Allow from   1 x000D      lt  IfModule gt  x000D   lt  Directory gt  x000D   x000D   x000D    Then   run below command in MySQL prompt   GRANT ALL ON     to root localhost IDENTIFIED BY  root  lt password gt    GRANT ALL ON     to root     IDENTIFIED BY  root  lt password gt    For reference  Allow IP to Access Secured PhpMyAdmin

User · Answer

In Windows with Wamp Server Installed you may find the configuration file  C  wamp64 apps phpmyadmin4 8 4 config inc php   Change the bolow line as appropriate   cfg  Servers    i   host      127 0 0 1    cfg  Servers    i   port     3306    wampConf  mysqlPortUsed     cfg  Servers    i   extension      mysqli    cfg  Servers    i   auth type      cookie    cfg  Servers    i   user          cfg  Servers    i   password

User · Answer

Locate the file libraries config default php then find   cfg  AllowArbitraryServer     false  then set It to true note  on ubuntu the file in the path  usr share phpmyadmin libraries config default php then you will find a new filed name SERVER in the main  PHPMyAdmin page  you can add any IP or localhost for the local database

User · Answer

Go to file  phpMyAdmin config inc php at the very bottom  change the hosting details such as host  username  password etc

User · Answer

Just add below lines to your  etc phpmyadmin config inc php file in the bottom   i     cfg  Servers    i   host      HostName port     provide hostname and port if other than default  cfg  Servers    i   user      userName       user name for your remote server  cfg  Servers    i   password      Password      password  cfg  Servers    i   auth type      config            keep it as config  You will get  Current Server  drop down  with both 127 0 0 1 and one what you have provided with  cfg  Servers    i   host   can switch between the servers  More Details  http   sforsuresh in access-remote-mysql-server-using-local-phpmyadmin

User · Answer

It is certainly possible to access a remote MySQL server from a local instance of phpMyAdmin  as the other answers have pointed out  And for that to work  you have to configure the remote server s MySQL server to accept remote connections  and allow traffic through the firewall for the port number that MySQL is listening to  I prefer a slightly different solution involving SSH Tunnelling  The following command will set up an SSH tunnel which will forward all requests made to port 3307 from your local machine to port 3306 on the remote machine  ssh -NL 3307 localhost 3306 root REMOTE HOST  When prompted  you should enter the password for the root user on the remote machine  This will open the tunnel  If you want to run this in the background  you ll need to add the -f argument  and set up Passwordless SSH between your local machine and the remote machine  After you ve got the SSH tunnel working  you can add the remote server to the servers list in your local phpMyAdmin by modifying the  etc phpmyadmin config inc php file  Add the following to the end of the file   cfg  Servers    i   verbose            Remote Server 1      Change this to whatever you like   cfg  Servers    i   host               127 0 0 1    cfg  Servers    i   port               3307    cfg  Servers    i   connect type       tcp    cfg  Servers    i   extension          mysqli    cfg  Servers    i   compress          FALSE   cfg  Servers    i   auth type          cookie    i     I wrote a more in-depth blog post about exactly this  in case you need additional help

User · Answer

Follow this blog post  You can do it very easily   https   wadsashika wordpress com 2015 01 06 manage-remote-mysql-database-locally-using-phpmyadmin   The file config inc php contains the configuration settings for your phpMyAdmin installation  It uses an array to store sets of config options for every server it can connect to and by default there is only one  your own machine  or localhost  In order to connect to another server  you would have to add another set of config options to the config array  You have to edit this configuration file   First open config inc php file held in phpMyAdmin folder  In wamp server  you can find it in wamp apps phpmyadmin folder  Then add following part to that file    i     cfg  Servers    i   host               hostname Ip Adress    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     Let   s see what is the meaning of this variables    i    - Incrementing variable for each server  cfg    Servers      i     host      - Server host name or IP adress  cfg    Servers      i     port      - MySQL port  Leave a blank for default port  Default MySQL port is 3306   cfg    Servers      i     socket      - Path to the socket  Leave a blank for default socket   cfg    Servers      i     connect type      - How to connect to MySQL server     tcp    or    socket      cfg    Servers      i     extension      - php MySQL extension to use     mysql    or    msqli      cfg    Servers      i     compress      - Use compressed protocol for the MySQL connection  requires PHP  gt   4 3 0   cfg    Servers      i     auth type      - Method of Authentication  cfg    Servers      i     username      - Username to the MySQL database in remote server  cfg    Servers      i     password      - Password to the MySQL database int he remote server   After adding this configuration part  restart you server and now your phpMyAdmin home page will change and it will show a field to select the server    Now you can select you server and access your remote database by entering username and password for that database

User · Answer

As stated in answer c hill answer  if you want a secure solution I would advise to open an SSH tunnel to your server   Here is the way to do it for Windows users    Download Plink and Putty from the Putty website and place the files in the folder of your choice  In my example C  Putty  Open the Windows console and cd to Plink folder  cd C  Putty Open the SSH tunnel and redirect to the port 3307   plink -L 3307 localhost 3306 username server ip -i path to your private key ppk   Where    3307 is the local port you want to redirect to localhost is the address of the MySQL DB on the remote server  localhost by default  3306 is the port use for PhpMyAdmin on the remote server  3306 by default    Finally you can setup PhpMyAdmin    Add the remote server to your local PhpMyAdmin configuration by adding the following line at the end of config inc php   Lines to add    i        cfg  Servers    i   verbose               Remote Dev server    cfg  Servers    i   host                  localhost    cfg  Servers    i   port                  3307    cfg  Servers    i   connect type          tcp    cfg  Servers    i   extension             mysqli    cfg  Servers    i   compress             FALSE   cfg  Servers    i   auth type             cookie      You should be able to connect now at http   127 0 0 1 phpmyadmin   If you do not want to open the console each time you need to connect to your remote server  just create a batch file  by saving the 2 command lines in a  bat file

User · Answer

You can set in the  config inc php file of your phpMyAdmin installation    cfg  Servers    i   host

User · Answer

It can be done  but you need to change the phpMyAdmin configuration  read this post  http   www danielmois com article Manage remote databases from localhost with phpMyAdmin  If for any reason the link dies  you can use the following steps    Find phpMyAdmin s configuration file  called config inc php Find the  cfg  Servers    i   host   variable  and set it to the IP or hostname of your remote server Find the  cfg  Servers    i   port   variable  and set it to the remote mysql port  Usually this is 3306 Find the  cfg  Servers    i   user   and  cfg  Servers    i   password   variables and set these to your username and password for the remote server   Without proper server configuration  the connection may be slower than a local connection for example  it s would probably be slightly faster to use IP addresses instead of host names to avoid the server having to look up the IP address from the hostname    In addition  remember that your remote database s username and password is stored in plain text when you connect like this  so you should take steps to ensure that no one can access this config file  Alternatively  you can leave the username and password variables empty to be prompted to enter them each time you log in  which is a lot more secure

User · Answer

Method 1   for multiserver    First   lets make a backup of original config   sudo cp  etc phpmyadmin config inc php            Now in  usr share doc phpmyadmin examples  you will see a file config manyhosts inc php  Just copy in to  etc phpmyadmin  using command bellow   sudo cp  usr share doc phpmyadmin examples config manyhosts inc php            etc phpmyadmin config inc php   Edit the config inc php  sudo nano  etc phpmyadmin config inc php    Search for     hosts   array        foo example com        bar example com        baz example com        quux example com        And add your ip or hostname array save   in nano CTRL X press Y   and exit   Done  Method 2   single server   Edit the config inc php   sudo nano  etc phpmyadmin config inc php    Search for       Server parameters    if  empty  dbserver    dbserver    localhost    cfg  Servers    i   host      dbserver   if   empty  dbport      dbserver     localhost          cfg  Servers    i   connect type      tcp        cfg  Servers    i   port      dbport      And replace with    cfg  Servers    i   host      192 168 1 100    cfg  Servers    i   port      3306     Remeber to replace 192 168 1 100  with your own mysql ip server   Sorry for my bad English   google translate have the blame  D

[mysql] How to access remote server with local phpMyAdmin client?

Examples related to mysql

Examples related to phpmyadmin