greatsql 用啥连接工具连接greatsql

使用 Navicat 连接即可,注意端口号设置好即可连接

KAiTO 发表于 2022-12-29 14:55
使用 Navicat 连接即可,注意端口号设置好即可连接

[root@localhost ~]# 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
[root@localhost ~]# 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/ ... ation-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
#
# 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 ... thentication_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 需要使其可以支持远程连接