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 vote153 views1 answer
How to select only a certain date sql
SQL
0 vote185 views2 answers
Postgres isnull
SQL
0 vote147 views1 answer
Get number of rows in every table mysql
SQL
0 vote149 views3 answers
Postgres trim string
SQL
1 vote157 views1 answer
Rows to comma separated values in mssql
SQL
37 votes197 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
-1 vote172 views1 answer
Module operator in oracle sql
SQL
0 vote224 views3 answers
How to find all role in mysql
SQL
0 vote152 views1 answer
SQL loop with cursor
SQL
0 vote153 views1 answer
Starting mysql shell lampp ubuntu
SQL