Enable MySQL remote access permission to allow remote connection

Time:2019-12-2

Environmental Science

  • Ubuntu 18.04
  • MySQL5.7

Log in MySQL database

mysql -uroot -p

Add remote connection permission

use mysql;
grant all privileges  on *.* to [email protected]'%' identified by "password";
flush privileges;

Modify MySQL configuration file

vim /etc/mysql/mysql.conf.d/mysqld.cnf

Annotatebind-addressThis line

Restart MySQL service

service mysql restart

Recommended Today

The scope model & Redux of flux state management

preface Original address: nealyang / personal blog Maybe as a front-end, in the process of learning fluent, I always feel very similar to react native. Even, there is the concept of statesetStateTherefore, in flutter, there are many solutions, such as Redux, rxdart and scoped model. Today, we mainly introduce two common state management solutions: Redux […]