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

6 votes134 views3 answers
Can you update NULL in sql
SQL
1 vote209 views1 answer
Column with prefix in sql
SQL
6 votes144 views1 answer
Update left join mysql
SQL
1 vote209 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote203 views1 answer
Postgres rename database
SQL
2 votes149 views4 answers
Mysql get all tables row count
SQL
0 vote139 views1 answer
Mysql search multiple tables
SQL
0 vote147 views1 answer
Mysql Selected All Duplicate Rows
SQL
2 votes241 views1 answer
Sql ends with string
SQL
0 vote152 views1 answer
Mysql page segment
SQL