MySQL setup

[mahctagon]

Hi, I'm new here...

So I'm in the middle of setup, and I got to the admin page and apparently there is something wrong with my sql setup. I'm pretty new to all of this, and I'm guessing that I don't have the database in mySQL setup right...

This is the error I got:

- The database you specified does not exist.
The mySQL error was: Access denied for user: '@localhost' to database 'serendipity'

I haven't changed any of the default settings. Any input would be greatly appreciated. Thanks!

[ned]

Hi mahctagon,

You must enter your correct database name and password into the Serendipity interface. You can get these from your host provider.

You may have to create the database yourself. You can do this using your web control panel. You probably have a MySql icon in there somewhere. Then just enter the name of the database you created into Serendipity. Pay close attention because some host providers will append some kind of identifying prefix or suffix to your database name.

[mahctagon]

Thanks for the input. I created a new database and created a user for that database, but I'm getting this error now:

- Could not connect to database; check your settings.
The mySQL error was: Access denied for user: 'serendip@localhost' (Using password: YES)

I'm not sure what settings to check. I have the access for the user I created set at "all".

Any advice?

Thanks in advance!

[ned]

It looks like you are trying to access your new database with username "serendip"?

Make sure "Database user" in the Serendipity setup page matches the username you created.

[mahctagon]

Yes, the username is "serendip". Now, in the serendipity admin page, do I need to specify the username as just 'serendip' or do I need to add the prefix 'mahctag_serendip"?

Thanks for the help.

[ned]

Yes, that could be it. Some host providers will force a prefix. It will not hurt to try it. Your username, password and database name must match exactly to what the server expects.

[mahctagon]

Ned,


Thanks for your help with this. I finally got the sql issue figured out. Now I've got a new problem. Here's what happened:

Attemping to setup database...
Checking to see if the database is already in place. If you see a database query error here, ignore it... Done
Creating default database setup... Done
Done creating database
Attemping to write /home/mahctag/public_html/blog/serendipity/.htaccess file...Done

Fatal error: Call to a member function on a non-object in /home/mahctag/public_html/blog/serendipity/serendipity_plugin_api.php on line 79

Fatal error?

[ned]

You're welcome.

I'm afraid this new development is over my head. You'll have to wait for one of the higher beings. LOL

[garvinhicking]

mahctagon: The error you're getting refers to some plugin error.

Did you extract serendipity with all paths? Is the plugins/ directory in place with all its subdirectories?

And after installing, can you access your blog? If not, I will give you some debugging lines to get this sorted out

Regards,
Garvin

[Guest]

Hey...


Thanks for the hint. I checked the plugin folder and apparently when I uploaded it, all of the folders were not in place. I reloaded it and everything seems to be pretty ok.

THANKS!!!!