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.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st February 2006, 14:31
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default Cant connect to MYSQL database from Dreamweaver

Hi.

I have a Breezy Badger ISPConfig runnig all ok, im trying to connect to a database from Dreamweaver MX2004, but i cant, i use the following settings in connection:

Connetion:Test
MySQL server: www.xxx.com
User: Web9_u4 or root
Password: mypass
Database: Web9_db4
I allways get an "2013 Lost Connection to MYSQL server during query" error.
Can you help me to fix this problem pls.

Hector

PD i´ve set remote access in ISPConfig to yes for this database.
Reply With Quote
Sponsored Links
  #2  
Old 1st February 2006, 15:53
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

Hi.

Me again...i tryied to connect from the odbc connector and got same results.....pls help me

Hector

PD [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'xxx.com' (10061)

Last edited by toyito; 1st February 2006 at 15:55.
Reply With Quote
  #3  
Old 1st February 2006, 16:36
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,821
Thanks: 821
Thanked 5,340 Times in 4,189 Posts
Default

Is mySQL listening on all IP addresses? Please post the output of:

netstat -tap
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 1st February 2006, 16:40
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

Hi Till

Output of netstat -tap

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:mysql *:* LISTEN 6290/mysqld
tcp 0 0 *:81 *:* LISTEN 6488/ispconfig_http
tcp 0 0 server1.example.:domain *:* LISTEN 15368/named
tcp 0 0 localhost.locald:domain *:* LISTEN 15368/named
tcp 0 0 *:ftp *:* LISTEN 4855/proftpd: (acce
tcp 0 0 localhost.localdoma:953 *:* LISTEN 15368/named
tcp 0 0 *:smtp *:* LISTEN 4938/master
tcp6 0 0 *:imaps *:* LISTEN 6200/couriertcpd
tcp6 0 0 *op3s *:* LISTEN 6235/couriertcpd
tcp6 0 0 *op3 *:* LISTEN 6215/couriertcpd
tcp6 0 0 *:imap2 *:* LISTEN 6180/couriertcpd
tcp6 0 0 *:www *:* LISTEN 12109/apache2
tcp6 0 0 *:ssh *:* LISTEN 6428/sshd
tcp6 0 0 ip6-localhost:953 *:* LISTEN 15368/named
tcp6 0 0 *:https *:* LISTEN 12109/apache2
tcp6 0 1796 server1.example.com:ssh ::ffff:10.22.0.172:4845 ESTABLISHED15607/0
Reply With Quote
  #5  
Old 1st February 2006, 16:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by toyito
tcp 0 0 localhost.localdo:mysql *:* LISTEN 6290/mysqld
MySQL is listening only on 127.0.0.1.
Please comment out the line
Code:
bind-address            = 127.0.0.1
in /etc/mysql/my.cnf and restart MySQL.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 1st February 2006, 16:52
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
 
Default


Thank you....thanks a lot

Hector
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
Client Website MySQL Database Names Lister Installation/Configuration 4 12th January 2008 17:21
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
Limit mysql database size ddelbia Feature Requests 14 25th April 2006 21:42
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Failed at MySQL lhatle Installation/Configuration 4 29th November 2005 01:26


All times are GMT +2. The time now is 10:12.


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