greatsql 用啥连接工具连接greatsql
2007-Protocol mismatch; server version = 11, client version = 10连接不上怎么解决的，怎么使用navcat 连接他贵公司有专门使用的连接工具吗
使用 Navicat 连接即可,注意端口号设置好即可连接 KAiTO 发表于 2022-12-29 14:55
使用 Navicat 连接即可,注意端口号设置好即可连接
# ss -lntp | grep mysqld
LISTEN 0 70 [::]:33060 [::]:* users:(("mysqld",pid=1333,fd=22))
LISTEN 0 128 [::]:3306 [::]:* users:(("mysqld",pid=1333,fd=24))
18435152355 发表于 2022-12-29 15:01
# ss -lntp | grep mysqld
LISTEN 0 70 [::]:33060 ...
没有弄错呀33060
my.cnf/my.ini 文件发出来看看 vatebur 发表于 2022-12-29 15:07
my.cnf/my.ini 文件发出来看看
# Percona Server template configuration
#
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
#
# 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
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# 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
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
18435152355 发表于 2022-12-29 15:16
# Percona Server template configuration
#
# For advice on how to change settings please see
如果配置文件没指定端口默认应该是3306端口吧，你端口是不是用错了
端口用错了，配置文件没指定端口，默认使用3306端口。
顺带一提，如果要把数据库给其他设备连要改host，把root@'localhost' 改成 root@'%' 18435152355 发表于 2022-12-29 15:16
# Percona Server template configuration
#
# For advice on how to change settings please see
https://blog.csdn.net/yeyuningzi/article/details/120509321
使用端口号3306 需要使其可以支持远程连接
页:
[1]