Category: SQL

  • The initial root password on install can be found by running grep ‘temporary password’ /var/log/mysqld.log stop mysql service systemctl stop mysqld Change mysql environment option systemctl set-environment MYSQLD_OPTS=”–skip-grant-tables” Start mysql with above option enabled systemctl start mysqld Login as root mysql -u root Update the root user password with these mysql commands ALTER USER ‘root’@’localhost’…