64targz下载

矫情吗；* 2023-09-25 10:36 20阅读 0赞

## 如何在linux下安装mysql ##

第一步：安装：

tarmysql-5.5.48-linux2.-x86\_64.tar.gz

Copy到指定的路径下：

cpmysql-5.5.48-linux2.6-x86\_64/usr/local/mysql-r

添加系统mysql组合mysql用户：

执行命令：groupaddmysql和useradd-r-gmysqlmysql

安装数据库：

进入安装mysql软件目录：执行命令cd/usr/local/mysql

修改当前目录拥有者为mysql用户：执行命令chown-Rmysql:mysql./

安装数据库：执行命令./scripts/mysql\_install\_db--user=mysql

修改当前目录拥有者为root用户：执行命令chown-Rroot:root./

修改当前data目录拥有者为mysql用户：执行命令chown-Rmysql:mysqldata

到此数据库安装完毕

启动mysql服务和添加开机启动mysql服务：

添加开机启动：执行命令cpsupport-files/mysql.server/etc/init.d/mysql，把启动脚本放到开机初始化目录

启动mysql服务：执行命令servicemysqlstart

本回答由提问者推荐

![mysql-5.5.32-linux2.6-x86\_64.tar.gz下载][mysql-5.5.32-linux2.6-x86_64.tar.gz]

## linux下mysql解压后怎么安装 ##

shell>groupaddmysql

shell>useradd-r-gmysqlmysql

shell>cd/usr/local

shell>tarzxvfmysql-5.5.32-linux2.6-x86\_64.tar.gz

shell>mvmysql-5.5.32-linux2.6-x86\_64/usr/local/mysql3309

shell>cd/usr/local/mysql3309

shell>chown-Rmysql.

shell>chgrp-Rmysql.

shell>catmy3309.cnf

\#/usr/local/mysql3309下新建my3309.cnf配置文件，内容复制my3308.cnf

shell>mkdir/usr/local/mysql3309/logs

shell>mkdir/usr/local/mysql3309/bin-log

shell>chown-Rmysql.mysql.

shell>scripts/mysql\_install\_db--user=mysql--defaults-file=/usr/local/mysql3309/my3309.cnf

\-----------------------my3309.cnf内容--------------------------------------

\[client\]

\#password=your\_password

port=3307

socket=/tmp/mysql3307.sock

\[mysql\]

socket=/tmp/mysql3307.sock

\#TheMySQLserver

\[mysqld\]

port=3309

socket=/tmp/mysql3307.sock

basedir=/usr/local/mysql3307

datadir=/usr/local/mysql3307/data

skip-external-locking

skip-host-cache

skip-name-resolve

max\_connection=1000

key\_buffer\_size=600M

max\_allowed\_packet=10M

table\_open\_cache=1024

sort\_buffer\_size=6M

read\_buffer\_size=6M

read\_rnd\_buffer\_size=8M

myisam\_sort\_buffer\_size=64M

thread\_cache\_size=64

query\_cache\_size=32M

\#TrynumberofCPU's\*2forthread\_concurrency

thread\_concurrency=8

log-error=/usr/local/mysql3307/logs/mysqld3307.log

server-id=1

log\_slave\_updates=1

auto\_increment\_increment=2

auto\_increment\_offset=2

read-only

log\_bin=/usr/local/mysql3307/binlog/mysql-bin.log

\#log-bin-index=mysql-bin.index

max\_binlog\_size=1G

max\_relay\_log\_size=1G

expire\_logs\_days=30\#超过30天的binlog删除

replicate-do-db=test\#只复制某个库

replicate-do-db=fab

replicate-do-db=fat

replicate-do-db=thca

replicate-do-db=fab\_innodb

replicate-ignore-db=mysql\#不复制某个库

(启动mysql)

shell>bin/mysqld\_safe--defaults-file=/usr/local/mysql3309/my3309.cnf--user=mysql>/dev/null2>&1&

(进入mysql)

shell>bin/mysql--defaults-file=/usr/local/mysql3309/my3309.cnf

无法启动或进入：

查看日志shell>tail-f/usr/local/mysql3309/logs/mysql3309.log

解压缩版的mysql可直接运行，执行时需指定my.cnf文件

注意添加--defaults-file=/usr/local/my3309.cnf命令

由于在my.cnf文件中指定了mysql.sock的位置，为了避免多个mysql同时读取/tmp/mysql.sock文件，在启动时指定读取的sock文件位置：--socket=/tmp/mysql3307.sock

本回答由网友推荐

## LINEX 下安装MYSQL ##

![mysql-5.5.32-linux2.6-x86\_64.tar.gz下载][mysql-5.5.32-linux2.6-x86_64.tar.gz 1]

## LINEX 下安装MYSQL ##

[mysql-5.5.32-linux2.6-x86_64.tar.gz]: https://img0.baidu.com/it/u=395623401,369954202&fm=15&fmt=auto
[mysql-5.5.32-linux2.6-x86_64.tar.gz 1]: https://img1.baidu.com/it/u=3664644767,3070871130&fm=26&fmt=auto

64targz下载

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 64targz

相关 64targz下载

相关 64下载地址

相关 centos aarch64（arm64） iso 下载网址

相关 linux的tomcat下载,tomcat linux 64位下载

相关 mingw64官方下载地址

相关 2021 下载安装 Mingw-w64

相关 win7 64位系统下载

相关 base64文件下载

相关 qemu for win64 下载