Home · Latest · Trends  /  mysql
0

Change MySQL / MariaDB user password

rated 0 times [  0] [ 0]  / comments: 0 / hits: 45  / 3 months ago, mon, aug 6, 2018, 11:36:25
Showing a couple different ways depending on version
# For version 5.7.5 and earlier:
SET PASSWORD FOR 'rob'@'localhost' = PASSWORD('MyNewPass');

# For versions after version 5.7.5
ALTER USER 'rob'@'localhost' IDENTIFIED BY 'MyNewPass';
More From » mysql
 

Comments

There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account
 
Share
Sponsor
Posted
rob

rob

Member since Feb 22, 2017
Total Code Snippets: 117
Total Comments: 1
Location: n/a
Following
User not following anyone yet.
rob snippets
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017
2 yaers ago, wed, feb 22, 2017