当前位置: 首页 > Linux

Centos安装mysql5.7

时间:2023-04-07 03:12:44 Linux

为了方便快捷的搭建linux环境,我有了这几篇文字。CentOS使用yum安装jdkCentOS安装tomcat/dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz2。解压mysql,修改名称tar-zxvfmysql-5.7.17-linux-glibc2。5-x86_64.tar.gzmvmysql-5.7.17-linux-glibc2.5-x86_64mysqlmkdirdata3。添加用户和组groupaddmysqluseradd-r-s/sbin/nologin-gmysqlmysql-d/usr/local/mysqlchown-Rmysql.mysql/usr/local/mysql/4安装命令yum-yinstalllibaio-devel./bin/mysql_install_db--user=mysql--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data/cp-a./support-files/my-default.cnf/etc/my.cnfcp-a./support-files/mysql.server/etc/init.d/mysqld5.修改配置文件#打开配置目录vi/etc/my.cnf#增加目录配置basedir=/usr/local/mysql/datadir=/usr/local/mysql/data6.启动,修改root密码,添加远程连接用户权限#修改环境变量配置文件vi/etc/profile#增加mysql全局变量,使servicemysqldstart可以在任何地方使用exportPATH=$PATH:/usr/local/mysql/bin#立即生效source/etc/profile#startmysqlservicemysqldstart7。如果安装位置不在/usr/local/mysql下,比如在/home/mysql下添加软链接mkdir-p/usr/local/mysql/binln-s/home/mysql/bin/mysqld/usr/local/mysql/bin/mysqld#先添加忽略密码模式vi/etc/my.cnfskip-grant-tables#更改密码更新mysql.usersetauthentication_string=password("mengdong#123")whereuser='root'SETPASSWORD=PASSWORD('mengdong#123');#改回忽略密码模式#更改密码,添加远程连接用户#刚刚安装mysql,没有密码进入mysql命令行mysql-uroot-p#查询mysqluserselectUser,Host,PasswordFROMmysql.user;#Modifyrootpasswordupdatemysql.usersetpassword=password('root')whereUser="root";#为root添加远程权限grantallprivilegeson*.*to'root'@'%'由具有授予选项的'root'标识;#refreshpermissionsflushprivileges;