mysql 安装

1，获取mysql

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

2. tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

3. cp -R mysql-5.6.33-linux-glibc2.5-x86_64/* /usr/local/mysql

4. 检查是否有mysql用户

groups mysql

5. 没有添加用户

groupadd mysql

useradd -r -g mysql mysql

6.cd /usr/local

chown -R mysql:mysql mysql

7.将ip和主机名写入hosts文件

vim /etc/hosts

172.31.30.25  master

8.安装mysql

cd /usr/local/mysql/scripts/

./mysql_install_db ‐‐basedir=/usr/local/mysql ‐‐datadir=/usr/local/mysql/data ‐‐user=mysql ‐‐explicit_defaults_for_timestamp

9，如果提示

yum -y install autoconf

10.启动mysql

./support-files/mysql.server

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

chkconfig --add mysqld

service mysqld restart

service mysqld status

12. 编辑配置文件

vim my.cnf

添加

character_set_server=utf8
lower_case_table_names=1
max_allowed_packet=100M

13.service mysqld restart

14,。修改密码

/usr/local/mysql/bin/mysqladmin -u root password 'new-passwd'

 /usr/local/mysql/bin/mysqladmin -u root -h master password 'new-passwd'

 15,windows链接会提示失败

关闭防火墙
service iptables stop
进入本地执行命令
grant all privileges on *.* to root@'%' identified by 'root';