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 vote250 views1 answer
Psql import backup file for windows
SQL
0 vote233 views1 answer
Oracle allow space to user
SQL
0 vote217 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote259 views1 answer
Compare subqueries oracle
SQL
2 votes256 views1 answer
Mysql set value as null
SQL
1 vote260 views1 answer
Get current date in pyspark sql
SQL
0 vote240 views1 answer
Add computed column to table sql server
SQL
0 vote227 views1 answer
Oracle procedure chain step
SQL
1 vote236 views1 answer
Postgres set column equal to another
SQL
0 vote244 views1 answer
Laravel migration sql dump
SQL