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

4 votes275 views2 answers
Postgresql reset sequence
SQL
6 votes291 views1 answer
Oracle rank
SQL
0 vote271 views1 answer
Oracle create package specification
SQL
7 votes284 views3 answers
Python and mysql connectivity
SQL
2 votes263 views2 answers
Exec procedure pl sql
SQL
4 votes283 views2 answers
Oracle unlock user
SQL
1 vote279 views1 answer
Drush sql-dump
SQL
6 votes276 views4 answers
Remove spaces sql server
SQL
10 votes272 views4 answers
Mysql one week ago
SQL
0 vote303 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL