- 安装前先卸载
[root@slave local]# yum remove mysql mysql-server mysql-libs compat-mysql51
- 下载tar.gz包
- 解压tar包
[root@slave local]# tar zxvf mysql5620.tar.gz
- 新建mysql目录
- -
[root@slave local]# mkdir -p /usr/local/mysql
- 移动解压文件到/usr/local/mysql/
[root@slave local]# mv mysql-5.6.20-linux-glibc2.5-x86_64/* /usr/local/mysql/
- 进入/usr/local/mysql/目录
[root@slave local]# cd /usr/local/mysql/
- 初始化数据库
[root@slave mysql]# /usr/local/mysql/scripts/mysql_install_db
--user=root --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data - 添加开机自启动服务
[root@slave mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@slave mysql]# chkconfig --add mysqld
[root@slave mysql]# chkconfig --level 2345 mysqld on
启动mysql
[root@slave mysql]# service mysqld start
如果出现Starting MySQL. ERROR! The server quit without updating PID file
(/usr/local/mysql/data/pmServer.pid).
编辑/etc/init.d/mysqld,找到start模块,添加–user=root到mysqld_safe。。。后面就可以
[root@slave mysql]# vim /etc/init.d/mysql
file. This script # may be overwritten at next upgrade. $bindir/mysqld_safe --user=root --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 & wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?
增加mysql快速访问链接路径
[root@slave mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin
登录mysql
[root@slave mysql]# mysql -uroot
进入后修改登录密码并授权远程登录
mysql> grant all privileges on *.* to 'root'@'%' identified by
'123456' with grant option;
mysql> update mysql.user set password=PASSWORD('123456') where
user='root';
mysql> flush privileges;
退出重新用密码登录
mysql> \q
[root@slave local]# mysql -uroot -p Enter password:
输入密码123456既可登录成功。开始防火墙监听端口3306
[root@slave mysql]# /sbin/iptables -I INPUT -p tcp --dport
3306-j ACCEPT
[root@slave mysql]# /etc/rc.d/init.d/iptables save
[root@slave mysql]# /etc/init.d/iptables restart