| View previous topic :: View next topic |
| Author |
Message |
jenjen
Joined: 23 Jan 2004
Posts: 5
|
 Posted: Fri Jan 23, 2004 3:19 pm Post subject: Installation error |
 |
|
Hi... could someone help me with this please...
Warning: mysql_connect(): Unknown MySQL Server Host '[email protected]' (2) in /home/shuin/public_html/aeris/b2install.php on line 17
Can't connect to the database
Unknown MySQL Server Host '[email protected]' (2)
I seriously don't know what's wrong since it's the first time I'm using b2 |
|
| Back to top |
|
 |
stevem
Joined: 15 Mar 2003
Posts: 69
|
| Posted: Fri Jan 23, 2004 10:10 pm Post subject: |
|
|
Check that your changes to b2config.php in the lines | Code: | // ** MySQL settings **
# fill with your database details
$dbname = 'b2'; // the name of the database
$dbhost = 'localhost'; // 99% chances you won't need to change this value
$dbusername = 'user'; // your MySQL username
$dbpassword = 'pass'; // ...and password |
are correct. In particular, have you left | Code: | $dbhost = 'localhost'; // 99% chances you won't need to change this value
|
alone? |
|
| Back to top |
|
|
jenjen
Joined: 23 Jan 2004
Posts: 5
|
| Posted: Sat Jan 24, 2004 12:43 pm Post subject: |
|
|
yep... I left the
$dbhost = 'localhost'; // 99% chances you won't need to change this value
alone... so wat do i do -.- |
|
| Back to top |
|
|
stevem
Joined: 15 Mar 2003
Posts: 69
|
| Posted: Sat Jan 24, 2004 1:08 pm Post subject: |
|
|
The question is, where is it getting '[email protected]' from? Have you put this in anywhere?
Also do you have CPanel to configure your site? If so, go to MySQL Databases. At the bottom of the page what does it say for Access Hosts? Is it localhost? |
|
| Back to top |
|
|
jenjen
Joined: 23 Jan 2004
Posts: 5
|
| Posted: Sun Jan 25, 2004 11:35 am Post subject: |
|
|
Well it's getting '[email protected]' from nowhere because I changed it to localhost... sorry -.-"
Anyways now it's saying something like this...
Warning: mysql_connect(): Access denied for user: '[email protected]@localhost' (Using password: YES) in /home/shuin/public_html/aeris/b2install.php on line 17
Can't connect to the database
Access denied for user: '[email protected]@localhost' (Using password: YES)
And I don't have a CPanel to configure my site because I'm hosted...
Sorry to have confused you and all... so sorry... |
|
| Back to top |
|
|
stevem
Joined: 15 Mar 2003
Posts: 69
|
| Posted: Sun Jan 25, 2004 11:51 am Post subject: |
|
|
Believe it or not that is good news as we are getting somewhere!
Access denied for user: '[email protected]@localhost' means that you either have the username or the password wrong. So you need to figure out which it is. Should there be an @ in the username? What happens if you just try aeris?
I presume your host has set up the database? If so, they would be able to advise you as to the correct username and password, which could differ from others you use on the system. |
|
| Back to top |
|
|
jenjen
Joined: 23 Jan 2004
Posts: 5
|
| Posted: Mon Jan 26, 2004 2:43 pm Post subject: |
|
|
Okay it all works now thanks to you ^^ Thanks a lot.... but now when I try to login... it says...
Your SQL query:
SELECT * FROM Jenny WHERE user_login = ''
MySQL said:
Table 'shuin_aeris.Jenny' doesn't exist
What does it mean ? |
|
| Back to top |
|
|
stevem
Joined: 15 Mar 2003
Posts: 69
|
| Posted: Mon Jan 26, 2004 5:16 pm Post subject: |
|
|
It is checking your password to see if it is valid, but can't find the table it is stored in. I wouldn't have thought there should be a table call Jenny.
In b2config.php have you changed any of the details in:
| Code: | $tableposts = 'b2posts';
$tableusers = 'b2users';
$tablesettings = 'b2settings';
$tablecategories = 'b2categories';
$tablecomments = 'b2comments'; |
because you shouldn't do. If you have changed them then put back the above lines and try again.
You can only change these names before setting up b2. If b2 has already been set up then you have to accept whatever it says. |
|
| Back to top |
|
|
jenjen
Joined: 23 Jan 2004
Posts: 5
|
| Posted: Sat Feb 07, 2004 12:09 pm Post subject: |
|
|
Thanks for the help ^^ It works now  Thanks a LOT again... hehehe  |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
