安装及配置mysql

1.安装&配置

0.卸载旧版
    yum list installed | grep mysql
    yum remove mysql-libs.i686
1.去官网找到最新rpm并下载
    https://dev.mysql.com/downloads/repo/yum/
    wget https://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm
2.安装rpm
    yum install mysql80-community-release-el6-3.noarch.rpm
3.安装mysql
    yum install mysql-community-server
4.找到初始密码并启动mysql
    grep "password" /var/log/mysqld.log
    service mysqld start
5.修改初始密码
    ALTER USER USER() IDENTIFIED BY 'newpassword'

    

2.一些命令

1.查看日志
    less /var/log/mysqld.log
2.编辑配置文件
    vi /etc/my.cnf
3.设置开机启动
    chkconfig --list | grep mysqld
    chkconfig mysqld on
4.增加swap分区大小
    dd if=/dev/zero of=/var/swap bs=1M count=1024
    mkswap /var/swap
    swapon /var/swap