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

3 votes155 views1 answer
Sql server check version
SQL
1 vote149 views1 answer
Setval pgsql
SQL
1 vote142 views1 answer
Local sql server
SQL
1 vote146 views1 answer
Mysql server does not start mac
SQL
0 vote165 views1 answer
Oracle string length
SQL
3 votes160 views1 answer
Select database in sql
SQL
1 vote155 views1 answer
Mysql show queries running
SQL
1 vote154 views1 answer
Mysql decimal allow negative values?
SQL
0 vote315 views1 answer
The package java.sql is not accessible
SQL
0 vote168 views1 answer
Postgresql import data from csv
SQL