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 vote241 views1 answer
Postgres format date in select
SQL
0 vote256 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote250 views1 answer
H2 auto increment and unique
SQL
7 votes275 views1 answer
Query postgres delete duplicates
SQL
0 vote252 views1 answer
Laravel eloquent get generated sql
SQL
0 vote264 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
6 votes245 views1 answer
Postgresql get year
SQL
0 vote265 views1 answer
Sql output select
SQL
1 vote248 views2 answers
Sql select only first occurrence
SQL
4 votes268 views2 answers
Linq join
SQL