what the f---

[webchef]

i just installed the latest of the triad (manually).. php4, apache2, and mysql 4.0.1...

according to WINmysqladmin 1.4 my username and password is administrator:admin.

so why is it that when i load a page with the following database connection information:

//Connection information
$dbhost = "localhost";
$dbuser = "administrator";
$dbpass = "admin";
$dbname = "xxxxxx";

Do i get this error:????!!!!!??!!!!

Access denied for user: 'administrator@localhost' (Using password: YES)

[bastien]

the login/pass is probably for console only... You will likely need to login into the console using those and then create a new user that has access from other areas...

have a look at the inital accouts info and Grants

[webchef]

what console? where can i find it? how do i use it?

and how come i never had to do any of that before?

i've always just used the apache installer to install apache.. the zip binary for php (just extract, move and edit the php.ini file and add the appropriate lines to the apache config file).. and i always use the installer for mysql, afterwhich i double click on winmysql and it asks me for a username and password. i put administrator:admin and everything would work just fine.

this is all confusing.. maybe i should have installed IIS or something.

[bastien]

read the docs in the links that I posted, they will help you...

in short

c:\mysql\bin mysqld -u administrator -p admin

and see what happens (noting that if mysql is not on c then change it to the appropriate drive letter)

[webchef]

coool.. i got it.. thanks