View Single Post
  #3  
Old 21st June 2013, 12:06
r_c_sekar r_c_sekar is offline
Junior Member
 
Join Date: Mar 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok, i did something like https://[SERVERNAME]/phpmyadmin and seems to work. But the server name has to be set with external domain name for each server that is being managed in the panel.

And when i created user from the main control panel, let us say i have webserver in db1.server.com. But i also created a DB user and DB on db2.server.com.

This statement has to be manually entered to enable the user to login to DB on db2.server.com from db1.server.com.

GRANT ALL PRIVILEGES ON `database-name` . * TO 'db-user'@'xx.xx.xx.xx';

This can be automated, because the panel knows the servers such as web, db and mail to a particular client.
Reply With Quote