所有操作全部在虚拟机控制台执行,每一步复制执行即可
1.因为国外源下载不了,把源更新为国内的
sudo gedit /etc/apt/sources.list
2.
deb http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse
3.刷新源
sudo apt-get update
sudo apt-get upgrade
4.更新源
sudo apt update
5.在线下载mysql
sudo apt-get install mysql-server
6.测试mysql服务是否安装成功
service mysql start 启动
service mysql status
service mysql stop停止
7.如果忘了初始密码
可以cd etc/mysql下 有一个配置文件
debian.cnf 可以用gedit debian.cnf打开
8.然后用文件中的账号密码登录
mysql -udebian-sys-maint -puHJWAzEiOjtm3Ikl
9.登陆进去
use mysql;
use mysql;
update user set authentication_string=PASSWORD("自定义密码") where user='root';
update user set plugin="mysql_native_password";
flush privileges;
quit;
10.再重启服务就行了
11.如果要windows连接linux中的mysql 则要突破防火墙 设置多用户访问
先找到/etc/mysql/mysql.conf.d/ 目录下有一个mysqlld.conf的文件
sudo gedit mysqld.cnf
注释掉其中 bind-address这一行
然后service mysql restart重启服务
就可以了
grant all privileges on *.* to 'root'@'%' identified by '123123' with grant option;