深智數位DM2057勘誤 === ## 17-4頁步驟3 **錯誤內容`my.ini`** ```mysql= [mysqld] log_bin="D:/MySQLlog/binlog" expire_logs_days = 10 max_binlog_size = 100M ``` **正確內容`my.ini`** ```mysql= [mysqld] log-bin="D:\MySQLlog\binlog" expire-logs-days = 10 max-binlog-size = 100M ``` ## 17-5頁步驟5 **錯誤內容** ```mysql= grant replication slave on *.* to repl@'%' identified by '123'; ``` **正確內容** ```mysql= create user repl@'%' identified with caching_sha2_password by '123'; grant replication slave on *.* to repl@'%'; ``` ## 13.2.4例13-7`root`使用者修改自己密碼 **錯誤內容** ```mysql= mysql> update mysql.user set authentication_string= MD5("123456") where User="root" and Host="localhost"; mysql> flush privileges; ``` **正確內容** ```mysql= ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'NewPassword'; exit; ```