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 vote296 views1 answer
IIF
SQL
0 vote292 views1 answer
Rabbitmq service not starting
SQL
1 vote318 views1 answer
Spark sql concatenate string and int
SQL
2 votes310 views1 answer
Laravel sql String
SQL
0 vote308 views1 answer
Multiple left join mysql
SQL
0 vote323 views1 answer
How to install postgresql on wsl
SQL
0 vote323 views1 answer
Sql date time query find
SQL
0 vote289 views1 answer
Search db for table name
SQL
0 vote305 views2 answers
SQL BULK INSERT
SQL
0 vote319 views1 answer
Psotgres multiple values
SQL