Can't Remote Access mysql 4.1
I'm using a stock installation of ISPConfig 2.2.1 upgraded to 2.2.6.
I also upgraded mysql to 4.1 using apt-get.
Even though I've check the "Remote Access" box for one of the mysql databases I've created, I can't access it from another IP.
PHPMyAdmin and mysql command line work fine.
I tried granting remote access to my IP from the mysql command line:
From the mysql server localhost, I get:
I checked the mysql hosts with phpMyAdmin, which says that web6_u5 has % and localhost as its hosts.
Still can't connect.
Worse, now that I've set a root password for mysql, I can no longer log into ISPConfig!
To repair the ISPConfig login problem, set your new root mysql password in the file /home/admispconfig/ispconfig/lib/config.inc.php
Please post the output of "netstat -tap" and your /etc/my.cnf file.
Did you restart mysql after you changed the my.cnf configuration?
mysql remote access and ispconfig password problems fixed
Thanks for your reply. I had to manually edit the host in mysql, flush privileges, and restart mysql. After all that, both remote access and iSPConfig work. Whew.
|All times are GMT +2. The time now is 09:26.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.