Mysql安装
- Linux环境信息
[root@localhost ~]# cat /proc/version Linux version 2.6.32-431.el6.x86_64 (mockbuild@c6b8.bsys.dev.centos.org) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-4) (GCC) ) #1 SMP Fri Nov 22 03:15:09 UTC 2013 [root@localhost ~]# uname -a Linux localhost.localdomain 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux [root@localhost ~]# uname -r 2.6.32-431.el6.x86_64 [root@localhost ~]# lsb_release -a LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch Distributor ID: CentOS Description: CentOS release 6.5 (Final) Release: 6.5 Codename: Final
- 如果之前存在Mysql则删除
[root@localhost ~]# yum list installed | grep mysql [root@localhost ~]# yum -y remove mysql-libs.x86_64 [root@localhost ~]# yum list | grep mysql 或 yum -y list mysql*
- 下载mysql的Yum源下载
[root@localhost ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm [root@localhost ~]# sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
- 安装
[root@localhost ~]# yum -y install mysql-server mysql mysql-devel
- 查看安装的Mysql版本
[root@localhost ~]# yum list installed | grep mysql
- 设置用户和权限
[root@localhost ~]# chgrp -R mysql /var/lib/mysql [root@localhost ~]# chmod -R 770 /var/lib/mysql [root@localhost ~]# service mysqld start
- Mysql设置本地用户和远程用户登录
[root@localhost ~]# mysql $ mysql > use mysql; # mysql 8以下 $ mysql > grant all on *.* to 'root'@'localhost' identified by 'root'; $ mysql > grant all on *.* to 'root'@'%' identified by 'root'; # mysql 8 $ mysql > ALTER USER 'root'@'localhost' identified WITH mysql_native_password by 'iamhero4'; $ mysql > update user set host='%' where user='root'; $ mysql > flush privileges;
- 修改Mysql在linux下大小写不敏感
```bash
[root@localhost ~]#vi /etc/my.cnf
在[mysqld]后添加如下行,0代表大小写敏感,1代表不敏感
lower_case_table_names= 0
/etc/my.cnf.d/
mysql 8.0以后
[root@localhost ~]# cat > /etc/my.cnf.d/my.cnf «EOF [mysqld] lower_case_table_names=2 EOF [root@localhost ~]# service mysqld restart
+ 开放3306端口,修改文件
```bash
[root@localhost ~]#sudo vim /etc/sysconfig/iptables
- 在文件中添加如下行
*filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [0:0] -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT -A INPUT -p icmp -j ACCEPT -A INPUT -i lo -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT -A INPUT -j REJECT --reject-with icmp-host-prohibited -A FORWARD -j REJECT --reject-with icmp-host-prohibited COMMIT
- 重启防火墙
[root@localhost ~]# sudo service iptables restart
- 在Linode上会报错
[root@li254-129 ~]# service iptables restart iptables: Setting chains to policy ACCEPT: security raw nat[FAILED]filter iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] iptables: Applying firewall rules: [ OK ]
-
原因是:Linode官方在iptables里加了一个security的规则链,但是centos不支持。
- 解决办法
#找到如下case段,在raw后面加上security)段,修改后如下。 [root@li254-129 ~]# vim /etc/init.d/iptables for i in $tables; do echo -n "$i " case "$i" in raw) $IPTABLES -t raw -P PREROUTING $policy \ && $IPTABLES -t raw -P OUTPUT $policy \ || let ret+=1 ;; security) $IPTABLES -t filter -P INPUT $policy \ && $IPTABLES -t filter -P OUTPUT $policy \ && $IPTABLES -t filter -P FORWARD $policy \ || let ret+=1 ;;
- 下载安装java
# 下载安装JDK wget http://download.oracle.com/otn-pub/java/jdk/8u77-b03/jdk-8u77-linux-x64.rpm?AuthParam=1458919543_9b2e065bf9d967bdd1b416b3f5935302 rpm -ivh jdk-8u77-linux-x64.rpm # 下载安装TOMCAT wget wget http://mirrors.cnnic.cn/apache/tomcat/tomcat-8/v8.0.32/bin/apache-tomcat-8.0.32.tar.gz
- 配置java路径
[root@localhost ~]# vi /etc/profile export JAVA_HOME=/usr/java/jdk1.6.0_27 export PATH=$PATH:$JAVA_HOME/bin [root@localhost ~]# source /etc/profile
参考资料:
yum安装MySQL并设置密码:http://www.cnblogs.com/xiaochaohuashengmi/archive/2011/10/16/2214272.html
centos7下使用yum安装mysql并创建用户,数据库以及设置远程访问:http://my.oschina.net/fhd/blog/383847