linux 常用命令
� linux 安装 mysql
� 1.创建目录:mkdir /usr/local/mysql
� 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
� mv mysql-5.7.11-linux-glibc2.5-x86_64/* /usr/local/mysql/
� 4.创建 data 目录:mkdir /usr/local/mysql/data
� 5.创建 mysql 用户并添加权限
� groupadd mysql
� useradd -r -g mysql mysql
� chown -R mysql.mysql /usr/local/mysql/
� 6.复制配置文件到 /etc/my.cnf
� cp -a ./support-files/my-default.cnf /etc/my.cnf (选择 y)
� 7.mysql 的服务脚本放到系统服务中
� cp -a ./support-files/mysql.server /etc/init.d/mysqld
� 8.修改 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
� 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
评论