How do I grant someone access to only ONE mysql database, via phpmyadmin on a cpanel box? What would the login be (format)? A particular domain has 5 mysql databases, so do not want to give the tech regular cpanel access.
View 9 RepliesI've just purchased a second server of which I wish to use a database server for a number of my databases and I'd like manage it remotely (from the web server) via phpmyadmin.
I've configured my firewall and granted access to the web server on root@webserverip and also username@webserverip (username being just one of the database accounts I wish to grant access in order to test this). Accessing mysql remotely from the webserver now works on both accounts (via ssh and php).
However, having configured the phpmyadmin config file to include the ip (network ip) of the 2nd server I am unable to see the 2nd server when logged in to phpmyadmin. I just have the usual root@localhost and username@localhost.
Many, many people seem to be having the 2002 error over the past 24 hours on phpmyadmin with cpanel
Doing this edit to the config got it going for me:
[url]
Is the same type of file created through cPanel, going into backup then downloading the database backup as going through cPanel/phpmyadmin to export then saving the file as gzipped?
View 3 Replies View Relatedwe have a important problem with our cPanel for all of our cuestomers. The access to these services are broken. We cannot access to 3thdparty software like these: Webmail and phpmyadmin.
When we go access to our webmail service, example (Horde) take this error:
Quote:
Warning: include_once(Log.php): failed to open stream: No such file or directory in /usr/local/cpanel/base/horde/lib/Horde.php on line 3 Warning: include_once(): Failed opening 'Log.php' for inclusion (include_path='/usr/local/cpanel/base/horde/lib:.:/usr/lib/php') in /usr/local/cpanel/base/horde/lib/Horde.php on line 3
When we go access to our phpmyadmin servce take this error:
Quote:
Warning: require_once(./libraries/common.lib.php): failed to open stream: No such file or directory in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 36 Fatal error: require_once(): Failed opening required './libraries/common.lib.php' (include_path='.:/usr/lib/php') in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 36
These problem comming after the last cPanel upgrade.
I've noticed our cpanel still uses phpmyadmin 2.9.0.2 but there is a serious xss issue in versions up to 2.10.0
How can I install the new 2.10.1 around cpanel without it being overwritten?
[url]
How can I give somebody phpMyAdmin access to a specific database, without giving them the cPanel login for that account?
View 8 Replies View Relatedi downloaded a copy of phpmyadmin and uploaded it to my hosting.. then i run mydomain.com/phpmyadmin/setup configured the server to my hosting IP address but it says i can't login using myusername@localhost do i need to do something on a cpanel mysql server to listen to the external phpmyadmin?
View 1 Replies View Related