Latest posts for the topic "Cannot connect to database"

Cannot connect to database

firehazzard — GMT

Would appreciate it if someone could help me with this.

I have uploaded all the guestbook files, created my database and changed the settings in to the following:

[b]$GB_DB["dbName"] = "fastlaneguestb";
$GB_DB["host"] = "localhost";
$GB_DB["user"] = "mark";
$GB_DB["pass"] = "mypassword";[/b]

However when i run the and try to create the tables i get the follow message:

[b]Warning: Access denied for user: 'mark@localhost' (Using password: YES) in /usr/local/psa/home/vhosts/therockitts.com/httpdocs/guestbook/install.php on line 220

Warning: MySQL Connection Failed: Access denied for user: 'mark@localhost' (Using password: YES) in /usr/local/psa/home/vhosts/therockitts.com/httpdocs/guestbook/install.php on line 220
Cannot connect to database.[/b]

I'm pretty sure i'm doing this right as i did it on another site a few months ago without any problem, can anyone help.

Thanks Mark

Re: Cannot connect to database

Anonymous — GMT

[quote="firehazzard"]
[b]$GB_DB["dbName"] = "fastlaneguestb";
$GB_DB["host"] = "localhost";
$GB_DB["user"] = "mark";
$GB_DB["pass"] = "mypassword";[/b]

I think it should read:
$GB_DB["dbName"] = "yoursqldbname";
$GB_DB["host"] = "yoursqlhost"; (without http://)
$GB_DB["user"] = "your sql user assigned name";
$GB_DB["pass"] = "your sql user assigned password";[/b]

firehazzard — GMT

No sorry that didn't work.

[b]Warning: Host 'myhost' is not allowed to connect to this MySQL server in /usr/local/psa/home/vhosts/therockitts.com/httpdocs/guestbook/install.php on line 220

Warning: MySQL Connection Failed: Host 'myhost' is not allowed to connect to this MySQL server in /usr/local/psa/home/vhosts/therockitts.com/httpdocs/guestbook/install.php on line 220
Cannot connect to database[/b]

I have also tried deleting database and starting again with no affect.

Anonymous — GMT

have you checked with your isp that the mysqldb is actually activated ? they can check on their side that everything is operational, if it is an auto setup on some occassions it fails (it did once for me, I lost 2 days trying to figure out what I did wrong when actually the db was inprperly setup)

anyone else got a suggestion ?

Auron — GMT

For host you should leave it as localhost as that is the default for most servers. This is so it uses the local server for the database.

Also do not make your database name too long, as this can sometimes be a problem people with long db names tend to have problems where as people with short ones do not.

Also the database is created when the install script is run so don't create before hand otherwise it won't work. Another option is to make sure that your host id localhost and not something else, this can only be found out by asking YOUR hosting company. Also check you username and password.

Auron

firehazzard — GMT

Thanks for the help, solved the problem which was down to my own stupidity and not being able to see the obvious when its right it front of you.

>>>pointing installer to wrong domain<<<

24 hours before i noticed, how stupid do i feel.