View previous topic :: View next topic |
Author |
Message |
christineee
Joined: 08 Nov 2004 Posts: 12
|
Posted: Mon Nov 08, 2004 2:20 am Post subject: b2function ERROR?!? pleeease help |
|
|
this is the second time i have installed b2 using scripta for my hostee and it said that after about 2 weeks. it happened on my b2 as well, but only once.
Code: | Warning: mysql_connect(): Access denied for user: 'chrissy_blog2@localhost' (Using password: YES) in /home/chrissy/public_html/b2julia/b2-include/b2functions.php on line 37
Can't connect to the database server. MySQL said:
Access denied for user: 'chrissy_blog2@localhost' (Using password: YES) |
when I check line 37 in b2functions it says this
Code: |
$connexion = mysql_connect($server,$loginsql,$passsql) or die("Can't connect to the database server. MySQL said:<br />".mysql_error());
$connexionbase = mysql_select_db("$base") or die("Can't connect to the database $base. MySQL said:<br />".mysql_error()); |
pleeease tell me why this is happening and how I can fix it. thanks so much:)  |
|
Back to top |
|
 |
Cyberian75
Joined: 26 Sep 2002 Posts: 1283 Location: Oregon
|
Posted: Mon Nov 08, 2004 2:44 am Post subject: |
|
|
It has nothing to do with b2functions. Make sure you typed in your username and password, as well as the database name, correctly in the "b2config" file. _________________ Michael P.
 |
|
Back to top |
|
 |
christineee
Joined: 08 Nov 2004 Posts: 12
|
Posted: Mon Nov 08, 2004 3:11 am Post subject: |
|
|
I changed it and the error is still there. Do I change it to the login and password used to sign INTO b2 to blog. or the actual database name, because I've tried both and nothing works.
This is what I changed......
Code: |
// ** MySQL settings **
# fill with your database details
$dbname = 'chrissy_blog2';
$dbhost = 'localhost';
$dbusername = 'chrissy_blog2';
$dbpassword = 'password';
# database tables' names (change them if you want to have multiple b2's in a single database)
$tableposts = 'b2posts';
$tableusers = 'b2users';
$tablesettings = 'b2settings';
$tablecategories = 'b2categories';
$tablecomments = 'b2comments'; |
|
|
Back to top |
|
 |
Cyberian75
Joined: 26 Sep 2002 Posts: 1283 Location: Oregon
|
Posted: Mon Nov 08, 2004 3:15 am Post subject: |
|
|
You did set up a database via your CPanel, right??? Have you assigned your username to that database? _________________ Michael P.
 |
|
Back to top |
|
 |
christineee
Joined: 08 Nov 2004 Posts: 12
|
Posted: Mon Nov 08, 2004 3:34 am Post subject: |
|
|
yes i setup a db through cpanel.
the thing is, i set up MY b2 using scripta and it WAS working, and i set up my hostees using scripta. it worked for a while, then just stopped. i set up a db through cpanel and it didnt work, so i tried again and still nothing.
doesnt scripta automatically setup a db when u install b2? if not, then why will it work for a few weeks, then this error shows up? |
|
Back to top |
|
 |
Cyberian75
Joined: 26 Sep 2002 Posts: 1283 Location: Oregon
|
Posted: Mon Nov 08, 2004 4:37 am Post subject: |
|
|
I don't know what "scripta" is. Ask your host for assistance. _________________ Michael P.
 |
|
Back to top |
|
 |
christineee
Joined: 08 Nov 2004 Posts: 12
|
Posted: Mon Nov 08, 2004 5:33 am Post subject: |
|
|
ahh whatever, scripta is like fantastico, except it installs scripts automatically, so i didnt need to create a new database at all. i just deleted it, and re-installed it, so its fine now.
although i do still want to know what the problem was. because this is the third time i've had to re-install b2. so i KNOW its going to happen again, i need to prevent it. |
|
Back to top |
|
 |
jenica
Joined: 06 Jan 2005 Posts: 2
|
Posted: Thu Jan 06, 2005 9:24 pm Post subject: |
|
|
same thing happened to me. i had to put in the name of my localhost. it worked after that. |
|
Back to top |
|
 |
|