mysql error

Anon

I'm new to PHP and MySQL so be nice. 😉 I tried installing phpMyAdmin on my shared hosting facility. It threw me the errors below when I tried to add a new table in my db. The error appears on the Records column on the right hand side of phpMyAdmin. Could anyone elaborate on the error? Thanks a ton!

Warning: Supplied argument is not a valid MySQL result resource in /usr/home0/mydea2/virtual_html/phpMyAdmin/libraries/common.lib.php on line 790

Warning: Supplied argument is not a valid MySQL result resource in /usr/home0/mydea2/virtual_html/phpMyAdmin/libraries/common.lib.php on line 791

van__

Sounds like you don't have table creation privelidges.

I assume you don't see a database called 'mysql' sitting on that right-hand column... so you'll have to contact your host and let them know you need full user priviledges for your database.

van__

I was wrong, I decided to tes this, since I fig'd after thinking about it a bit more that you should've gotten a mysql error saying 'no authorization' if you didn't have those priviledges,
so I tested and got this...

Database dummy - table test
Error
SQL-query:

CREATE TABLE test (id TINYINT not null , row TINYINT not null )
MySQL said: Access denied for user: 'test@localhost' to database 'dummy'

Sounds like something else going on.
More info would be good.
How did you try to create the table etc...