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 vote453 views1 answer
Power bi connect to postgresql
SQL
18 votes204 views6 answers
Drop table if exists
SQL
3 votes347 views2 answers
Oracle sql first day of month
SQL
0 vote225 views1 answer
Find how many tables in database sql query
SQL
1 vote195 views1 answer
How to find median of a column sql
SQL
4 votes206 views1 answer
Conda install sqlalchemy
SQL
1 vote199 views1 answer
T-sql find object by name
SQL
0 vote186 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
3 votes259 views1 answer
Dbms_scheduler drop_job
SQL
0 vote209 views1 answer
How to use lower case in mysql
SQL