阿里云ubuntu系统安装mysql8.0

    1 #卸载MySQL5.7版本
    2 apt remove -y mysql-client=5.7* mysql-community-server=5.7*
    4 # 卸载5.7的仓库信息
    5 dpkg-l | grep mysql | awk 'iprint $2}' | xargs dpkg -P
    
    
    powershell

    apt update
    
    
    powershell

    apt install -y mysql-server
    
    
    powershell

    查看状态：/etc/init.d/mysql status
    停止：/etc/init.d/mysql start
    启动：/etc/init.d/mysql stop
    
    
    powershell

    #直接连接输入：mysql
    mysql
    
    
    powershell

    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password By '自己输入密码';
    
    
    powershell

    exit
    
    
    powershell

    mysql_secure_installation
    
    
    powershell

    #方式一
    mysql -u用户名 -p密码
    #方式二
    mysql -u用户名 -p
    后面在输入密码，安全性好一点
    
    
    powershell

    [mysqld]
    bind-address = 0.0.0.0
    
    
    powershell

    #检查用户权限
    SHOW GRANTS FOR 'your_username'@'%';
    #修改权限
    update user set host='%' where user='your_username';
    
    
    powershell

    #查看防火墙状态
    sudo ufw status
    #开启防火墙
    sudo ufw enable
    #关闭防火墙
    sudo ufw disable
    #开防火墙端口
    sudo ufw allow 端口号
    
    
    powershell

    sudo service mysql restart
    
    
    powershell