mysql 配置多个端口_一台服务器装多个mysql....多端口

最新推荐文章于 2024-07-30 04:00:13 发布

栖渔

最新推荐文章于 2024-07-30 04:00:13 发布

阅读量222

点赞数

文章标签： mysql 配置多个端口

本文链接：https://blog.csdn.net/weixin_32989877/article/details/113301803

版权

本文介绍了如何在一台服务器上安装MySQL并配置两个不同端口（3306和3307）运行。首先通过yum安装必要的依赖，然后下载并安装Percona Server。接着创建相应的目录，调整权限，并复制my.cnf文件进行端口配置。最后，使用mysqld_safe启动不同端口的数据库服务。

摘要由CSDN通过智能技术生成

1、安装mysql

wgetPercona-Server-5.5.27-28.1/RPM/rhel6/i686/

yum install cmake bison ncurses-devel gcc-c++

#rpm -ivh --nodeps --force Percona-Server-55-debuginfo-5.5.24-rel26.0.256.rhel6.x86_64.rpmPercona-Server-server-55-5.5.24-rel26.0.256.rhel6.x86_64.rpm

Percona-Server-client-55-5.5.24-rel26.0.256.rhel6.x86_64.rpmPercona-Server-shared-55-5.5.24-rel26.0.256.rhel6.x86_64.rpm

Percona-Server-devel-55-5.5.24-rel26.0.256.rhel6.x86_64.rpm 忽略报错2、创建mysql目录 /home/mysql启动3306端口 /usr/local/mysql启动3307端口(1)、#mkdir -p /home/mysql/{data,logs}#chown mysql:mysql /home/mysql/ -R(2)、#mkdir -p /usr/local/mysql/{data,logs，etc，var}#chown mysql:mysql /usr/local/mysql/ -R 安装mysql数据库系统表#cp /etc/my.cnf /usr/local/mysql/etc/my.cnf

#vi /user/local/mysql/etc/my.cnf

[client]

port = 3307

socket = /usr/local/mysql/var/mysql.sock

[mysqld]

port = 3306

socket = /var/lib/mysql/mysql-3307.sock

datadir = /usr/local/mysql/data

log_error = /usr/local/mysql/logs/db_error.log

#/usr/bin/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/ --datadir=/home/mysql/data --user=mysql#/usr/bin/mysql_install_db --defaults-file=/usr/local/mysql/etc/my.cnf --basedir=/usr/ --datadir=/usr/local/mysql/data --user=mysql

#chown mysql:mysql /home/mysql/data/ -R

3、启动数据库

/usr/bin/mysqld_safe --defaults-file=/etc/my.cnf &/usr/bin/mysqld_safe --defaults-file=/usr/local/mysql/etc/my.cnf &