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

8 votes350 views5 answers
Grant permission in postgres
SQL
0 vote369 views1 answer
Sql: extract day text from datetime value
SQL
8 votes372 views2 answers
How to fetch data from database without last column
SQL
1 vote318 views1 answer
Sql get missing id
SQL
0 vote354 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
6 votes284 views2 answers
Generate c# class from sql server table
SQL
13 votes350 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
5 votes314 views1 answer
Sql first day of current year
SQL
7 votes353 views1 answer
Mysql iif
SQL
0 vote327 views1 answer
Groupby error in mysql
SQL