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 vote149 views1 answer
Oracle sql date winter time
SQL
1 vote160 views1 answer
Autocommit mysql
SQL
16 votes144 views2 answers
Add column if not exists mysql
SQL
0 vote128 views1 answer
How to find unique key in sql
SQL
1 vote156 views1 answer
Oracle insert multiple rows into same table
SQL
1 vote149 views1 answer
How to group by month using sql server
SQL
2 votes183 views1 answer
Sql compare strings
SQL
5 votes132 views1 answer
Mysql change primary key
SQL
9 votes181 views1 answer
No sql
SQL
2 votes134 views1 answer
Sql alchemy or
SQL