how can i set password to mysql database

[extemer]

hi guys i want to set password to mysql database please help me out

[d5e5]

hi guys i want to set password to mysql database please help me out

For which user do you want to set a password. If you haven't created any user accounts yet I guess you mean you want to set a password for the root user. What platform does your MySQL run on: Windows, Linux, something else? See http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

[extemer]

it runs on windows

[b1izzard]

try

mysql> update user set password=PASSWORD('yournewpassword') where User='username';