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

1 vote146 views1 answer
Apex select list ORA-20999
SQL
0 vote188 views3 answers
How to find all role in mysql
SQL
0 vote133 views1 answer
Sql server concat null
SQL
62 votes176 views8 answers
Mysql add column
SQL
2 votes133 views1 answer
Mysql clear screen
SQL
4 votes132 views1 answer
Oracle user tables
SQL
0 vote123 views1 answer
Max length found in mysql
SQL
0 vote125 views1 answer
Array aggre distinct postgres
SQL
4 votes133 views3 answers
Employee name starting with in sql
SQL
1 vote130 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL