/SQL/Change mysql password from command line

Change mysql password from command line

Mysql set password for user

# `SET PASSWORD FOR <user> = PASSWORD('<plaintext_password>')` is deprecated
SET PASSWORD FOR <user> = '<plaintext_password>';
FLUSH PRIVILEGES;

2

Source: dev.mysql.com

Change mysql password from command line

ALTER USER 'root'@'localhost' IDENTIFIED BY 'New-Password';

0

Similar codes

3 votes216 views2 answers
Oracle apex view logs
SQL
0 vote216 views1 answer
How to start my sql server on mac
SQL
7 votes206 views6 answers
Group_concat mysql
SQL
4 votes186 views2 answers
Oracle set date format
SQL
2 votes190 views1 answer
Merge two columns in sql oracle
SQL
0 vote192 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
5 votes168 views1 answer
Alter table default value mysql
SQL
0 vote189 views1 answer
Full syntax inner join
SQL
2 votes201 views1 answer
Mysql find tables with name
SQL
11 votes212 views2 answers
Turn off safe mode mysql
SQL

Share