PDA

View Full Version : MYSQL Database Problem


x111
10-20-2006, 09:05 AM
I am using php fusion, and for some reason it says, Unable to establish connection to MySQL
1045 : Access denied for user 'root'@'localhost' (using password: NO)
My username is not "root" I am using a pass.
It's right in the config file, it just will not connect.
Any help is appreciated.

keith
10-20-2006, 03:32 PM
I am using php fusion, and for some reason it says, Unable to establish connection to MySQL
1045 : Access denied for user 'root'@'localhost' (using password: NO)
My username is not "root" I am using a pass.
It's right in the config file, it just will not connect.
Any help is appreciated.
First of all,
you need to set up the MySQL database from your control panel. Go there and create a database for your php fusion

Then, your config. should be "xxxx_username" and host is "mysql"

x111
10-20-2006, 03:57 PM
Thanks. Didn't know the host was mysql.

x111
10-20-2006, 04:32 PM
still no luck

azx
10-20-2006, 04:49 PM
still no luck

Post your config here

the Host must be: mysql not localhost
username and dbname are the same: xxx_sqlname
password: the pw

after that go to its phpmyadmin and click on import. Then import the sql db...

If you dont understand Then i cannot help ya :(

UnlimitedMB
10-20-2006, 05:00 PM
I am using php fusion, and for some reason it says, Unable to establish connection to MySQL
1045 : Access denied for user 'root'@'localhost' (using password: NO)
My username is not "root" I am using a pass.
It's right in the config file, it just will not connect.
Any help is appreciated.

root@localhost with no password is mysql's default setting when it is not configured.

So you have not got it right in the config file, otherwise this wouldnt be happening.

x111
10-20-2006, 08:32 PM
It installed, but then, it stoped working again.

The config file is:

<?php
// database settings
$db_host="mysql";
$db_user="1841_fusion";
$db_pass="************";
$db_name="1841_fusion";
$db_prefix="fusion_";
define("DB_PREFIX", "fusion_");
?>

So it's not the config file. And in phpmyadmin, the db info is there, just when I try to connect from the site, using that config file, it doesn't work.

UnlimitedMB
10-21-2006, 12:19 AM
Like it said before, there is one, and only one explanation for that error message.
You have not configured mysql database settings.
Its simply impossible that you could get this error for any other reason.

Possibly you put the config file in the wrong place.

You should contact the company which make this script to ask how to install it.

x111
10-21-2006, 05:58 AM
I know php and sql. I know how to install it, I've done so 4 times. It just will not work here for some reason.

UnlimitedMB
10-21-2006, 02:14 PM
You need to contact the script author.

This is not a problem with our server.
From my previous experience, fusion php scripts are badly written and have always had compatibility problems with nearly every server ive seen them on.