US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > Troubleshooting


Closed Thread
 
Thread Tools
Old 11-22-2009, 12:28 PM   #1
Senior Member
 
Join Date: Nov 2009
Location: Germany
Posts: 117
sascha is on a distinguished road
Send a message via MSN to sascha
Default enable external mysql connection on :3306

hi,

i use ispmanager pro. how can i enable connections to mysql port 3306 to connect to the db with external programms?

thx
sascha
sascha is offline  
Old 11-22-2009, 01:19 PM   #2
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

You need enable "Allow remote access" checkbox in the database user properties.
slava is offline  
Old 11-27-2009, 06:18 PM   #3
Senior Member
 
Join Date: Nov 2009
Location: Germany
Posts: 117
sascha is on a distinguished road
Send a message via MSN to sascha
Default

ok, i´ve enabled it, but still


PORT STATE SERVICE
3306/tcp closed mysql

i've restart the server, but nothing changes

thx
sascha is offline  
Old 11-27-2009, 07:35 PM   #4
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

By default MySQL listen all this port. Possible firewall or internet provider blocked this.
What's show command
Code:
netstat -na | grep 3306
?
slava is offline  
Old 11-28-2009, 11:09 AM   #5
Senior Member
 
Join Date: Nov 2009
Location: Germany
Posts: 117
sascha is on a distinguished road
Send a message via MSN to sascha
Default

the firewall is off.

ispmanager:~# netstat -na | grep 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
sascha is offline  
Old 12-01-2009, 09:12 PM   #6
Senior Member
 
Join Date: Nov 2009
Location: Germany
Posts: 117
sascha is on a distinguished road
Send a message via MSN to sascha
Default

i am confused look this:

ispmanager:~# nmap localhost -p3306

Starting Nmap 4.62 ( http://nmap.org ) at 2009-12-01 19:45 CET
Interesting ports on localhost (127.0.0.1):
PORT STATE SERVICE
3306/tcp open mysql

********

ispmanager:~# nmap 80.XXX.XXX.XXX -p3306

Starting Nmap 4.62 ( http://nmap.org ) at 2009-12-01 19:45 CET
Interesting ports on dedicaXXXXXXXXXXXXXXXXX
PORT STATE SERVICE
3306/tcp closed mysql

both scans are from the server itself. when is use its server own ip, the port is closed, if i used loacalhost, everything is ok??

my firewall is of, and the provider has no firewall !

greets
sascha
sascha is offline  
Old 12-03-2009, 03:27 PM   #7
Senior Member
 
Join Date: Nov 2009
Location: Germany
Posts: 117
sascha is on a distinguished road
Send a message via MSN to sascha
Default

no idea? from anyone?
sascha is offline  
Old 12-14-2009, 07:22 AM   #8
Member
 
Join Date: Apr 2009
Posts: 52
tanya is on a distinguished road
Default

Hi,

You should delete the string "bind-address =" from the file /etc/my.cnf
tanya is offline  
Old 12-19-2009, 07:32 PM   #9
Senior Member
 
Join Date: Nov 2009
Location: Germany
Posts: 117
sascha is on a distinguished road
Send a message via MSN to sascha
Default thats it :)

thats it, thx
sascha is offline  
Closed Thread

Thread Tools

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


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