MySql

//使用源
deb http://mirrors.tuna.tsinghua.edu.cn/raspbian/raspbian/ stretch main contrib non-free

//安装 mysql server
$ sudo apt-get install mysql-server
$ sudo mysql -u root

//设置root密码
use mysql;
update user set plugin='mysql_native_password' where user='root';
UPDATE user SET password=PASSWORD('你自己的密码') WHERE user='root';
flush privileges;
exit;

//开启mysql远程访问
$ sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
#将bind-address这行注释掉,然后重启

//重启服务 
$ sudo /etc/init.d/mysql restart

//设置账号可以远程登录
$ mysql -uroot -p
 
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root账号密码' WITH GRANT OPTION;
flush privileges;

https://www.cnblogs.com/ivictor/p/9243259.html

 

posted @ 2018-07-19 08:28  SoghipG  阅读(82)  评论(0编辑  收藏  举报