Member Avatar for leoxhin

How do I reset a Password for a MySQL user?

  • 2 Contributors
  • 1 Reply
  • 94 Views
  • 3 Minutes Discussion Span
  • Latest Post Latest Post by RomelynCastillo
Member Avatar for RomelynCastillo

For a regular MySQL user you can reset the Password with the SET PASSWORD command:

mysql> SET PASSWORD FOR 'owner' = PASSWORD('secret');
Edited by pritaeas because: Added markdown.
Be a part of the DaniWeb community

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