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 vote216 views2 answers
What is 1=2 in sql
SQL
0 vote184 views2 answers
Postgresql get last day of month
SQL
1 vote214 views1 answer
Mysql view curren querys
SQL
0 vote176 views1 answer
Postgresql newline character
SQL
4 votes138 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote274 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote191 views1 answer
Désinstaller postgresql linux
SQL
0 vote196 views1 answer
TSQL convert csv to table
SQL
0 vote362 views1 answer
Install mysql on bash
SQL
0 vote177 views1 answer
How to search query in python3 sqlite3
SQL