Get the App
SLTechnology News&Howtos  ›  Database  › 

About the problem that MySQL5.6 and later versions cannot be started after installation

Shulou Source: shulou.com Published: 2022-06-01 07:24:12 11月16日 Update

Mysql 5.6 and later are released for security reasons, and the root password is not empty. So during the installation of MySQL, a random password is generated

Execute # / etc/init.d/mysql stop

Then # mysqld_safe-- user=mysql-- skip-grant-tables-- skip-networking &

Then execute # mysql-u root mysql

After entering MySQL

Execute > UPDATE user SET Password=PASSWORD where USER='root'

Exit exits mysql

Re-log in # mysql-uroot-p and type passwd

Log in successfully

Tags: Password login version security success process generation problem Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information macOS Shulou Tech Info vpn Redmi