#1  
Old 23rd August 2006, 16: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 18:25.
Reply With Quote
Sponsored Links
  #2  
Old 24th August 2006, 09:59
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,754
Thanks: 821
Thanked 5,331 Times in 4,183 Posts
Default

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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 24th August 2006, 10:32
dedibox dedibox is offline
Member
 
Join Date: Aug 2006
Posts: 42
Thanks: 1
Thanked 0 Times in 0 Posts
Smile 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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR: The PHP binary coming with ISPConfig does not work properly on your system! qvindesland Installation/Configuration 22 21st May 2007 16:05
configuring IPTABLES firewall adityavpratap HOWTO-Related Questions 9 27th May 2006 21:42
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 18:26
Remote access to ispconfig failure: fedora core 4 (64 bit) dchowdhu Installation/Configuration 6 27th January 2006 10:42
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 17:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.