Don't bother for all this configurations,,,,,,,somebody is already doing it for you........

google XAMPP and install it, look the documentation and change the passwords as suggested, you are all...

Thanks for your reply,

But what I am asking is how to do it with the phpmyadmin. I hope you know about it.

phpmyadmin is front-end tool to use mysql. google it if you dont know about it.

The...

hummmm, may be incompetibility between versions

try to google and install "XAMPP" and run the same query on it........

if it is incompetibility between php and mysql these are latest versions...

how to to "ondelete cascade" command with the phpmy admin?

I know how to link the relation between different tables and primary key and foreign keys in the tables but unsure how to put...