[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

[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]

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

[Author]

Posts