Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 23rd August 2006, 17:24
dedibox dedibox is offline
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:

I still get "Can't connect to MySQL server".

From the mysql server localhost, I get:

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 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!

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


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 17:05
configuring IPTABLES firewall adityavpratap HOWTO-Related Questions 9 27th May 2006 22:42
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 19:26
Remote access to ispconfig failure: fedora core 4 (64 bit) dchowdhu Installation/Configuration 6 27th January 2006 11:42
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04

All times are GMT +2. The time now is 04:20.

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