[chr]

OK…here's the deal (at least for my case).

I'm able to connect manually using 'mysql' because I have the necessary grants. The same applies to SQLyog, which actually connects but then issues a 'SHOW DATABASES' instruction which succeeds only if the user has the necessary 'SHOW DATABASES' grants. And here's where it gets nasty (takes from the MySQL help file):

Code:

The privileges CREATE TEMPORARY TABLES, EXECUTE, LOCK TABLES, REPLICATION …, SHOW DATABASES and SUPER are new for in version 4.0.2. To use these new privileges after upgrading to 4.0.2, you have to run the mysql_fix_privilege_tables script.

In older MySQL versions, the PROCESS privilege gives the same rights as the new SUPER privilege.

The bottomline is:

* if the DB you are trying to connect to has version 4.0.2 (or greater) the you need to ask you DBA to give you the needed grants (GRANT SHOW DATABASES ON .* TO – or something like that)

* if the DB is older then you are either stuck or your DBA must be willing to grant you PROCESS privileges (I still don't know what that implies in terms of security – need to finish reading the docs)

Or alternatively, SQLyog could be changed so that it does not issue a SHOW DATABASES command upon connection in case a default database is supplied by the user. Just kidding. 😆

Hope this helps. Thanks guys.

CHR

[chr]

I thought about this too but, as I stated in my earlier post, if I connect manually (as user 'foo') using the 'mysql' shell command and issue a 'status' request I can see that that the remote db server returns '[email protected]' as the current user. Therefore it looks like this kind of *variable* ISP domain doesn't affect the ability to connect manually.

I was going to try and log all network request made by SQLyog when attempting connection in order to find more clues but I suppose that Ritesh and his team are already looking into this.

Will post any progress.

CHR

[chr]

Hi everybody.

I know this issue has already been brought up several time but unfortunately all proposed explanations (probably) don't apply to my case.

The fact is that I'm able to connect manually using the following command

mysql -h mysql.server.it -P 3306 -u foo -p12345

but when I try to connect with SQLyog I get the aforementioned error.

Here's what is returned by the remote mysql server:

mysql> status

---

mysql Ver 11.18 Distrib 3.23.55, for Win95/Win98 (i32)

Connection id: 186134

Current database:

Current user: [email protected]

Server version: 3.23.51-log

Protocol version: 10

Connection: mysql.server.it via TCP/IP

Client characterset: latin1

Server characterset: latin1

TCP port: 3306

Uptime: 27 days 22 hours 52 min 0 sec

---

and here's what is inside my local SQLyog.ini file:

[Connection 1]

Name=test

Host=mysql.server.it

User=foo

Password=12345

Database=

Port=3306

SSL=0

Compress=0

Before I drive myself nuts on this can anybody help out? java script:emoticon(':eek:')

smilie

I would really appreciate that.

CHR

[Author]

Posts