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

21 votes308 views3 answers
Average sql
SQL
0 vote311 views3 answers
Sql count condition
SQL
1 vote319 views1 answer
Sql where last 12 months
SQL
0 vote327 views3 answers
How to run sql query
SQL
6 votes362 views6 answers
Rename column postgres
SQL
0 vote328 views1 answer
Mysql récupérer le code création de vue
SQL
3 votes462 views9 answers
Linq to sql converter online
SQL
0 vote309 views1 answer
Inser into example
SQL
0 vote305 views1 answer
Mysql remove tabs from string
SQL
1 vote312 views1 answer
Xampp import sql file command line
SQL