下载安装下载64位安装包,安装目录为/usr/mysql解压tar -zxf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz重命名解压文件夹并删除安装包mv mysql-5.6.33-linux-glibc2.5-x86_64 mysqlrm -rf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz添加用户组groupadd mysql添加用户mysql 到用户组mysqluseradd -g mysql mysql
安装cd /usr/mysql/mkdir ./data/mysqlchown -R mysql:mysql /usr/mysql/yum -y install autoconf 或者 yum -yinstall perl perl-develyum install libaio* 或者 yum -yinstall libaio-devel./scripts/mysql_install_db --user=mysql--datadir=/usr/mysql/data/mysqlcp support-files/mysql.server/etc/init.d/mysqldchmod 755 /etc/init.d/mysqldcp support-files/my-default.cnf /etc/my.cnf
修改启动脚本vim /etc/init.d/mysqldbasedir=/usr/mysql/datadir=/usr/mysql/data/mysql启动服务service mysqld start测试连接./mysql/bin/mysql -uroot基本设置添加环境变量vim /etc/profileexportPATH=$PATH:/usr/local/mysql//binsource /etc/profilesource /etc/profile设置开启启动systemctl is-enabled mysqldsystemctl enable mysqldsystemctl stop mysqldsystemctl start mysqldsystemctl status mysqld启动mysqlservice mysqld start关闭mysqlservice mysqld stop
查看运行状态service mysqld status修改root密码,默认为空mysql -uroot -pmysql>use mysql;mysql> update user setpassword=passworD('test') where user='root';mysql> flush privileges;mysql> exit;开启远程访问权限mysql>use mysql;mysql> GRANT ALL PRIVILEGES ON *.* TO'youruser'@'%'IDENTIFIED BY 'yourpwd' WITH GRANT OPTION;mysql> flush privileges;mysql>exit;ps:防火墙请手动关闭,或设置防火墙对3306端口放行
以上是在CentOS7环境中搭建MySQL数据的,仅供参考。
centos搭建linux+apache+mysql+php教程:raksmart.idcspy.com/161