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

16 votes135 views3 answers
Get count of duplicate records
SQL
5 votes128 views1 answer
Oracle sysdate - 1 month
SQL
0 vote124 views1 answer
View psql output in horizontal scrolling
SQL
3 votes143 views1 answer
Apex set debug level
SQL
0 vote107 views1 answer
Update set with inner join oracle
SQL
0 vote67 views1 answer
Mysqli or pdo
SQL
0 vote111 views1 answer
Restart sql server command line linux
SQL
1 vote120 views1 answer
Mysql text to decimal
SQL
16 votes115 views2 answers
Add column to all tables after first column mysql
SQL
2 votes106 views1 answer
Oracle sql query to make column data uppercase
SQL