目录
1本地安装
更新本地存储库索引:
sudo apt update
安装MySQL:
sudo apt install mysql-server -y
查看版本
mysql -V
查看mysql是否安装成功:
netstat -tap | grep mysql
状态为LISTEN即代表安装成功
安装后mysql为自启动
查看mysql是否运行:
systemctl status mysql
也可通过以下命令启停mysql
启动mysql:
sudo services start mysql
或
systemctl start mysql
关闭mysql:
sudo services stop mysql
或
systemctl stop mysql
进入mysql,默认无密码
sudo mysql
使用数据库
use mysql
查看数据
select host,user from user;
改为可从任何主机访问数据库
update user set host='%' where user='root';
修改密码:
ALTER USER 'root'@'%' IDENTIFIED BY '123';
使用新设置的密码登录
mysql -u root -p
使用exit;退出
2本地安装卸载
使用 apt-get 命令卸载 MySQL:
sudo apt-get remove --purge mysql-server mysql-client mysql-common
删除 MySQL 的配置文件和数据:
sudo rm -rf /etc/mysql/ /var/lib/mysql/
移除 MySQL 相关的依赖:
sudo apt-get autoremove
删除残留文件和目录:
sudo find / -iname 'mysql*' -exec rm -rf {} ;
3离线安装
离线安装指定版本
下载
MySQL :: Download MySQL Community Server (Archived Versions)
创建mysql文件夹
cd /usr/local
sudo mkdir mysql
解压
cd ~/Downloads/
sudo tar -xvf mysql-server_8.0.33-1ubuntu22.04_amd64.deb-bundle.tar -C /usr/local/mysql
下载libaio1和libmecab2包 http://archive.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio1_0.3.112-5_amd64.deb
http://archive.ubuntu.com/ubuntu/pool/main/m/mecab/libmecab2_0.996-10build1_amd64.deb
下载后移动到/usr/local/mysql目录
cd ~/Download
sudo mv lib* /usr/local/mysql
按以下顺序安装.deb安装包
cd /usr/local/mysql
sudo dpkg -i mysql-community-client-plugins_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-client-core_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-common_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-client_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i libmysqlclient21_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-client_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i libaio1_0.3.112-5_amd64.deb
sudo dpkg -i libmecab2_0.996-10build1_amd64.deb
sudo dpkg -i mysql-community-server-core_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-server_8.0.33-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-server_8.0.33-1ubuntu22.04_amd64.deb
安装mysql-community-server_8.0.33-1ubuntu22.04_amd64.deb需要设置root密码
重启MySQL
sudo service mysql restart
使用刚刚设置的密码登录
mysql -u root -p
使用exit;命令即可退出