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

5 votes110 views4 answers
Sql check
SQL
4 votes116 views1 answer
Check database name postgresql
SQL
1 vote101 views2 answers
Mysql SELECT
SQL
0 vote130 views1 answer
R write csv without index
SQL
0 vote106 views1 answer
Check sql database table lock
SQL
0 vote129 views1 answer
Mysql exception output
SQL
1 vote115 views1 answer
Postgresql datetrunc too slow
SQL
2 votes112 views1 answer
Sql count having
SQL
-1 vote85 views1 answer
Mysql if example
SQL
-1 vote120 views3 answers
Psql get last rows
SQL