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 vote175 views1 answer
How to select rows with no matching entry in another table?
SQL
1 vote162 views1 answer
Mysql stop password policy
SQL
9 votes177 views2 answers
Nosql databases
SQL
4 votes175 views1 answer
Mysql set max connections
SQL
-1 vote184 views1 answer
Pl sql drop trigger
SQL
0 vote177 views1 answer
Sql server order by nulls last
SQL
1 vote169 views1 answer
OstgreSQL version
SQL
5 votes175 views1 answer
Oracle list days between two dates
SQL
0 vote170 views2 answers
Mysql password error create datbase
SQL
3 votes161 views1 answer
Sql cast to integer
SQL