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 vote210 views1 answer
Ignore case in string sql
SQL
1 vote206 views1 answer
Best sql course
SQL
0 vote220 views1 answer
What does leave do in mysql
SQL
0 vote192 views10 answers
John the ripper mysql
SQL
2 votes210 views1 answer
How to insert string variable into sqlite database
SQL
0 vote203 views1 answer
Sql beginning of previous month
SQL
0 vote204 views1 answer
Postgres enumerated type
SQL
2 votes220 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote222 views3 answers
Delete in SQL SERVER
SQL
1 vote209 views1 answer
Setval pgsql
SQL