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 vote339 views1 answer
Mysql update inner
SQL
0 vote330 views1 answer
Manage Database in MySQL
SQL
0 vote287 views1 answer
Mysql add to value
SQL
4 votes279 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote300 views1 answer
Sql server create constraint
SQL
2 votes292 views1 answer
Sql ends with string
SQL
1 vote302 views1 answer
Increasing font and zooming in mysql workbench
SQL
7 votes339 views2 answers
Sql remove duplicates based on column
SQL
1 vote287 views3 answers
Psql fatal database does not exist
SQL
2 votes299 views2 answers
Mysql user access to database
SQL