partially connected – Could not refresh object …

[justken]

hello, i scanned the lists, and saw a few things similar to my concern, but they were often clouded in other problems so i thought i'd start a new thread.

When connecting to a remote host on a server that only allows a single connection to the database, SQLyog gives me a:

Code:

Error No. 1045
Access denied for user: '[email protected].' (Using password: YES)

however: i can click [ok] and i'm now connected to my server and the database as requested.

using

Code:

show tables; F5

i get my list of tables, and doing a

Code:

select * from table; F5

i get my data, but if this is all i can do, i don't see how the software can can simpilfy my life any.

refreshing the object browser gives me the above error, and there is no table or data view available for these databases.

i believe the error is that SQLyog performes a

Code:

show databases
————————-
Error Code : 1045
Access denied for user: '[email protected]' (Using password: YES)
(47 ms taken)

as it connects, even when a database is specified in the connection pannel. If a box could be added to the connection pannel which said

Quote:

[ ] connect to this database only

i believe that would solve the problem?

I have just recently installed SQLyog as a replacement(?) for the discontinued mySQL-Front (i can't tell you how terribly sad i am that it's discontinued.)

i upgraded from 3.1 to 3.5 in the hopes that this connection problem would be resolved, and also was looking for a data editor that was at least as intuitive as mySQL-Front.

ken

[Shadow]

No, that would not solve your problem. If you specify a db name in the connection dialog, then SQLyog will connect to that db only. MySql v3.x and 4.0.x do not restrict the 'SHOW DATABASES' command, therefore all dbs will be shown in case of a successful connection to the server regardless of the users access rights. MySql 4.1, however, will show those dbs only which the user has access to.

I think, you are not properly connected to the MySql server and this leads to the errors. Perhaps you should clarify with your provider what username and password you have. If you have a dial-up access (or your ISP assigns a different IP address to your computer each time you connect to the web) then ask for access to be granted to 'your_user_name@%'.

[Author]

Posts