View Single Post
  #1  
Old 23rd August 2006, 17:24
dedibox dedibox is offline
Member
 
Join Date: Aug 2006
Posts: 42
Thanks: 1
Thanked 0 Times in 0 Posts
Unhappy 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:

Code:
GRANT ALL PRIVILEGES ON *.* TO web6_u5@[IP] IDENTIFIED BY "PASSWORD";
I still get "Can't connect to MySQL server".

From the mysql server localhost, I get:

Code:
dz:/var/log/httpd# mysql -u web6_u5@remoteip -p         
Enter password: 
ERROR 1045 (28000): Access denied for user 'web6_u5@82.236.8'@'localhost' (using password: YES)
I used netstat -tap which showed me that MySQL is listening only on 127.0.0.1 and not on all interfaces, so I commented out bind-address in my.cnf

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!

Code:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php:77) in /home/admispconfig/ispconfig/web/login/login.php on line 60

Last edited by dedibox; 23rd August 2006 at 19:25.
Reply With Quote
Sponsored Links