系統(tǒng) --- centOs7

安裝mysql5.7

• 添加mysql到Y(jié)UM源

  sudo rpm -ivh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

• 安裝mysql

  sudo yum -y install mysql-community-server

• 啟動(dòng)mysql

  systemctl start mysqld
  systemctl stop mysqld
  systemctl status mysqld
  systemctl restart mysqld
  

• 查看密碼

  cat /var/log/mysqld.log | grep -i 'temporary password'

• 修改密碼

  https://github.com/jaywcjlove/mysql-tutorial/blob/master/chapter17/17.3.md

  問(wèn)題 You must reset your password using ALTER USER statement before executing this statement.

  mysql> set password=password("youpassword");

• 允許遠(yuǎn)程連接

  1.允許root用戶在任何地方進(jìn)行遠(yuǎn)程登錄，并具有所有庫(kù)任何操作權(quán)限：

  mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "設(shè)置密碼" WITH GRANT OPTION;
  
  mysql> FLUSH PRIVILEGES;mysql>exit;
  

參考

https://juejin.im/post/5c088b066fb9a049d4419985

https://github.com/jaywcjlove/mysql-tutorial/blob/master/chapter17/17.3.md