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 vote185 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote176 views1 answer
Show size of all tables postgres
SQL
0 vote202 views1 answer
To Create directory
SQL
2 votes200 views1 answer
Removing view
SQL
9 votes169 views3 answers
Show table columns mysql command line
SQL
0 vote175 views1 answer
Oracle list proxy users
SQL
0 vote178 views1 answer
Add colum date in sql
SQL
0 vote267 views2 answers
Search stored procedures by name
SQL
20 votes190 views3 answers
How to open postgresql in mac
SQL
0 vote191 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL