SQLyog 3.03 password dialogue

[doug rice]

I have just downloaded SQL3.03.

When I log into my data base, the password sent is YES, if the dialogue box has a password entered and NO if the password is blank.

I found this when I spent my username wrong and was informed of the password used.

I logged in using version 1.71, and it worked.

Many thanks, Keep up the excellent work.

Doug Rice

[CalEvans]

I believe you are misinterpreting the messages. When MYSQL fails a login it says something like:

Using password YES or Using password NO. This simply indicates whether you used a password or not. it does not, has never and should never actually show you the password used in the case of a failure.

=C=

[doug rice]

Cal,

Thanks. Maybe I am jumping to conclusions. Oracle would not return any data if the password was wrong.

ver 1.7.1 lets me see my data, ver 3.03 does not. I get a blank database.

I am logging onto my webhoster and I can see the names of other people's databases, but not their contents.

I better check my log in again,

Cheers and thanks,

Doug

[doug rice]

Cal,

Thanks. I have logged on. If I change my password I get the error.

phpinfo(); reports:

mysql

MySQL Support enabled

Active Persistent Links 4

Active Links 4

Client API version 3.23.32

MYSQL_MODULE_TYPE builtin

MYSQL_SOCKET /tmp/mysql.sock

MYSQL_INCLUDE

MYSQL_LIBS

I can see my tables when I type the SQL:

show tables from dougrice_pn;

Doing anything else I get a dialogue box:

Error No. 1064

You have an error in your SQL syntax near dougrice_pn at line 1

If I type the SQL:

show table status from dougrice_pn;

I get:

Error Code : 1064

You have an error in your SQL syntax near 'table status from dougrice_pn' at line 1

(23 ms taken)

I think I need to petition my webhoster to upgrade MySql.

Doug

[doug rice]

I have loaded MySQL 3.23.32 on my PC.

SQLyog 3.03 works just fine on the test database.

I will plod on!

Thanks

Doug

[Author]

Posts