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

24 votes199 views5 answers
Import dump mysql
SQL
3 votes216 views2 answers
Synonym oracle
SQL
0 vote201 views1 answer
Mysql custom sort order
SQL
0 vote201 views1 answer
Declaring variables in pl sql
SQL
1 vote194 views1 answer
Sql count value greater than
SQL
1 vote198 views1 answer
Write a query to create an empty table from an existing table?
SQL
16 votes192 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote177 views1 answer
How to convert DateTime to VarChar SQL
SQL
5 votes201 views1 answer
Oracle list days between two dates
SQL
0 vote263 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL