linux安装mysql步骤

sudo -》以管理员身份

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停止

root登不进去 是因为root刚安装没有密码

7.如果忘了初始密码root的初始密码需要额外设置

可以cd etc/mysql下 有一个配置文件

debian.cnf 可以用

sudo gedit debian.cnf打开debian.cnf

提取账号密码 保存到桌面文档中

8.然后用文件中的账号密码登录

mysql -u你的账号 -p你的密码

9.登陆进去

use mysql;

update user set authentication_string=PASSWORD("123") where user='root';

update user set plugin="mysql_native_password";

flush privileges;

quit;

________________________从此root有了密码

10.再重启服务就行了

从此以后 直接用mysql -uroot -p你的root密码 登录就可以了 root可以用了

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;