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 vote282 views3 answers
Fetlife
SQL
0 vote266 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote260 views1 answer
Mariadb used space
SQL
8 votes266 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote266 views1 answer
Replace content value from old to new sql
SQL
0 vote249 views1 answer
Insert or update cassandra
SQL
3 votes256 views1 answer
How to remove characters from string in mysql
SQL
0 vote236 views1 answer
Sqlite3 now
SQL
0 vote295 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote280 views2 answers
Sql server find all foreign keys that reference a column
SQL