MYSQL - nastavení hesla

Set password

Po instalaci MySQL bylo nastaveno prázdné heslo.

Pomohl až následující postup. https://www.digitalocean.com/community/questions/can-t-set-root-password-mysql-server

SELECT user,authentication_string FROM mysql.user;

+------------------+------------------------------------------------------------------------+
| user             | authentication_string                                                  |
+------------------+------------------------------------------------------------------------+
| debian-sys-maint | $A$005$j<~")%Ceux!HwCrw6FUL23TVHrdH8jSHnpokHDmihJ3IHFXLOWG4tKOAWD |
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| root             |                                                                        |
+------------------+------------------------------------------------------------------------+


ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_pass_here';

FLUSH PRIVILEGES;

# kontrola, že je heslo zadané - vyplněné políčko hesla

SELECT user,authentication_string FROM mysql.user;