您的位置 首页 centos

Centos如何安装mysql5.7

1、下载mysql

#进入local目录cd /usr/local/#下载mysqlwget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

2、解压mysql修改名称

tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gzmv mysql-5.7.17-linux-glibc2.5-x86_64 mysqlmkdir data

3、添加用户和组

groupadd mysqluseradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysqlchown -R mysql.mysql /usr/local/mysql/

4、安装命令

yum -y install libaio-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/mysqld

5、修改配置文件

#打开配置目录vi /etc/my.cnf#增加目录配置basedir=/usr/local/mysql/datadir=/usr/local/mysql/data

6、启动,修改root密码,添加远程连接用户权限

#修改环境变量配置文件vi /etc/profile#增加mysql全局变量,使service mysqld start可以在任意位置使用export PATH=$PATH:/usr/local/mysql/bin#即时生效source /etc/profile#启动mysqlservice mysqld start
#mysql刚安装完毕没有密码进入mysql命令行mysql -uroot -p#查询mysql用户select User, Host, Password FROM mysql.user;#修改root密码update mysql.user set password=password('root') where User="root";#为root添加远程权限grant all privileges on *.* to 'root'@'%'identified by 'root' with grant option;#刷新权限flush privileges;

文章来源:智云一二三科技

文章标题:Centos如何安装mysql5.7

文章地址:https://www.zhihuclub.com/9388.shtml

关于作者: 智云科技

热门文章

网站地图