MYSQL8.0 ubuntu/debian 安装及修改端口
安装
sudo apt update
sudo apt install mysql-server
然后就会提示你为mysql设置root用户密码了
---------------------------------------------------------------------------------
查看服务状态
sudo service mysql status
默认打开自启动
禁用自启动时现在 disabled
停止/开启/重启
sudo service mysql stop/start/restart
开启/关闭开机自启
systemctl enable/disable mysqld
查看是否自启状态
systemctl list-unit-files | grep mysqld
试登录一下
mysql -uroot -p
可以下载MySQL的图形界面客户端
https://dev.mysql.com/downloads/workbench/
修改端口
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> use mysql;
mysql> update user set host='192.168.%' where user = 'root'; 或 mysql> update user set host='%' where user = 'root';
刷新权限缓存
mysql> flush privileges;
我的mysql装在了虚拟机Ubuntu上，并配置了NAT和桥接两个虚拟网卡
然后在 Windows 用 MySQL Workbench 连接 虚拟机上的 MySQL
JDBC 连接 mysql8
驱动 com.mysql.cj.jdbc.Driver 下载地址：https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.22.zip
jdbc:mysql://yourhost:3310/database?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
指定不使用SSL，时区设东8区
至于使用ＳＳＬ的方法见：https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
依赖Maven/Gradle
https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.22
附上PGSQL的安装：
1. PostgreSQL: Linux downloads (Ubuntu)
2. 修改密码
$ sudo -u postgres psql
psql (15.3 (Ubuntu 15.3-1.pgdg18.04+1), server 10.23 (Ubuntu 10.23-0ubuntu0.18.04.2))
Type "help" for help.
postgres=# ALTER USER postgres WITH PASSWORD '123';
ALTER ROLE
postgres=# \q
