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 vote370 views2 answers
How to login to mysql as normal user in ubuntu
SQL
-1 vote438 views1 answer
How to Activate the database
SQL
0 vote359 views2 answers
Postgres another version
SQL
12 votes355 views1 answer
Script to add new column in table sql
SQL
0 vote374 views1 answer
Group by 15 minute interval sql server
SQL
0 vote387 views1 answer
Sqlalchemy empty table
SQL
0 vote350 views1 answer
Sql server is not
SQL
0 vote419 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote379 views1 answer
Postgresql create table many-to-many
SQL
44 votes414 views6 answers
Rename command in sql
SQL