boardom

[michel v]

Many issues that our users encounter deal with MySQL, and how to set it up.

The point of this post is not to explain you how to create a MySQL db, or how to administer it. Ask these questions to your host.

The point is to give you a checklist of things that you should do, BEFORE asking for support in this forum.


1. Create a MySQL database. If you already have a MySQL database, you can skip this step. Note: you can use several instances of b2 in the same database if you wish.
2. Create a MySQL user; or use one that is already created.
3. Add the user to this database.

Most 'errors' occur because you forget one of these steps, especially the last one; so here you know what you got to do

[Birdangel]

I read the readme.html file, but I didn't see anything about what to do if you already have a b2 blog on your server and you want to set up another one. Do I need to change the names of all the tables to different ones?

[macshack]

hi,

[FantasyAngel]

...how do we create a database? LoL I know its a stupid question but when it comes to computers IM DUMB!
_________________
FantasyAngel

[nessahead]

[theinfamousj]

If you use dreamhost and are still having these issues you need to GIVE IT A WHILE TO PROCESS. The creation of the MySQL database, username, and host are not instantaneous.

I don't know about other webhosts but I gave mine 2 hours to sit and it was golden.

Just a tip.
_________________
--...dot every i and cross every t.--

[kraylus]

hehe, i use dreamhost!

didnt take mine quite two hours... more like 15 min. it works great though! i recommend anyone to dreamhost.

[rubie]

When I go to b2install.php I get this error:

Warning: Access denied for user: 'user@localhost' (Using password: YES) in /home/sites/kiwi-sweets.net/b2install.php on line 17

Warning: MySQL Connection Failed: Access denied for user: 'user@localhost' (Using password: YES) in /home/sites/kiwi-sweets.net/b2install.php on line 17
Can't connect to the database
Access denied for user: 'user@localhost' (Using password: YES)

I don't know if this makes a diffrence, but I just Active Webhosting. What is wrong?

[mikelittle]

Make sure you set the correct values in b2config.php

[rubie]

I have this error:

Parse error: parse error in /home/sites/kiwi-sweets.net/b2config.php on line 36

Warning: Access denied for user: 'sites@localhost' (Using password: NO) in /home/sites/kiwi-sweets.net/b2install.php on line 17

Warning: MySQL Connection Failed: Access denied for user: 'sites@localhost' (Using password: NO) in /home/sites/kiwi-sweets.net/b2install.php on line 17
Can't connect to the database
Access denied for user: 'sites@localhost' (Using password: NO)

What is wrong?

[Candle]

Wrong passwd or wrong users name or both .
Check to make sure if have both right .

[macshack]

Hi,

look very carefully at line 35 and 36 of b2config.php. most likely a missing ';' or one too many or too few " ' ".

And as Candle said, while your there, make sure the user (mysql user) and password are correct. But with the parse error as described, PHP will stop parsing at that point and not see any of the rest of this file. It will try to use the other files and when it comes time to do the database query, guess what, the database user and password were not set because of the parse error, and bingo, your complaint about the user being incorrect....

regards,
michael e

[fallenn]

I have this

[macshack]

Hi,

First, did the db get created and is the db name 'fairy_fallen' and the MYSQL user 'fairy_fallen'.

michael e

[fallenn]

yes, thats what my host told me it was.