Centos6.8下安装MySQL5.6

一、下载MySQL

1. cd /usr/local
2. wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
3. tar xvf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
4. mv mysql-5.6.35-linux-glibc2.5-x86_64 /usr/local/mysql

二、创建MySQL用户和组

1. groupadd mysql
2. useradd -r -g mysql mysql -d /usr/local/mysql
3. passwd mysql

三、修改目录权限

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

四、安装数据库

1. su mysql
2. /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
3. exit

五、复制配置文件并添加系统服务

1. cd /usr/local/mysql/support-files
2. cp my-default.cnf /etc/my.cnf
3. cp mysql.server /etc/init.d/mysql
4. chkconfig mysql on

六、配置环境变量

1. vim /etc/profile
2. 在文件末尾加 export MYSQL_HOME="/usr/local/mysql"，export PATH="$PATH:$MYSQL_HOME/bin"
3. 保存退出，然后执行 . /etc/profile

七、启动MySQL

1. service mysql start

八、设置root密码

1.  mysqladmin -u root password '123456'

九、设置默认端口

1. vim /etc/my.cnf
2. [mysqld]
   basedir=/usr/local/mysql
   datadir=/usr/local/mysql/data
   port=3306
   server_id=1
   socket=/tmp/mysql.sock

十、允许外部链接访问

1. mysql -u root -p
2. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
3. FLUSH PRIVILEGES;