Simple PHP/MySQL ?

[The Hobo]

I'm just starting with MySQL. I created a database and a table, then found an example script to use with the table, however I don't know what to put for the host?

mysql_connect(???, root); 

[filburt1]

localhost...I've only had to use an server name once.

[The Hobo]

I tried that at first (that's what the example had) but then I got a whole mass of errors:

Warning: Access denied for user: 'root@localhost' (Using password: NO) in /home/vbshelf/public_html/test.php on line 13

Do I need a password or something?

[The Hobo]

I got it to connect, but now I have a few more errors to work with.

I had to change root to vbshelf_root.

[ubunreal69]

mysql_connect(???, root); 

well, my ROOT password doesnt have a password, and i use this to connect:

mysql_connect(LOCALHOST, root); 

, i'm not sure about abbreviations and stuff, i cant check @ the moment cos i'v just got a new pc and cant get my other HDD running on it yet, it has my whole page on it and every PHP script i have

[chrisjk]

you should never leave root having no password, for obvious reasons.

This should work fine

// initialise database variable
$db = mysql_connect("localhost", "username", "password"); 

[The Hobo]

Originally posted by The Hobo
I got it to connect, but now I have a few more errors to work with.

I had to change root to vbshelf_root.

Yeah, I'm past that, thanks.

I guess my server requires the domain to be put before everything. So if the user is 'root', it requires 'vbshelf_root' and if the data base is 'bing', it requires 'vbshelf_bing.'

Thanks for the help.

[The Hobo]

Originally posted by chrisjk
you should never leave root having no password, for obvious reasons.

How do I set the password for root?

[ubunreal69]

well, i'd reccomend downloading the MySQL_GUI it is soo handy