当前linux环境 ubuntu 18.04
#安装
apt update
apt install mysql-server #安装服务端
apt install mysql-client #安装客户端
apt install libmysqlclient-dev #安装依赖包
#查看mysql是否启动
mysql -V
netstat -tap | grep mysql #端口号默认为3306
#修改配置,注释掉 bind-address = 127.0.0.1:
vi /etc/mysql/mysql.conf.d/mysqld.cnf
#设置数据库允许远程访问
mysql -u root -p #进入mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION; #设置root远程访问
flush privileges; #刷新设置
#mysql启动/重启/停止
service mysql start/restart/stop