MySQL Configuration

---

MySQL

1. Download

• Version：mysql-5.7.27
• Download https://dev.mysql.com/downloads/mysql/

2. Setup

• Extract
• Locate to cmd: d:\mysql-5.7.27-winx64\bin
• Create service: mysqld --install
• Build data: mysqld --initialize
• Start: net start mysql

3. Reset password

• Go to mysql/data/XXX.err find initial password (closely behind root@localhost)
• Login: mysql -uroot -p
  • Local login：mysql -u[username] -p[password]
  • Given IP login：mysql -h[host address] -u[username] -p[password]
• Reset password: mysql> set password for root@localhost = password('???');
• Logout: mysql> exit
  • exit
  • quit

4. Test

• Check version：cmd: mysql --version

---

原文链接：https://qwert.blog.csdn.net/article/details/105804411