msql login problem

[ronkirby]

Hi there
I have recently installed mysql , apache, and php as per the book
database driven websites
i have access to command prompt of mysql and can make and use databases
however i cannot loginto mysql from the webpage
php is working fine and so is apache
i can access the webpages from other computers on my home system ok
and i can access from the comp that has the servers running on it.
but cant figure out how to connect to database from the webpage
chap 4 jokes.php
the sect below shows one of the configs i have tried I have not found out any reference to $dbcnx so not sure why that is there.
// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'dad', 'james');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');


any ideas would be appreciated
regards Ron Kirby

[Toly]

It seems to me that you didn't create a password for the root user.

If you don't know how to do that, here's a reference:

At the console window type the following commands (replace new_password with your new password):
Enter: cd c:\mysql\bin
Enter: mysql −u root mysql
Response: Welcome to the MySQL monitor .....
Enter: UPDATE user SET Password=PASSWORD('new_password')
Enter: WHERE user='root';
Response: OK...
Enter: FLUSH PRIVILEGES;
Response: OK...
Enter: DELETE FROM user WHERE user='';
Response: OK...
Enter: DELETE FROM user WHERE Host='%';
Response: OK...
Enter: DELETE FROM user WHERE User='';
Response: OK...
Enter: DELETE FROM db WHERE Host='%';
Response: OK...
Enter: exit
Response: Bye
Enter: exit
Response: Console window closes.

Then, if you want to use the root user, you do the following:

$dbcnx = @mysql_connect('localhost', 'root', 'your_password'); 

[ronkirby]

It seems to me that you didn't create a password for the root user.

If you don't know how to do that, here's a reference:

At the console window type the following commands (replace new_password with your new password):
Enter: cd c:\mysql\bin
Enter: mysql −u root mysql
Response: Welcome to the MySQL monitor .....
Enter: UPDATE user SET Password=PASSWORD('new_password')
Enter: WHERE user='root';
Response: OK...
Enter: FLUSH PRIVILEGES;
Response: OK...
Enter: DELETE FROM user WHERE user='';
Response: OK...
Enter: DELETE FROM user WHERE Host='%';
Response: OK...
Enter: DELETE FROM user WHERE User='';
Response: OK...
Enter: DELETE FROM db WHERE Host='%';
Response: OK...
Enter: exit
Response: Bye
Enter: exit
Response: Console window closes.

Then, if you want to use the root user, you do the following:

$dbcnx = @mysql_connect('localhost', 'root', 'your_password'); 

Hi toly
I managed to get it to work yesterday by following instructions from this post http://www.sitepoint.com/forums/show...95&postcount=6
however after switching the computer off
i have no access at all
and the mysql server will not start and won't reconfigure with the windows interface that comes with the program " mysql server config wizard"
So i will uninstall it and start over
i will do what you have suggested , I hope it will still work after a reboot.
Thankyou for your time, it is certainly appreciated.
regards Ron Kirby
I will post my results