当前位置: 首页 > Linux

centos安装mysql7

时间:2023-04-06 12:01:18 Linux

删除mysql相关依赖查询安装的rpm包rpm-qa|grepmysql如果查询有结果,需要删除rpm-e--nodepsmysql-libs-xxx删除相关mysql目录,删除查询mysql目录find/-namemysqlquerymysql命令whereismysql下载mysql二进制包enter/user/local/src/cd/user/local/src/下载mysqlwgethttps://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.37-linux-glibc2.12-x86_64.tar。gz解压tar-zxvfmysql-5.7.37-linux-glibc2.12-x86_64.tar.gzbuildmysql目录createmysqlBaseDirmkdir-p/usr/local/mysql/datamovemysqlFiletoBaseDirmvmysql-5.7.37-linux-glibc2.12-x86_64/*/usr/local/mysql/初始化mysql用户创建mysql用户,创建用户组并将mysql加入mysql用户组groupaddmysqluseradd-r-gmysqlmysql更改mysql目录chown的组和用户-Rmysql:mysql/usr/local/mysql给mysql用户和用户组最大访问mysql目录的权限chmod+775/usr/local/mysqlInstallmysql初始化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.serverstart添加软连接,并重启mysql服务ln-s/usr/local/mysql/support-files/mysql.server/etc/init.d/mysqlln-s/usr/local/mysql/bin/mysql/usr/bin/mysqlservicemysqlrestartlogintomysqlmysql-uroot-p保存临时密码即可,输入以下sql语句修改root用户密码ALTERUSER'root'@'localhost'由'123456'密码永不过期标识;远程访问使用mysql;更新用户集user.Host='%'whereuser.User='root';允许root用户在任何地方远程登录并拥有所有库任何操作权限GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'123456'WITHGRANTOPTION;刷新权限FLUSHPRIVILEGES;setmysqlsystemservice复制mysql服务并授予执行权限cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysqldchmod+x/etc/init.d/mysqldaddmysqlsystemservicechkconfig--添加mysqld