MySQL Bugs: #11272: remote-Access

Bug #11272	remote-Access
Submitted:	12 Jun 2005 15:22	Modified:	29 Jun 2005 15:51
Reporter:	Jochen Seliger	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.22	OS:	Linux (SUSE 9.3)
Assigned to:		CPU Architecture:	Any

Description:
The Administrator is able to connect to the locally running Database via 'localhost'.
When setting the common IP-Adresse it failes.
Connection from an external (Windowws)-Maschine failes too.
But when connectin from the Linux-Box (192.168.100.97) to a Database on the Windows-Maschine (192.168.100.2) then the local instance is diplayed corrctly.

How to solve this problem ?

Kiind regards

Jochen Seliger

How to repeat:
mailto: jochen.seliger@flowcontrol.org

Hi! could you check if:
1) you can connect to linux server from mysql console client (not from GUI tool), 
   1.1.) to localhost?
   1.2) to ip address?
2)  server starts with --skip-networking option? 
3) output of 'netstat -an | grep 3306' shows that mysql listening port 3306?

Hi Aleksey,
thanks for your reply.
Concerning your questions following:
1. I can connect to the server, running on 192.168.100.97 (hostname linux.site ) using the '--host='option within the mysql console.
2. the variable 'skip_networking' for the server is set to 'OFF'
3. 'netstat -an | grep 3306' reports
   'tcp 0    0 0.0.0.0:3306       0.0.0.0:*'
3.a /etc/services contains the rows
  'mysql      3306/tcp  #MySQL'
  'mysql      3306/upd  #MySQL'

Additionally of interest could be that I cannot connect to the databes via the JDBC-connector as I could under SUSE9.1 before.
Secundary I can ping the server within the mysql-administrator  logon pannel in the case when connect via IP adresse fails.
Furthermore I have experienced trouble to set additional server with IP adress and when trying to assing priveliges to users.
In both cases there was displayed an error message concerning 'dublicate users'.
It seems not to be right.
Thous I cannot connect thru JDBC-connector I could immagine that there takes place an problem with X-authorizations.
I had an appropiate fproblem with JBuilder when running Kernel 2.6.11.
After uprading to kernel 2.6.11.4-21.7 that problenm disappeared.

Hope that this information can help yo to fix the problem.

Regads

Jochen

Hi!

I was unable to reproduce this bug.  Can you please make sure that mysql is running in port 3306 ?

If you use localhost, a socket will be used instead.