Member Avatar

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

  • 3 Contributors
  • forum 3 Replies
  • 115 Views
  • 1 Week Discussion Span
  • comment Latest Post Latest Post by b1izzard

Recommended Answers

Answered by d5e5 109 in a post from

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 …

Jump to Post

All 3 Replies

Member Avatar

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

Member Avatar

it runs on windows

Member Avatar

try

mysql> update user set password=PASSWORD('yournewpassword') where User='username';
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!