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 vote139 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
2 votes160 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote132 views1 answer
Select other columns with distinct
SQL
2 votes137 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
2 votes151 views1 answer
Capitalize 1st letter in sql server
SQL
1 vote139 views1 answer
Oracle get current schema
SQL
4 votes134 views2 answers
Oracle default date format
SQL
0 vote151 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
3 votes123 views1 answer
MySQL DELETE JOIN
SQL
0 vote142 views2 answers
Temp Space
SQL