Deepin 系统(20.1)安装mysql

1. 下载linux通用安装包

2. 安装包解压至 /usr/local

sudo tar -xvJf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz -C /usr/local

3. 创建软连接

cd /usr/local  
sudo ln -s mysql-8.0.19-linux-glibc2.12-x86_64 mysql

4. 添加mysql用户组合mysql用户

sudo groupadd mysql
  sudo useradd -r -g mysql -s /bin/false mysql

5. 创建data文件夹用于存放数据库文件并修改当前目录拥有者为mysql

cd /usr/local/mysql
    sudo mkdir /usr/local/mysql/data
    sudo chown -R mysql:mysql ./

6. 安装MySQL

sudo ./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

安装完成会显示

2021-03-26T01:57:41.571842Z 0 [System] [MY-013169] [Server] /usr/local/mysql-8.0.23-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.23) initializing of server in progress as process 8823
		    2021-03-26T01:57:42.070133Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
		    2021-03-26T01:57:52.572432Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
		    2021-03-26T01:58:08.146069Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: -qhtgLpig7,M

注意保存最后输出的初始密码

7. 启动MySQL

cd /usr/local/mysql-8.0.19-linux-glibc2.12-x86_64/support-files 
sudo ./mysql.server start

8. 登录MySQL

cd /usr/local/mysql/bin
./mysql -u root -p

输入第6步生成的密码即可

9. 设置新密码

alter user root@localhost identified by 123456;

10. 安装成功后 可能存在 mysql 命令找不到的问题,此时应该配置环境变量

sudo vi /etc/profile

在文件最后面增加

export PATH=$PATH:/usr/local/mysql/bin

执行生效即可

source /etc/profile

11. 设置外网访问

use mysql;
update user set host=% where user =root;
FLUSH PRIVILEGES;  #刷新权限
GRANT ALL PRIVILEGES ON *.* TO root@%WITH GRANT OPTION;