mysql中rpm方式安装的详解
查看安装以及卸载
#查看 rpm-qa|grepmysql #卸载 yum-yremovemysql-libs-5.1.66-2.el6_3.x86_64
1.centos7需要先卸载mariadb
查看命令rpm-qa|grepmariadb
安装包资源地址
mysql下载地址:https://dev.mysql.com/downloads/mysql/
#下载资源名称 mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
解压资源
tar-xvfmysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
获取rpm包
mysql-community-common-5.7.19-1.el6.x86_64.rpm mysql-community-client-5.7.19-1.el6.x86_64.rpm mysql-community-server-5.7.19-1.el6.x86_64.rpm mysql-community-libs-5.7.19-1.el6.x86_64.rpm
安装
#安装顺序 #common-->libs-->clients-->server #安装命令 rpm-ivhmysql-community-common-5.7.19-1.el6.x86_64.rpmmysql-community-libs-5.7.19-1.el6.x86_64.rpmmysql-community-client-5.7.19-1.el6.x86_64.rpmmysql-community-server-5.7.19-1.el6.x86_64.rpm
可能需要依赖包libaio
安装命令yum-yinstalllibaio
初始化
mysqld--initialize--user=mysql
启动
servicemysqldstart
登录
#查看初始密码 cat/var/logs/mysql.log #或者 grep'password'/var/logs/mysql.log-n-B5 #登陆 mysql-uroot-p'123456' #修改初始密码 setPASSWORD=PASSWORD('密码');
授权远程链接
###授权192.168.0.1可以远程链接*[所有数据库].*[所有表]账号:root密码123456 grantallprivilegeson*.*to'root'@'192.168.0.1'identifiedby'123456'; ###授权所有ip grantallprivilegeson*.*to'root'@'%'identifiedby'123456'; ###以上*.*表示[数据库].[表] ###使授权立刻生效 flushprivileges;