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 vote306 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
2 votes302 views1 answer
Oracle generated column
SQL
0 vote299 views1 answer
Find how many tables in database sql query
SQL
0 vote302 views3 answers
Java hide mysql login credentials
SQL
2 votes281 views1 answer
Sql count having
SQL
0 vote284 views1 answer
Leftjoin in sql
SQL
1 vote300 views1 answer
Oracle sql first day of year
SQL
7 votes317 views5 answers
Max 3 salary in sql
SQL
0 vote244 views1 answer
Sql new line output
SQL
0 vote284 views1 answer
Openquery insert into linked server
SQL