Mysql user set plugin

mysql> UPDATE mysql.user SET plugin = 'mysql_native_password', authentication_string = PASSWORD('changeme') WHERE User = 'root';
mysql> FLUSH PRIVILEGES;

Source: blog.ndk.name

Similar codes

19 votes315 views3 answers
How to change column type psql
SQL
0 vote294 views1 answer
Mysql search multiple tables
SQL
0 vote273 views1 answer
Get all employees if name ends with in sql
SQL
0 vote351 views1 answer
Site:av.ru "files"
SQL
1 vote320 views1 answer
T-SQL / AZURE Reseed
SQL
2 votes287 views1 answer
Oracle index size calculation
SQL
2 votes298 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote292 views7 answers
Les jointures sql server
SQL
0 vote288 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote316 views1 answer
Postgresql port 5432 not open
SQL