1. 查看初始密码:
grep "temporary password" /projects/mysql/log/mysqld.log
2. 进入mysql命令行:
./mysql -uroot -h 127.0.0.1 -p
3. 修改数据库密码:
set password for root@localhost = password('a123456789b!');
4. 允许远程登录:
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "a123456789b!";