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 vote192 views1 answer
Mariadb get column names from table
SQL
0 vote197 views1 answer
Bidirectional outer join sql
SQL
0 vote193 views1 answer
Show create table in postgresql
SQL
0 vote197 views1 answer
T sql return on letters only
SQL
0 vote197 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote208 views1 answer
Mysql set boolean default value
SQL
0 vote192 views1 answer
Check duplicate values plsql
SQL
14 votes195 views2 answers
Oracle add column with default value
SQL
0 vote196 views2 answers
Connect to mysql server mac terminal
SQL
0 vote196 views1 answer
Asp.net core sql server stored procedure
SQL