Shulou(Shulou.com)06/01 Report--

Mysql5.7 for security reasons, after initialization, the root password is generated randomly, and the password is placed in the error log.

There are two steps:

The first step is to get the error.log password.

Change the default password

Passwd= `grep 'generated for root@localhost' $base_log/error.log | awk' {print $NF} '`expect

Variable description:

$base_log mysql log log directory

Password that needs to be set for xxxxx

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.