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 vote446 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote366 views1 answer
SQL query to get all table records count from a database
SQL
6 votes440 views3 answers
What is where in sql
SQL
0 vote373 views1 answer
Add sqlcmd to path linux
SQL
4 votes359 views2 answers
Oracle unlock user
SQL
1 vote356 views1 answer
Show per page table in xampp
SQL
2 votes395 views2 answers
Postgresql get table names
SQL
0 vote367 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote416 views1 answer
Sql server set variable if exists
SQL
1 vote405 views1 answer
Best configuration for display table in sqlplus
SQL