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 vote378 views1 answer
Mariadb set vertical output format
SQL
0 vote331 views1 answer
Denormalise SQL command
SQL
1 vote348 views1 answer
Blob datatype in mysql
SQL
0 vote324 views1 answer
MySql count occurences more than"
SQL
1 vote353 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote319 views2 answers
Avg() sql
SQL
8 votes320 views2 answers
Phpmyadmin password
SQL
0 vote356 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote328 views1 answer
Oracle execute immediate quotes
SQL
0 vote342 views1 answer
Data types mysql vs postgresql
SQL