LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 09-26-2008, 06:44 PM   #1
wendle
LQ Newbie
 
Registered: Feb 2008
Posts: 8

Rep: Reputation: 0
MySQL connection problem


I am trying to connect and administrate a mysql database through various programs (mySQL administrator, emma, mySQL navigator) but i keep having this message
"Could not connect to host "host name".
MySQL Error Nr. 1045
Access denied for user 'username@'vfppp079167045089.dsl.hol.gr' (using password: YES)

Click the 'Ping' button to see if there is a networking problem.


Now if I ping, the server is responding. By the way the port is 3306 but I' ve tried some other ports without any luck.
Could anybody help in any way. Thanks
 
Old 09-26-2008, 07:04 PM   #2
elprawn
Member
 
Registered: Feb 2005
Distribution: Gentoo 2008
Posts: 138

Rep: Reputation: 15
Have you set up port forwarding?
 
Old 09-26-2008, 07:09 PM   #3
wendle
LQ Newbie
 
Registered: Feb 2008
Posts: 8

Original Poster
Rep: Reputation: 0
Port forwarding in the wireless router you mean?
 
Old 09-27-2008, 03:55 AM   #4
elprawn
Member
 
Registered: Feb 2005
Distribution: Gentoo 2008
Posts: 138

Rep: Reputation: 15
Yeah, if you're trying to access outside the router then you have to forward port 3306.
 
Old 09-27-2008, 05:44 AM   #5
wendle
LQ Newbie
 
Registered: Feb 2008
Posts: 8

Original Poster
Rep: Reputation: 0
Ok. I get it. BUT my stupid router hasn't got a port forwarding function. It only has a "FIREWALL RULES" with some predefined values (nothing about port 3306). The closest is the SQL-NET(TCP:1521) and another witch says ANY/ALL(TCP/UDP:1-65535). I checked the "allow" button next to them but still no luck!!!
 
Old 09-27-2008, 06:30 AM   #6
elprawn
Member
 
Registered: Feb 2005
Distribution: Gentoo 2008
Posts: 138

Rep: Reputation: 15
Which router do you have?
 
Old 09-27-2008, 10:45 AM   #7
wendle
LQ Newbie
 
Registered: Feb 2008
Posts: 8

Original Poster
Rep: Reputation: 0
Level1 Wbr-3460a
 
Old 09-27-2008, 11:48 AM   #8
elprawn
Member
 
Registered: Feb 2005
Distribution: Gentoo 2008
Posts: 138

Rep: Reputation: 15
Is there no way of setting custom rules or do you have to choose from the list?
 
Old 09-28-2008, 10:55 AM   #9
wendle
LQ Newbie
 
Registered: Feb 2008
Posts: 8

Original Poster
Rep: Reputation: 0
It has only some predefined values (nothing about port 3306). the closest that i can find is: ANY/ALL(TCP/UDP:1-65535).this is already turned on but still no luck
 
Old 09-28-2008, 11:08 AM   #10
elprawn
Member
 
Registered: Feb 2005
Distribution: Gentoo 2008
Posts: 138

Rep: Reputation: 15
Is that a rule for port blocking/allowing or port forwarding? i.e. does it ask you for a local address? Have you tried plugging your MYSQL server straight into the Internet rather than going through your router? (this way you could eliminate other possibilities).
 
Old 09-28-2008, 08:45 PM   #11
jgallo
Member
 
Registered: Sep 2008
Posts: 39

Rep: Reputation: 15
Look for a setting called NAT maybe.

You might want to look for another router if you cannot find these settings. Or check into if a third party firmware like OpenWRT or DD-WRT support your router.

Last edited by Tinkster; 10-30-2010 at 03:53 PM.
 
Old 09-30-2008, 02:36 AM   #12
osamaensyviswinkel
LQ Newbie
 
Registered: Sep 2007
Location: Stellenbosch, South Africa
Distribution: Ubuntu 12.10 at home, Mac OS X on laptop
Posts: 20

Rep: Reputation: 0
1. can you telnet to your box on 3306, firstly on localhost?

you should see something like this:

[09:59][root@server]/home # telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
4
5.0.37@/kP0:tYB,}o5X;]CwPg8

2. what kind of a router/router version have you got? Normally if you've got those default values, there's an option to setup custom firewall/port rules where you select the port number, you name it whatever you like etc.
 
  


Reply

Tags
sql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Connection Problem rowancompsciguy Linux - Software 2 09-21-2006 01:53 AM
mysql connection problem I_AM Linux - General 2 10-27-2005 10:02 PM
MySQL/Java connection problem hudy Programming 3 06-23-2004 08:40 PM
php / mysql connection problem . MikeFoo1 Programming 3 05-02-2004 05:22 PM
mysql connection problem ckamheng Linux - Software 1 05-31-2003 01:30 AM


All times are GMT -5. The time now is 12:08 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration