统信UOS操作系统安装MySQL数据库

统信UOS操作系统安装MySQL8数据库流程和注意事项:

1、安装依赖项

1
sudo dpkg -i libmecab2_0.996-1.2ubuntu1_amd64.deb

2、安装MySQL安装包

1
2
3
4
5
6
7
8
9
sudo dpkg -i mysql-common_8.0.26-1debian10_amd64.deb
sudo dpkg -i mysql-community-client-plugins_8.0.26-1debian10_amd64.deb
sudo dpkg -i libmysqlclient21_8.0.26-1debian10_amd64.deb
sudo dpkg -i libmysqlclient-dev_8.0.26-1debian10_amd64.deb
sudo dpkg -i mysql-community-client-core_8.0.26-1debian10_amd64.deb
sudo dpkg -i mysql-community-client_8.0.26-1debian10_amd64.deb
sudo dpkg -i mysql-community-server-core_8.0.26-1debian10_amd64.deb
sudo dpkg -i mysql-client_8.0.26-1debian10_amd64.deb
sudo dpkg -i mysql-community-server_8.0.26-1debian10_amd64.deb

安装最后一项时会提示设置MySQL数据的root密码,设置为nitd***6888

1
root:nitd***6888  //root用户密码

3、登录数据库

1
2
3
4
5
6
7
8
9
10
11
//使用root登录,录入命令后按回车键,然后录入密码
mysql -u root -p
//修改MySQL数据库root用户密码
alter USER 'root'@'localhost' IDENTIFIED BY 'nitdDHpassword6***';
//授权远程登录
show databases;
use mysql;
select host, user, authentication_string, plugin from user;
update user set host = "%" where user='root';
select host, user, authentication_string, plugin from user;
flush privileges;

4、使用工具连接数据库;

  • toad

  • navicat

  • dbeaver


欢迎关注公众号收藏小程序

河洛先生河洛先生