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

1 vote341 views1 answer
How to test for sql injection
SQL
0 vote330 views1 answer
Mysql select statement after index
SQL
32 votes344 views6 answers
How to change column name in sql
SQL
0 vote335 views1 answer
Oracle create job if not exists
SQL
2 votes309 views3 answers
Replace null in sql
SQL
0 vote333 views1 answer
Test database for sql
SQL
0 vote388 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote333 views1 answer
Sql server get date of previous sunday
SQL
0 vote306 views1 answer
Create column that already exists mysql
SQL
21 votes333 views4 answers
Oracle add column
SQL