參考這兩個(gè)鏈接下載 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 創(chuàng)建用戶和數(shù)據(jù)庫
sudo mysql # 登陸mysql
如何創(chuàng)建用戶镀首,并授權(quán)參見這里:
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'@'%';
允許用戶遠(yuǎn)程訪問MySQL
參見文章:
http://www.reibang.com/p/01b35fd286c4
找到bindadress 并注釋掉桃笙。
在 /etc/mysql/my.cnf 里沒找到,去其include的配置文件里找L掖俊爪喘!