SQL: April 2016 Archives

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 Archive

This page is an archive of entries in the SQL category from April 2016.

SQL: December 2014 is the previous archive.

SQL: October 2016 is the next archive.

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

Monthly Archives