ubuntu mysql 修改 端口_MYSQL8.0 ubuntu/debian 安装及修改端口

vi /etc/mysql/mysql.conf.d/mysqld.cnf

# For explanations see

# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]

pid-file = /var/run/mysqld/mysqld.pid

socket = /var/run/mysqld/mysqld.sock

datadir = /var/lib/mysql

log-error = /var/log/mysql/error.log

在末行添加 port = 3310

然后重启服务

service mysql restart

登录

mysql -u root -p

查表，看端口是否修改完成

mysql> show global variables like 'port';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| port          | 3310  |

+---------------+-------+

1 row in set (0.01 sec)

mysql> use mysql;

修改权限表策略，让root用户的host不受限

mysql> update user set host='%' where user = 'root';

刷新权限缓存

mysql> flush privileges;

JDBC 连接 mysql8

驱动 com.mysql.cj.jdbc.Driver

jdbc:mysql://yourhost:3310/test?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC