Can't connect

[NickM]

I apologize but I am completely new to this. We have a linux server and I wish to make a direct connection and explore the contents of the mysql tables. I am getting…

Error: 1045

Access denied for user: “nick@IPAddress” Using Password = YES

1. What are the permissions that have to be set up on the server to allow access? I am trying to connect on a LAN using port 3306.

2. Do the username and passwords refer to the Linux root account or mysql password?

Nick

[Ritesh]

Quote:

What are the permissions that have to be set up on the server to allow access? I am trying to connect on a LAN using port 3306.

MySQL uses user+host based authentication system. More information on the MySQL authentication system can be found at: http://dev.mysql.com/doc/mysql/en/privileg…ege-system.html

Quote:

Do the username and passwords refer to the Linux root account or mysql password?

MySQL uses its own account/username and has no relation to OS accounts.

[peterlaursen]

to get started with SQLyog:

host: IP

user: root

With SQLyog you can then create more users and modify existing.

But FIRST of all you must start MySQL command-line tool on the Linux box and give ROOT access to connect from remote machines (after install only connection from localhost is allowed). The wildcard character % used as a host lets you connect frm everywhere.

[b_harris]

Hi

I'm using newly purchased.. SQLYpg Enterprise 4.07 editions. Great….great tool!

I run into the Error 1045 when I have connected initially to a remote database and then connect to the localhost on my PC second.

Trying to perform a Structure Sync I received the following error…

Error No. 1045

Access denied for user: '[email protected]' (Using password: Yes)

To get around this I closed all connections, re-connected to local first and then remote second. It allowed Structure Sync tool to work perfectly but afterwards I could not execute the batch file from SqlYog…I had to cut and paste into the SQLYog's Query area and execute from there.

Also during this session SQLYog Database Sync tool failed with the same error when I attempted to select a database from the dropdown that was associated to localhost. So it appears that there are inconsistancies invoking authentication from different tools.

I don't understand why .localdomain is being attached to the user credentials for any localhost reference but that could be why that user id is being denied access.

BTW: this all occurred for SSH Tunneling connections. It works fine for HTTP Tunneling via the remote webservice php file.

Could some one respond with a possible workaround for this issue?

Your help is appreciated.

Bob

[peterlaursen]

Quote:

BTW: this all occurred for SSH Tunneling connections. It works fine for HTTP Tunneling via the remote webservice php file.

I am no expert in SSH (only installed my own SSH-server yesterday) but I guess that the SSH-user is configured as a “domain user” and not a “local user” with the SSH server.

Since you are allowed to be ROOT I guess that it is your own server and not the server at an ISP ?! You could explain a little more about this ?

How are ROOT privileges configured with MySQL ? Access from localhost only ?

[peterlaursen]

And BTW: the SSH-user you should use for connection IS NOT a MySQL-user but an OS-user registered with the SSH-server.

Also remember to use different local ports on your local machine for each individal SSH-connection.

My apology if that is trivial to you! 😉

[peterlaursen]

I think I understand better now! I believe I get some crazy results with Structure Sync tool as well (on MySQL 5.0.9 with VIEWS defined in some DB's) with SQLyog 4.07 and 4.1. I'll switch to MySQL 4.0.25 and try again ?!

What are your MySQL-versions ?

[peterlaursen]

I have tested with various MySQL versions and SQLyog 4.07 and latest 4.1 BETA and most all possible combinations of tunnelling options.

The only error I can reproduce (and that I can!) is that the STRUCT SYNC TOOL is not able to correctly “parse” a MySQL ver. 5 database having VIEWs defined with it. No problems with that DB and any other SQLyog functionality. No prob's on MySQL ver. 5 either with STRUCT SYNC TOOL when there are no VIEWS in DB!

I think that your problem could be a mismatch of various issues …

Quote:

I run into the Error 1045 when I have connected initially to a remote database and then connect to the localhost on my PC second.

You are sure you have tunnelling unchecked with the connection to localhost (guess you don't tunnel here, though that can be done too!)? Do you use the connection manager ?

[peterlaursen]

excuse me if you think, that I'm confused. If you think so I probably am! 😀

But

1) you can connect to your webhost using SSH. And everything works as it should as long as that connection is open with SQLyog only?

2) you can connect to localhost and everything works fine as long as there is no SSH-tunnelled connection open.

3) you also can connect to webhost using HTTP-tunnelling and to localhost and “dual connection functionality” with SQLyog works as it should ?

4) but errors occur with “dual connection functionality” when SSH-tunnelling to webhost and at the same time connecting to localhost ?

I got it right now ?

Connection settings are stored in the sqlyog.ini file. Could it possibly be damaged/inconsistent in some way? I propose you try make a fresh install (to another directory to get a fresh sqlyog.ini file) and recreate connections with connections manager and see if the problem persists?

And one last question: Is your localhost part of a domain-type LAN ?

[Author]

Posts