Alter user root mysql

Set password mysql

-- In case the UPDATE command returns "Column 'Password' is not updatable" run
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword';

flush privileges;

Alter user root mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword';

Change mysql password from command line

ALTER USER 'root'@'localhost' IDENTIFIED BY 'New-Password';

Similar codes

0 vote178 views1 answer
Stored function in sql
SQL
1 vote176 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
1 vote165 views1 answer
Sql server reseed single table
SQL
0 vote177 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote176 views1 answer
Select a row include list of array with join table SQL
SQL
2 votes158 views1 answer
Plsql left() function
SQL
1 vote206 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote176 views1 answer
Delete record by id sql
SQL
19 votes199 views3 answers
How to change column type psql
SQL
0 vote167 views1 answer
Sql server delete records with specific date
SQL