/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

0 vote103 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote119 views1 answer
How to create a table based on another table in mysql
SQL
0 vote119 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote113 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote147 views1 answer
Drop domain postgresql
SQL
0 vote113 views1 answer
Get statis values sql
SQL
0 vote126 views1 answer
Suhaib
SQL
0 vote133 views1 answer
Add a new column into table
SQL
5 votes108 views1 answer
Oracle find foreign key dependencies
SQL
11 votes111 views1 answer
Oracle view source
SQL

Share