MySQL Details ???? PLEASE HELP ????

He has: 59 posts

Joined: Mar 2006

Hello,

Im trying to install a script to my server, and it says "Please enter your MySQL details"

$connect = @mysql_connect('localhost', 'root', 'pass');'

My local host would be "web10.mysql.000025.net"
The root is the bit i dont get, ive tried entering the user-name for the DB, the DB Name, none seems to be working.

Im presented with a message saying "Unable to connect to the database server at this time."

[CENTER]Could ANYONE Please help me. If it starts working as a result of your advice i will give a one way link to your website for life from mine!!![/CENTER]

Thanks Very Much,

Kind Regards,
Andy MacDonald

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

Hmmm, MySQL doesn't like connections from root really, are you doing this on a hosts machine? Like uploading the script via FTP and then trying to run it? If so, there is no way you will have the root password (unless you've got a dedicated server).

It really sounds like you've just got the wrong user credentials in there! If you could provide some more details about your setup it should be an easy problem to fix.

And remember, it could be a lot worse, you could be using MS SQL Server. Wink

a Padded Cell our articles site!

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

Oh and if I can solve the problem then feel free to post a link to webmaster-forums.net on your site Wink

He has: 59 posts

Joined: Mar 2006

Hi Mate,

cheers for your reply, nah that didnt work. its called article manager, however i have just realised that its the Beta version, so the problem could be with the script itself, so im going to ditch it and find another script somewhere else.

thank you! for your time anyway though. - I will still add your link to my directory, if you can just go to my website (see sig), just fill out the small form there, as soon as i get it i will add it mate...dont worry about filling in the reciprocal link bit.

thanks mate.

Kind Regards,
Andy MacDonald

Busy's picture

He has: 6,151 posts

Joined: May 2001

keep localhost as localhost
root is your username
pass is your password

This line of code is just to connect to the server, not the database, to connect to the actual database something like:

mysql_select_db("databasename")

databasename is the only thing you need to change.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.