知识星球

主题

[mysqld]
###端口号
port=3308

###安装目录
basedir=/usr/local/mysql-slave/

###数据存放路径
datadir=/usr/local/mysql-slave/data/

###会话文件目录
socket=/usr/local/mysql-slave/mysql.sock

#允许连接失败的最大次数
max_connect_errors=10

#服务端的字符集编码
character-set-server=utf8

#默认存储引擎
default-storage-engine=INNODB

#默认用户
user=mysql

#开启慢查询
slow_query_log=on

#慢查询日志文件目录
slow_query_log_file=/usr/local/mysql-slave/slow-query.log[client]
###连接服务端使用的端口号
port=3306###会话文件
socket=/usr/local/mysql-slave/mysql.sock
#默认字符集编码
default-character-set=utf8---------------文件内容结束--------------------
#在上面的配置中可以看到datadir项中存在data文件夹，而mysql-slave下并没有，
[mysqld]
###端口号
port=3306

###安装目录
basedir=/usr/local/mysql

###数据存放路径
datadir=/usr/local/mysql/data

#服务端的字符集编码
character-set-server=utf8

#默认存储引擎
default-storage-engine=INNODB

pid-file=/usr/local/mysql/data/mysql.pid
#默认用户
user=root

#开启慢查询
slow_query_log=on

#慢查询日志文件目录
slow_query_log_file=/usr/local/mysql/slow-query.log
[client]
###连接服务端使用的端口号
port=3306
###会话文件
socket=/usr/local/mysql/mysql.sock

2021-12-25T12:19:29.331270Z6[Note][MY-010454][Server]Atemporarypasswordisgeneratedforroot@localhost:so+2D4oC?Jxd

#后台启动当前mysql_01的mysql服务，还是需要去指定配置文件，因为在配置文件中我们设置了一个socket参数，``只有按照这个配置文件去启动，才会按照socket配置的路径去生成，否则会自动生成在/tmp/mysql.sock，``如果mysql_02也是这么生成，则会形成覆盖，在连接时造成只能连接一个服务，甚至报错。````./bin/mysqld_safe--defaults-file=./my.cnf&````````#使用命令查看mysql服务是否启动，如下图````netstat-nultp|grep3306

2021-12-25T14:27:14.425695Z6[Note][MY-010454][Server]Atemporarypasswordisgeneratedforroot@localhost:HQ,O-Ss+g7Gs

./bin/mysqld--defaults-file=/usr/local/mysql-slave/my.cnf--initialize--console--user=root

[MY-010454][Server]Atemporarypasswordisgeneratedforroot@localhost:+Ws4;j/x7Hn&

[mysqld]

user=mysql

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

[mysqld_multi]

mysqld=/usr/local/mysql/bin/mysqld_safe

mysqladmin=/usr/local/mysql/bin/mysqladmin

log=/usr/local/mysql/mysqld_multi.log

[mysqld3306]

mysqld=mysqld

mysqladmin=mysqladmin

datadir=/usr/local/mysql/3303/data

port=3306

user=mysql

server_id=3306

socket=/tmp/mysql_3306.sock

log-error=/usr/local/mysql/3306/error_3306.log

[mysqld3307]

mysqld=mysqld

mysqladmin=mysqladmin

datadir=/usr/local/mysql/3307/data

port=3307

user=mysql

server_id=3307

socket=/tmp/mysql_3307.sock

log-error=/usr/local/mysql/3307/error_3307.log

[mysqld3308]

mysqld=mysqld

mysqladmin=mysqladmin

datadir=/usr/local/mysql/3308/data

port=3308

user=mysql

server_id=3308

socket=/tmp/mysql_3308.sock

log-error=/usr/local/mysql/3308/error_3308.log

[mysqld3309]

mysqld=mysqld

mysqladmin=mysqladmin

datadir=/usr/local/mysql/3309/data

port=3309

user=mysql

server_id=3309

socket=/tmp/mysql_3309.sock

log-error=/usr/local/mysql/3309/error_3309.log

mkdir-p/usr/local/mysql/data/

touch/usr/local/mysql/mysqld_multi.log

/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data/3306
[Server]Atemporarypasswordisgeneratedforroot@localhost:aDejokl4D?SR

/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data/3307
[Server]Atemporarypasswordisgeneratedforroot@localhost:tCRo%a-ws4ou

/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data/3308
[Server]Atemporarypasswordisgeneratedforroot@localhost:J2aks,Rjbyan

/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data/3309
[Server]Atemporarypasswordisgeneratedforroot@localhost:X?)%olMhq8:a
sudomysqld_multi--defaults-extra-file=/etc/my.cnf--log=/usr/local/mysql/mysqld_multi.log--user=mysqlstart3306

sudomysqld_multi--defaults-extra-file=/etc/my.cnf --log=/usr/local/mysql/mysqld_multi.log--user=mysql start3307

sudomysqld_multi--defaults-extra-file=/etc/my.cnf --log=/usr/local/mysql/mysqld_multi.log--user=mysql start3308

sudomysqld_multi--defaults-extra-file=/etc/my.cnf --log=/usr/local/mysql/mysqld_multi.log--user=mysql start3309
aliasmysqld=/usr/local/mysql/bin/mysqld
aliasmysqld_multi=/usr/local/mysql/bin/mysqld_multi
aliasmysqladmin=/usr/local/mysql/bin/mysqladmin
sudo/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/3306/data
lhost:u14Yj%2IHMzI

sudo/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/3307/data
root@localhost:?K4?+hOhlwul

sudo/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/3308/data
root@localhost:xdwK!0My9r!a

sudo/usr/local/mysql/bin/mysqld--defaults-file=/etc/my.cnf--initialize--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/3309/data
root@localhost:;X4R3&kkihG*

[mysqld]
###端口号
port=3306
###安装目录
basedir=/usr/local/mysql3306/
###数据存放路径
datadir=/usr/local/mysql3306/data/
###会话文件目录
socket=/usr/local/mysql3306/mysql.sock
#允许连接失败的最大次数
max_connect_errors=10
#服务端的字符集编码
character-set-server=utf8
#默认存储引擎
default-storage-engine=INNODB
#默认用户
user=_mysql
#开启慢查询
slow_query_log=on
#慢查询日志文件目录
slow_query_log_file=/usr/local/mysql3306/slow-query.log
[client]
###连接服务端使用的端口号
port=3306
###会话文件
socket=/usr/local/mysql3306/mysql.sock
[mysqld]
###端口号
port=3307
###安装目录
basedir=/usr/local/mysql3307/
###数据存放路径
datadir=/usr/local/mysql3307/data/
###会话文件目录
socket=/usr/local/mysql3307/mysql.sock
#允许连接失败的最大次数
max_connect_errors=10
#服务端的字符集编码
character-set-server=utf8
#默认存储引擎
default-storage-engine=INNODB
#默认用户
user=_mysql
#开启慢查询
slow_query_log=on
#慢查询日志文件目录
slow_query_log_file=/usr/local/mysql3307/slow-query.log
[client]
###连接服务端使用的端口号
port=3307
###会话文件
socket=/usr/local/mysql3307/mysql.sock
yooome@192 mysql3306 % ./support-files/mysql.server start   
my_print_defaults: [Warning] World-writable config file '/usr/local/mysql3306/my.cnf' is ignored.
./support-files/mysql.server: line 259: cd: /usr/local/mysql: No such file or directory
Starting MySQL
 ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)
yooome@192 mysql3306 % sudo vim ./support-files/mysql.server

sudo ./bin/mysqld --defaults-file=/usr/local/mysql3306/my.cnf --initialize-insecure