centos安装mysql7
ZeranZeran -删除mysql相关的依赖查询已安装的rpm包
rpm -qa | grep mysql
若查询有结果,需删除rpm -e --nodeps mysql-libs-xxx
删除相关mysql目录并删除查询mysql目录find / -name mysql
查询mysql命令whereis mysql
下载mysql二进制包进入/user/local/src/cd /user/local/src/
下载mysqlwget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
解压tar -zxvf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
构建mysql目录创建mysql BaseDirmkdir -p /usr/local/mysql/data
移动mysql文件至BaseDirmv mysql-5.7.37-linux-glibc2.12-x86_64/* /usr/local/mysql/
初始化mysql用户创建mysql用户、创建用户组并将mysql加入mysql用户组groupadd mysql
useradd -r -g mysql mysql
改变mysql目录所属组和所属用户chown -R mysql:mysql /usr/local/mysql
赋予mysql用户及用户组对mysql目录对最大访问权限chmod +775 /usr/local/mysql
安装mysql初始化mysql,需要保存以下命令输出后的最后一段的临时密码,至关重要!sh /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
启动mysql/usr/local/mysql/support-files/mysql.server start
添加软连接,并重启mysql服务ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
service mysql restart
登陆mysqlmysql -u root -p 刚刚的保存的临时密码
输入以下sql语句,修改root用户密码ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
远程访问use mysql;
update user set user.Host='%' where user.User='root';
允许root用户在任何地方进行远程登录,并具有所有库任何操作权限GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新权限FLUSH PRIVILEGES;
设置mysql系统服务复制mysql服务并赋予执行权限cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
添加mysql系统服务chkconfig --add mysqld
特别申明:本文内容来源网络,版权归原作者所有,如有侵权请立即与我们联系(cy198701067573@163.com),我们将及时处理。