mysql add root password

Solutions on MaxInterview for mysql add root password by the best coders in the world

showing results for - "mysql add root password"
Javier
12 May 2018
1cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"
2
3C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p
4Enter password: *********
5
6mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newrootpassword';
7Query OK, 0 rows affected (0.10 sec)
8
9mysql> exit
10
Giada
16 Jul 2019
1ALTER USER 'username' IDENTIFIED WITH mysql_native_password BY 'password';
2