Page 1 of 1
MySQL setup
Posted: Thu Feb 03, 2005 11:26 pm
by 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!
Posted: Fri Feb 04, 2005 12:25 am
by 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.
More problems
Posted: Fri Feb 04, 2005 1:01 am
by 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!
Posted: Fri Feb 04, 2005 1:14 am
by 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.
Still nothing
Posted: Fri Feb 04, 2005 1:29 am
by 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.
Posted: Fri Feb 04, 2005 1:49 am
by 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.
Something else
Posted: Fri Feb 04, 2005 1:58 am
by 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?
Posted: Fri Feb 04, 2005 2:11 am
by 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
Posted: Fri Feb 04, 2005 10:50 am
by 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
Thanks!
Posted: Fri Feb 04, 2005 5:09 pm
by 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!!!!