Mysql8 在 Ubuntu22 的安装

------------- Ubuntu22 安装mysql ------------------

1. ubuntun 版本数据库下载

   wget https://cdn.mysql.com/archives/mysql-8.0/mysql-server_8.0.32-1ubuntu22.04_amd64.deb-bundle.tar

   wget https://cdn.mysql.com/archives/mysql-5.7/mysql-server_5.7.41-1ubuntu18.04_amd64.deb-bundle.tar

   

   下载依赖包

   libaio1

   https://pkgs.org/download/libaio1   -- 查看对应的版本信息

   http://archive.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio1_0.3.112-13build1_amd64.deb

   libmecab2

   https://pkgs.org/download/libmecab2 -- 查看对应的版本信息

   http://archive.ubuntu.com/ubuntu/pool/main/m/mecab/libmecab2_0.996-14build14_amd64.deb

---

2. 下载对应的文件包,进行解压

   tar -xvf mysql-server_8.0.32-1ubuntu22.10_amd64.deb-bundle.tar

3. 软件安装顺序   

   sudo dpkg -i mysql-community-client-plugins_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i mysql-community-client-core_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i mysql-common_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i mysql-community-client_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i libmysqlclient21_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i libmysqlclient-dev_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i mysql-client_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i libaio1_0.3.112-13build1_amd64.deb

   sudo dpkg -i libmecab2_0.996-14build14_amd64.deb

   sudo dpkg -i mysql-community-server-core_8.0.32-1ubuntu22.04_amd64.deb

   sudo dpkg -i mysql-community-server_8.0.32-1ubuntu22.04_amd64.deb   # 执行时输入root账户的密码

   sudo dpkg -i mysql-server_8.0.32-1ubuntu22.04_amd64.deb

   

   备注1:   接下来继续安装 执行：sudo dpkg -i mysql-community-server-core_8.0.32-1ubuntu22.04_amd64.deb

           会弹出窗口让你输密码，这个密码就是mysql数据库的root账号的密码;

   备注2:  mysql-server_8.0.32-1ubuntu22.04_amd64.deb 此包安装提示配置文件信息

           update-alternatives: 使用 /etc/mysql/mysql.cnf 来在自动模式中提供 /etc/mysql/my.cnf (my.cnf)

           Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.

   -- 卸载安装包操作(如果要卸载) --

   sudo dpkg --purge mysql-community-client-core

---------- 以下是解压MYSQL 安装文件包时4个测试安装包,忽略不安装 ---------------

   mysql-community-server-debug_8.0.32-1ubuntu22.10_amd64.deb

   mysql-community-test_8.0.32-1ubuntu22.10_amd64.deb

   mysql-community-test-debug_8.0.32-1ubuntu22.10_amd64.deb

   mysql-testsuite_8.0.32-1ubuntu22.10_amd64.deb

---

4. 查看依赖安装包信息

dpkg --list|grep mysql

5. 查看数据库是否正常

mysql -uroot -p密码

6. 重启mysql指令：

   sudo service mysql restart

   6.1无法远程连接Mysql

     # 使用你的用户名、密码登录数据库

       mysql -uroot -pzhenghu;

     # 切换数据库

       use mysql;

     # 更新远程权限

       update user set host = '%' where user = 'root';

       flush privileges;

     #重启mysql

      sudo service mysql restart;

7. 安装配置文件信息

/etc/mysql/mysql.conf.d