Hi, here I have another problem for you guys.I am doing this tutorial on mysql and php:
Now after I have reinstalled everything, MySql,phpMyAdmin and PHP everything works fine except I cannot log in as root.When I installed mySql I set a root password and also I created 2 accounts both admin.I can connect with the db from the command line with both but not as root.If I insert the root password the prompt disappears.I experimented a little and I can connect like this localhost/connecting.php with this code and any of the 2 accounts:
<?php mysql_connect("localhost","Carlo","mypassword" or die(mysql_error()); echo "Connected to my SQL<br/>"; ?>
of course I replace mypassword with 1 of the 2 accounts password,I don't know the purpose of the <br/>tag.
All the exercises in the tutorial assume that I connect like this:
$dbcnx = mysql_connect('localhost','root','mypassword'); which does not work in my case because of the root problem I think.So I am stuck is there a way to fix this?
Thanks for your help.