参考这两个链接下载 MySQL的apt源
https://linuxconfig.org/how-to-install-mysql-community-server-on-debian-9-stretch-linux
https://dev.mysql.com/downloads/repo/apt/
安装上面下载的apt源
sudo dpkg -i /PATH/version-specific-package-name.deb
安装MySQL Community Edition
sudo apt-get update
sudo apt-get install mysql-server
登陆Mysql 创建用户和数据库
sudo mysql # 登陸mysql
如何创建用户,并授权参见这里:
https://dev.mysql.com/doc/refman/5.7/en/adding-users.html
create database bfy;
CREATE USER 'bfy'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON bfy.* TO 'bfy'@'%';
允许用户远程访问MySQL
参见文章:
http://www.jianshu.com/p/01b35fd286c4
找到bindadress 并注释掉。
在 /etc/mysql/my.cnf 里没找到,去其include的配置文件里找!!
网友评论