你的位置:首页 > 信息动态 > 新闻中心
信息动态
联系我们

Linux安装Mysql步骤

2021/12/24 7:40:20

所有操作全部在虚拟机控制台执行,每一步复制执行即可

 

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;