deepin v20安装mysql

梦里梦外; 2022-12-13 15:28 175阅读 0赞

## deepin v20 换源和安装mysql ##

## 由于deepin v20不能直接安装mysql所以先进行换源，更换成阿里源，这样以后速度可以更快 ##

1.  修改文件 sudo vim /etc/apt/sources.list

#删除内容，并添加以下内容：
    ## Generated by deepin-installer
    deb [by-hash=force] https://mirrors.aliyun.com/deepin/ panda main contrib non-free

2.执行sudo apt-get update  
3.执行sudo apt-get upgrade命令。

## 安装mysql ##

1.执行安装mysql的语句

sudo apt-get install mysql-server mysql-client

2.查看可登陆账户并查看密码  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA3OTk3NA_size_16_color_FFFFFF_t_70_pic_center]3.获取到了登陆mysql的账户密码

lin@lin-PC:~$ mysql -udebian-sys-maint -pjSaNFiRzjlDAxiRN
    mysql: [Warning] Using a password on the command line interface can be insecure.
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.21-1 (Debian)
    
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql>

4.之后依次进入mysql数据库，修改root密码，刷新缓存。之后就可以exit退出使用root账户登录了：

use mysql;
    update user set plugin="mysql_native_password",authentication_string=password('新密码') where user="root";
    FLUSH PRIVILEGES;

5.使用修改后的帐号密码登陆

mysql -uroot -p000000

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA3OTk3NA_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/35b930284ab240348f3e712e17fc4ef9.png