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

0 vote348 views1 answer
Selecting Multiple Columns in SQL
SQL
3 votes326 views2 answers
Brew restart mysql
SQL
0 vote322 views1 answer
Tsql find procedure with name
SQL
1 vote334 views1 answer
How to get previous year from sysdate in oracle
SQL
2 votes327 views2 answers
Mysql limit
SQL
2 votes303 views1 answer
Import database in mysql command line xampp
SQL
0 vote333 views1 answer
Vowels in sql
SQL
0 vote365 views1 answer
Hashpass
SQL
5 votes317 views2 answers
Update all rows mysql
SQL
1 vote328 views1 answer
"i_am_a_dummy flag" in MySQL
SQL