 |
boardom
b2 message board
|
| View previous topic :: View next topic |
| Author |
Message |
stevem
Joined: 15 Mar 2003
Posts: 257
|
 Posted: Tue Apr 13, 2004 11:01 pm Post subject: |
 |
|
I'm happy that all is well 
Searching the forum shows that quite a few people have had the same problems, so I am sure that your write-up will be very helpful in the future |
|
| Back to top |
|
 |
Flora
Joined: 13 Apr 2004
Posts: 4
|
| Posted: Wed Apr 14, 2004 2:25 am Post subject: |
|
|
| Flora wrote: | I got this when I tried to run b2install.php
| Quote: |
Parse error: parse error in /home/weirdro/public_html/sins/b2config.php on line 17
No Database Selected
|
and when I tried the testing script with the database, I got this
| Quote: |
Can't connect to the database . MySQL said:
Access denied for user: 'weirdro_flora@localhost' to database 'weirdro_sins'
|
Help please! |
Help? |
|
| Back to top |
|
|
Sigg3
Joined: 03 Jul 2003
Posts: 643
Location: Oslo, Norway
|
|
| Back to top |
|
|
Flora
Joined: 13 Apr 2004
Posts: 4
|
| Posted: Sat May 01, 2004 1:49 am Post subject: |
|
|
| Sigg3 wrote: | | First of all; is the db settings correct? |
So sorry for not responding... but yes, it's all correct. |
|
| Back to top |
|
|
Flora
Joined: 13 Apr 2004
Posts: 4
|
| Posted: Sat May 01, 2004 2:14 am Post subject: |
|
|
I just reinstalled b2 and I got a different problem now.
| Quote: |
Warning: mysql_connect(): Access denied for user: 'weirdro_flora@localhost' (Using password: YES) in /home/weirdro/public_html/sins/b2-include/b2functions.php on line 37
Can't connect to the database server. MySQL said:
Access denied for user: 'weirdro_flora@localhost' (Using password: YES)
|
Also, when I type in the script to test the datebase and I got this...
| Quote: |
Warning: mysql_connect(): Access denied for user: 'weirdro_flora@localhost' (Using password: YES) in /home/weirdro/public_html/sins/testdb.php on line 11
Can't connect to the database server. MySQL said:
Access denied for user: 'weirdro_flora@localhost' (Using password: YES)
|
Help again please?
I'll be online all night, my AIM sn is EvlGal1028 |
|
| Back to top |
|
|
shariya
Joined: 10 May 2004
Posts: 1
Location: tokyo
|
| Posted: Mon May 10, 2004 9:53 am Post subject: Erro3s on b2config.php + blog.header.php |
|
|
hello,
i had encountered 3 errors when i open index.php.
i just download this just 2 weeks ago.(10.May.2004)
here is the messages.
------
Parse error: parse error in /home/xxxx/public_html/b2config.php on line 59
Warning: main(/home/xxx/public_html//b2template.functions.php): failed to open stream: No such file or directory in /home/xxx/public_html/blog.header.php on line 11
Fatal error: main(): Failed opening required '/home/xxx/public_html//b2template.functions.php' (include_path='.:/usr/local/lib/php') in /home/xxx/public_html/blog.header.php on line 11
if you know anything, please let me know.
i already set mysql. |
|
| Back to top |
|
|
Anthop
Joined: 20 May 2004
Posts: 1
|
| Posted: Thu May 20, 2004 1:37 am Post subject: "Can't Connect to the Database" Error |
|
|
I think mine is just a simple and stupid error, but I'm hoping someone would please help me out with it, as I'm really looking forward to using b2 for my blog.
This is the error message from running b2install.php (on IE6):
| Quote: | Can't connect to the database
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
This is the section on MySQL from the b2config.php file:
| Quote: | # fill with your database details
$dbname = 'mysql'; // the name of the database
$dbhost = 'localhost'; // 99% chances you won't need to change this value
$dbusername = 'root'; // your MySQL username
$dbpassword = <omited, but it's I know this is right>; // ...and 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'; |
I think all these values are right. Any suggestions please? I would greatly appreciate it.
PS: I know this error was brought up earlier in this thread, but I don't think it was answered. If it was, if someone could please just direct me to the answer, that would be cool, too. Thanks!
_________________
~@~ "oooh swirly...." ~@~ |
|
| Back to top |
|
|
aldo
Joined: 15 Sep 2004
Posts: 2
|
| Posted: Wed Sep 15, 2004 12:17 am Post subject: |
|
|
eep. I've just tried to open up b2install.php on my server and I got the following message:
Warning: mysql_connect(): Access denied for user: 'tamberly@localhost' (Using password: NO) in /home/tamberly/public_html/asyousleep/b2install.php on line 17
Can't connect to the database
Access denied for user: 'tamberly@localhost' (Using password: NO)
I did the following to make sure that the database was existant and I could connect to it:
| Code: | <?php
//
// test ability to connect to database
$dbname = 'fairy_fallen'; // the name of the database
$dbhost = 'localhost'; // 99% chances you won't need to change this value
$dbusername = 'fairy_fallen'; // your MySQL username
$dbpassword = 'your_db_password'; // ...and password <<<<<< CHANGE TO CORRECT VALUE
mysql_connect($dbhost,$dbusername,$dbpassword) or
die("Can't connect to the database server. MySQL said:<br />".mysql_error());
mysql_select_db("$dbname") or
die("Can't connect to the database $base. MySQL said:<br />".mysql_error());
echo "Done";
?>
|
and it gave me no error.
I am about 100% sure that I used the correct database name, username, and password. any help is appreciated. |
|
| Back to top |
|
|
aldo
Joined: 15 Sep 2004
Posts: 2
|
| Posted: Wed Sep 15, 2004 9:46 pm Post subject: |
|
|
okay, I now have a new problem. I went through the whole thing over again, and now I have the following:
Now creating the necessary tables in the database...
doh, can't create the table "b2posts" in the database.
query:
CREATE TABLE b2posts ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) DEFAULT '0' NOT NULL, post_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, post_content text NOT NULL, post_title text NOT NULL, post_category int(4) DEFAULT '0' NOT NULL, post_karma int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (ID), UNIQUE ID (ID) )
error:
Table 'b2posts' already exists
My host gave me access to her control panel since she doesn't know much about mysql. I went to phpmyadmin to delete the table but it says that there are no tables in the database. =\ |
|
| Back to top |
|
|
quiet-storm
Joined: 09 Aug 2004
Posts: 4
|
| Posted: Sun Oct 10, 2004 8:27 pm Post subject: |
|
|
this is what i'm seeing:
| Quote: | Warning: mysql_connect(): Access denied for user: 'quietst_robbie@localhost' (Using password: YES) in /home/quietst/public_html/robbie/b2install.php on line 17
Can't connect to the database
Access denied for user: 'quietst_robbie@localhost' (Using password: YES) |
the problem is that it's adding an "@localhost" to the end of the username, which is not supposed to be there. how do i stop it from doing that? |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB 2 © 2001, 2002 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
