var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: cannot connect to MySQL server, otherthan via root user
I have MySQL 3.23 server installed on a Linux system.
My Java application is running on a Windows 2000 system.
I am connecting via the mmSQL 1.2a Type IV JDBC driver.
I can successfully connect to the server by specifying the root username and password.
However, when I try to connect to the server using any other username/password combination I receive the following error message:
Communication link failure: Bad handshake.
I have even added some users to the MySQL server that have superuser privileges set, but still can;t connect using their credentials.
Any ideas what may be causing this?
Are you sure that when you added your mysql user you give them the host used by your windows server ?
The syntax I use is as follows:
GRANT ALL ON MYDB.* TO user1 identified by "username1"
I read than ommitting the @ symbol after the username basically means 'allow this user to connect to this server from anywhere'.
Is this correct?
Anyway, when I do specify the host name of the Windows server i.e.
GRANT ALL ON MYDB.* TO user1@winserver identified by "username1"
and subsequently attempt to connect via mysql client I receive the message:
ERROR 1045: Access denied for user: 'user1@<windows IP address>' (Using password: YES)
you should use the ip instead of the windows name.
GRANT ALL ON <DB>.* TO <user>@<IP/hostname> IDENTIFIED BY <PASSWD>
You can replace IP/hostname by % to allow access from any IP