Linux安装mysql

卸载mysql

mysqladmin --version:查看数据库版本
​
rpm -qa  | grep -i mysql:-i忽略大小写 查看mysqr安装包
​
systemctl status mysqld.Service:查看my
​
MySql的卸载
1.关闭mysql服务器
systemctl stop mysqld.service
2.查看当前mysql安装状况
rpm -qa | grep -i mysql  或
yum list installed | grep mysql
3.卸载上述命令查询出的已安装程序
yum remove mysql-xxx-mysql-xxx mysql-xxx mysqk-xxxx
​
4.查找mysql文件路径：
find / -name mysql
5.删除文件： rm -rf xxx
6.删除mysql配置文件：
rm -rf /etc/my.cnf

安装mysql

1.检查/tmp临时目录权限(必不可少)
chmod -R 777 /tmp
2.安装前，检查依赖
rpm -qa | grep libaio
pm -qa | grep net-tools
​
3.下载安装
rpm -ivh mysql-community-common-8.0.25-1.el7.x86_64.rpm
​
rpm -ivh mysql-community-client-plugins-8.0.25-1.el7.x86_64.rpm
​
rpm -ivh mysql-community-libs-8.0.25-1.el7.x86_64.rpm 
此时会报错：需要执行命令
yum remove mysql-libs
rpm -ivh mysql-community-libs-8.0.25-1.el7.x86_64.rpm 
​
rpm -ivh mysql-community-client-8.0.25-1.el7.x86_64.rpm 
​
rpm -ivh mysql-community-server-8.0.25-1.el7.x86_64.rpm 
​
3.查看安装的Mysql的版本号
mysqladmin --version
​
4.服务的初始化
 mysqld --initialize --user=mysql
​
5.查看mysql密码：
cat /var/log/mysqld.log
​
6.启动服务：
systemctl start mysqld
​
7.查看mysql是否自启动
systemctl list-unit-files | grep mysqld.service
如果不是开机自启动
systemctl enable mysqld.service
​
8.登录mysql
mysql -uroot -p
9.修改mysql密码：
alter user 'root'@localhost identified by '新密码'
​
​
​

SQLYong连接数据库

1.关闭windows和linus防火墙
2.设置mysql权限，默认不支持外部连接
update user set host = '192.168.234.10' where user = 'root';
3.刷新权限
flush privileges;
4，mysql8需要重新设置密码
ALTER USER 'root'@'192.168.234.10' IDENTIFIED WITH mysql_native_password BY 'root'；