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

5 votes262 views1 answer
Oracle columns in all_tables
SQL
2 votes261 views2 answers
Postgres set user as superuser
SQL
2 votes271 views1 answer
Get hour from date sql
SQL
0 vote282 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote280 views1 answer
Oracle undo usage per session
SQL
0 vote280 views1 answer
Edit a field mysql terminal
SQL
0 vote274 views1 answer
Sql server concat null
SQL
3 votes372 views1 answer
Oracle cannot access v$session
SQL
0 vote256 views1 answer
Dns slave zone convert
SQL
0 vote263 views1 answer
Postgressql uuid
SQL