Anyone experienced in mysql?

4p · 13 Dec 2007 at 17:57

This is the access code

$db_host = "localhost"; // mySQL database host
$db_user = "thorpy;"; // mySQL database user
$db_password = "*******;"; // mySQL database password
$db_name = "sb;"; // the name of your mySQL database

I have made the database, its named "sb" - My user is "thorpy" and my password is correct

I get this error

Warning: mysql_connect(): Access denied for user 'thorpy;'@'localhost' (using password: YES) in /var/www/vhosts/harshtimes.teamhost.co.uk/httpdocs/shoutbox.php on line 46
Access denied for user 'thorpy;'@'localhost' (using password: YES)

Can anyone help? If this is the wrong section then please move

Im on MSN, email in trust.

malfunkshun · 13 Dec 2007 at 17:59

thats for phpBB setup?
is the php server actually running locally to the webserver? (same box?) if not change the db_host ="ip or the box runnign mysql"

neil3k · 13 Dec 2007 at 17:59

Have you double checked your password including caps ?

Dolph · 13 Dec 2007 at 18:00

you've got a semi-colon in your quotes for your variable for your username, so it thinks your username is 'thorpy;' not 'thorpy'

elfy · 13 Dec 2007 at 18:01

Dolph said:
you've got a semi-colon in your quotes for your variable for your username, so it thinks your username is 'thorpy;' not 'thorpy'

what he said

4p · 13 Dec 2007 at 18:05

Its not for PHPBB, the server is local and i have tried what Dolph said and it still fails

Oh and ive double checked the password about 20 times

@Dolph

Access denied for user 'thorpy'@'%' to database 'sb;'

New error

malfunkshun · 13 Dec 2007 at 18:06

in fact you have a semicolon in the db name, username and password?

elfy · 13 Dec 2007 at 18:07

malfunkshun said:
in fact you have a semicolon in the db name, username and password?

what he said

Beansprout · 13 Dec 2007 at 18:07

Your db name will possibly be prefixed by your username and an underscore if in a shared hosting environment

elfy · 13 Dec 2007 at 18:08

$db_host = "localhost"; // mySQL database host
$db_user = "thorpy"; // mySQL database user
$db_password = "*******"; // mySQL database password
$db_name = "sb"; // the name of your mySQL database

4p · 13 Dec 2007 at 18:08

Just removed the semicolon from db and its working now

I read something last night that semicolon was needed for it :s

Cheers for the help

malfunkshun · 13 Dec 2007 at 18:09

Thorpy said:
Just removed the semicolon from db and its working now

I read something last night that semicolon was needed for it :s

Cheers for the help

It is needed but outside of the inverteds.