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

9 votes132 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote128 views1 answer
Power query case when
SQL
0 vote133 views1 answer
Oracle call a function in a insert statement
SQL
0 vote146 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
8 votes131 views2 answers
Replace string value in sql
SQL
0 vote133 views1 answer
Mysql add to number
SQL
0 vote126 views3 answers
Average salary in sql
SQL
2 votes162 views2 answers
Postgres set user as superuser
SQL
0 vote144 views1 answer
Mysql join column order By and group By
SQL
-1 vote133 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL