Home› General support

mySQL user rights error, no tables created

skinner927 Member
in General support
Here's my error message:

`Your MySQL user must have Create, Drop, Select, Insert, Alter, Update, and Delete rights.

The SHOW GRANTS query failed.`

every single post I've read says to just continue and it's no biggie, but the tables are never created in my DB. I've tried two different dbs on two different db servers.

if I click "go"

I get this error:
`MySQL Query ( SELECT * FROM `zenp_albums` ) Failed. Error:Table 'db191889380.zenp_albums' doesn't exist

It looks like your zenphoto tables haven't been created.You may need to run the setup script.`

anyone know what to do? lol

Comments

  • sbillard Member
    Well, the posts should have said that this message was a warning. Since the query failed zenphoto does not know what MySQL rights it has. It still needs those rights stated. Apparently on your installation it does not have them and failed to create its tables.

    You need to insure that zenphoto has the MySQL rights it needs.
  • skinner927 Member
    it does, it logs in as an admin to my mySQL server. It doesn't make sense, I've never had this problem before. Unfortunately I've just given up on zen photo, although it looks like a great gallery I guess I just can't run it :/
Sign In or Register to comment.