MySQL 5.7 default root password

Vote 0 Votes

MySQL 5.7 第一次啟動時會產生一個臨時密碼, 放在 /var/log/mysqld.log
grep password /var/log/mysqld.log
[Note] A temporary password is generated for root@localhost: xxxxxxxxxxxx

用 root 登入後再改密碼
set password=password('xxxxxxxxxxxx');

ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxxxxx';

About this Entry

This page contains a single entry by Pank published on April 21, 2016 10:22 AM.

ISO 8601 Time Formats was the previous entry in this blog.

ssh/sftp no matching cipher found is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Monthly Archives