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 vote141 views1 answer
Now() -1 mysql
SQL
3 votes176 views1 answer
Index using in query plsql
SQL
28 votes185 views4 answers
Show tables mysql
SQL
12 votes177 views1 answer
Create column sql server
SQL
8 votes184 views1 answer
Oracle search code in packages
SQL
1 vote194 views1 answer
Mysql print variable
SQL
1 vote190 views1 answer
Oracle drop chain step
SQL
0 vote197 views1 answer
Change role postgres
SQL
0 vote223 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote172 views1 answer
What is the use of index in mysql table
SQL