Linux安装Mysql

1. 下载安装文件
# wget https://downloads.mysql.com/archives/get/file/mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

2. 解压安装文件
# tar -zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

3. 移动安装文件到指定目录
# mv mysql-5.6.40-linux-glibc2.12-x86_64/ /usr/local/mysql

4. 进入安装目录
# cd /usr/local/mysql

5. 创建mysql用户组及用户
# groupadd mysql
# useradd -r -g mysql mysql

6. 执行添加MySQL配置的操作
# cp support-files/my-default.cnf /etc/my.cnf

7. 编辑/etc/my.cnf文件
# vi /etc/my.cnf

8. 编辑以下内容
......
# These are commonly set, remove the # and set as required.
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
# server_id = .....
socket = /tmp/mysql.sock
character-set-server = utf8
skip-name-resolve
log-err = /usr/local/mysql/data/error.log
pid-file = /usr/local/mysql/data/mysql.pid
......

9. 在mysql当前目录下设定目录的访问权限
# chown -R mysql .
# chgrp -R mysql .
# scripts/mysql_install_db --user=mysql
# chown -R root .
# chown -R mysql data

10. 初始化数据库
# cd /usr/local/mysql/scripts
# ./mysql_install_db --verbose --user=root --defaults-file=/etc/my.cnf --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql --pid-file=/usr/local/mysql/data/mysql.pid --tmpdir=/tmp

11. 启动mysql
# cd /usr/local/mysql/bin
# ./mysqld_safe --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root &

12. 设置开机启动，在新的console窗口输入
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
# cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql
# chmod 700 /etc/init.d/mysql
# chkconfig --add mysqld
# chkconfig --level 2345 mysqld on
# chown mysql:mysql -R /usr/local/mysql/

13. 重启并查看mysql状态
# reboot
# service mysqld status

14. 添加远程访问权限
# ln  -s /usr/local/mysql/bin/mysql  /usr/bin
# mysql -uroot -p 
密码为空，直接按回车键，之后输入以下mysql命令
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpwd' with grant option;
> Flush privileges;
> exit
重启Linux
# reboot