mysql安装

mysql5.6.34

关闭防火墙命令：

service iptables stop[stop|start|restart]

查看环境变量：

echo $PATH

1. 新建mysql用户

   groupadd -r mysql
   useradd -r -g mysql -s /sbin/nologin mysql

2. 解决依赖

   yum install perl
   yum install libaio

3. 解压 安装

   tar -zxvf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz
   mv mysql-5.6.34-linux-glibc2.5-x86_64 /usr/local/mysql

   cd /usr/local/mysql
   chown -R mysql:mysql ./

   ./scripts/mysql_install_db --user=mysql

   chown -R root:root ./
   chown -R mysql:mysql data

4. 启动mysql服务

   cp support-files/mysql.server /etc/init.d/mysql

5. 修改mysql的root用户密码，root初始密码为空的

   ./bin/mysqladmin -u root password '密码'

注：如果报错 Can't connect to local MySQL server through socket '/tmp/mysql.sock'

找下mysql.sock位置：

find / -name mysql.sock

结果：/var/lib/mysql/

   ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

6. 添加环境变量

   export PATH=$PATH:/usr/local/mysql/bin

默认密码： 123456

7. 修改密码

   use mysql;
   UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
   FLUSH PRIVILEGES;

8. 权限

   GRANT ALL PRIVILEGES ON fz_cms.* TO 'cms'@'%' IDENTIFIED BY 'cmsfz';
   GRANT ALL PRIVILEGES ON fz_jhxt.* TO 'cms'@'%' IDENTIFIED BY 'cmsfz';
   FLUSH PRIVILEGES;

9. 配置自启动

   chkconfig --add mysql
   chkconfig mysql on