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

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 06:34.


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