Mysql config user password

Mysql set password for user

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

Source: dev.mysql.com

Mysql config user password

-- Open the bash shell and connect to the server as root user:
mysql -u root -h localhost -p
-- Run ALERT mysql command:
ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';
FLUSH PRIVILEGES;

Source: cyberciti.biz

Similar codes

0 vote175 views1 answer
Ansi sql count duplicate rows
SQL
0 vote180 views1 answer
WHERE not regex in SQL
SQL
0 vote200 views1 answer
Openquery join two tables
SQL
0 vote168 views1 answer
Stored procedures example
SQL
1 vote167 views1 answer
Sql select all from one table and one column from another
SQL
0 vote184 views1 answer
Sql delete dastabase
SQL
0 vote186 views1 answer
Mysql check datetime equals date
SQL
0 vote199 views1 answer
Synapse sql table set pk
SQL
2 votes170 views2 answers
Created at and updated at in mysql
SQL
0 vote182 views1 answer
Mysql select inside sum
SQL