This is my first time setting up a MySQL database, and I'm a little unsure of some of the parameters listed in the Zenphoto setup. I'm getting an error: "MySQL reported: Access denied...", but I suspect i haven't filled in the information correctly.
I had previously created a MySQL database through my host control panel. My username is "norrzfrf", so when I titled it "gallery" it created a database called "norrzfrf_gallery", and created a username and password.
In the Zenphoto installer script, it comes up with a number of parameters, here's the settings I used:
Database engine: MySQL
Database admin user: pbowers
Database admin password: *******
Database host: localhost
Database name: norrzfrf_gallery
Database table prefix: gallery_
Okay, I have absolutely NO IDEA what the table prefix is and what it should be set to, so I put in "gallery_" but I don't know what that will do. For the database name, should it include my host username like that or just be called "gallery"? I tried both, but neither worked. I left "Database host" as "localhost", but should I change that to the domain or IP?
Anyone who can help me get this figured out gets a cookie!
Zenphoto
Comments
Also try another database engine like PDO or MysqlI. "Mysql" is deprecated. Your host should be able to tell you waht it supports as well.
The database prefix is just to, well, prefix the database tables created as multiple Zenphoto installations (or other CMS) can share one databse. It is what you set it to. And it is not required.