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

4 votes188 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote199 views1 answer
Type int in mysql maxlenght
SQL
0 vote203 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote202 views1 answer
How to set up a trigger in sql
SQL
1 vote184 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote236 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote182 views1 answer
Find how many table doesn't contain column in mysql
SQL
3 votes218 views1 answer
Oracle user quota on tablespace
SQL
0 vote185 views1 answer
Cast for print sql
SQL
5 votes195 views2 answers
Mysql drop table cascade
SQL