安装mysql

方法一、安装mysql

1. 下载mysql到目录 /usr/local/src 并解压

2.  wget http://dev.MySQL.com/get/Downloads/MySQL-5.7/mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz
3.  tar -xvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz  

2. 将解压好的mysql放入安装目录下

    mv mysql-5.7.11-linux-glibc2.5-x86_64/ /usr/local/mysql 
    

3. 创建data目录

    mkdir /usr/local/mysql/data  
    

4. 创建mysql用户和修改权限

1.  groupadd mysql     //创建mysql组
2.  useradd -g mysql mysql //创建mysql用户添加到mysql组
3.  chown -R mysql.mysql /usr/local/mysql/  

5. 复制配置文件到 /etc/my.cnf

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf   (选择y)  

6. mysql的服务脚本放到系统服务中

1.  cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld  
2.  chmod +x /etc/init.d/mysqld  

3.  修改my.cnf文件如下:

    # 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  
    
    #explicit_defaults_for_timestamp = 1   //可能会影响创建  /tmp/mysql.sock  文件
    
    character-set-server = utf8  
    # Remove leading # to set options mainly useful for reporting servers.  
    # The server defaults are faster for transactions and fast SELECTs.  
    # Adjust sizes as needed, experiment to find the optimal values.  
    # join_buffer_size = 128M  
    # sort_buffer_size = 2M  
    # read_rnd_buffer_size = 2M 

7. 编辑etc目录下的profile文件

1.  vim /etc/profile
2.  在文件最后处添加
    export PATH=/usr/local/mysql/bin:$PATH

7. 初始化数据(/usr/local/mysql)

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/  --datadir=/usr/local/mysql/data


如果报错--yum install -y libaio
安装后在初始化就OK了

8. 用软链接将mysql添加到 /usr/bin下

ln -s /usr/local/mysql/bin/mysql /usr/bin

9. 启动mysql

service mysqld start   

10. 设置mysql开机自动启动

1.  cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
2.  chmod +x /etc/init.d/mysqld
3.  chkconfig --add mysqld
4.  chkconfig --list    //显示服务列表  如果看到mysql的服务，并且3,4,5都是on的话则成功，如果是off，则键入 chkconfig --level 345 mysql on
    

二、修改mysql密码

1. 停止mysql

service mysqld stop

2. 编辑 /etc/my.cnf的mysql配置文件不需要密码登录

1.  vim /etc/my.cnf
2.  加入
    skip-grant-tables

3. 启动mysql

service mysqld start

4. 进入mysql

mysql -uroot -p     //直接两次回车进入mysql

5. 修改密码

1.  use mysql;
2.  update user set authentication_string=PASSWORD('这里填写密码') where User='root';
3.  flush privileges;       刷新权限
3.  exit;           

6. 在此编辑/etc/my.cnf的mysql配置文件需要密码登录

1.  vim /etc/my.cnf
2.  去掉
    skip-grant-tables

7. 重启mysql

1.  service mysqld stop
2.  service mysqld start

三、设置远程登录权限

1. 登录mysql
2. 修改权限

1.  grant all privileges on *.* to'root' @'%' identified by '密码';
2.  flush privileges;       刷新权限

如果遇到问题 需要在上面执行
alter user user() identified by "123456";