How to access remote server with local phpMyAdmin client?

by

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/

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. If two columns are 1 then make new column
  3. How to display UTF-8 characters in phpMyAdmin?
  4. #1071 – Specified key was too long; max key length is 1000 bytes
  5. MySQL : isn’t in GROUP BY
  6. MySQL: Can’t create table (errno: 150)
  7. Restore table structure from frm and ibd files
  8. Subqueries with EXISTS vs IN – MySQL
  9. phpMyAdmin on MySQL 8.0 [duplicate]
  10. Find and Replace text in the entire table using a MySQL query
  11. Setting up foreign keys in phpMyAdmin?
  12. Is there a simple way to convert MySQL data into Title Case?
  13. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  14. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  15. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  16. How to Import Multiple csv files into a MySQL Database
  17. Composite key as foreign key (sql)
  18. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  19. Can’t import database through phpmyadmin file size too large
  20. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  21. Access denied after setting user’s password with SHA256 in phpMyAdmin
  22. where does MySQL store database files?
  23. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  24. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  25. How do I write an SP in phpMyAdmin (MySQL)?
  26. How to import large sql file in phpmyadmin
  27. Import CSV to Update rows in table
  28. How to get back Lost phpMyAdmin Password, XAMPP
  29. UTF8 problem with MySQL 5
  30. mySQL query to search all tables within a database for a string?

Leave a Comment