linux mysql install

最新推荐文章于 2024-09-25 14:34:16 发布

戏剧

最新推荐文章于 2024-09-25 14:34:16 发布

阅读量340

点赞数

分类专栏： mysql 文章标签： mysql linux install

本文链接：https://blog.csdn.net/u014312858/article/details/51981721

版权

mysql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

创建mysql用户组

groupadd mysql

创建mysql用户

useradd -r -g mysql mysql

创建mysql datadir数据目录

mkdir /var/mysql/data //数据文件

mkdir /var/mysql/logs //日志保存文件

mkdir /var/mysql/run //运行pid文件

mkdir /var/mysql/tmp //server-sockml

chown -R root:root ./ //设置mysql用户权限

获取 Linux mysql 安装包

wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz

解压mysql安装包

tar -zxvf mysql-5.6.20-linux-glibc2.5-x86_64

移动mysql到安装指定目录

mv -f mysql-5.6.20-linux-glibc2.5-x86_64/* /usr/local/mysql-5.6.20

修改配置文件

vi /my-default.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
innodb_use_sys_malloc = 1 使用系统内存分配机制
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = /usr/local/mysql-5.6.20 安装目录
datadir = /var/mysql/data 数据保存目录
port = 3306 端口
# server_id = .....
socket = /var/mysql/tmp/mysql.sock

[mysqld_safe]
log-error=/var/mysql/logs/mysqld.log
pid-file=/var/mysql/run/mysqld.pid

# 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
#sql_mode=NO_ENGINE_SUBSTITUTION 使用insert添加mysql用户