宝塔服务器配置

Linux启动、停止宝塔

# 启动 
/etc/init.d/bt start
# 停止 
/etc/init.d/bt stop

MySQL5.6开启远程连接

修改MySQL的配置文件 /etc/mysql/my.cnf，找到 bind-address = 127.0.0.1，加上注释 #，保存退出, 重启mysq service mysql restart
进入 mysql> mysql -u root -p

# 方式一：修改表数据
mysql>update user set host = '%' where user = 'root'; 
mysql>flush privileges;　　//刷新权限

# 方式二：执行授权语句GRANT  --  推荐
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 
mysql>flush privileges;   //刷新权限

参考内容

• https://www.cnblogs.com/pxblog/p/14594872.html
• https://blog.csdn.net/qq_35824035/article/details/120743160