mysql root heslo secure install
Kategorie: linux

mysql_secure_installation.


use mysql;
update user set authentication_string=PASSWORD("HESLOHESLO") where user='root';

update user set plugin="mysql_native_password" where user='root';


flush privileges;

------------


systemctl stop mysql
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
/usr/sbin/mysqld --skip-grant-tables --skip-networking &

update user set plugin="mysql_native_password" where user="root";
update mysql.user set authentication_string=password('abc') where user='root';


8.2.2021 0:10:52