ubuntu安装mysql并使用datagrip远程连接

「爱情、让人受尽委屈。」 2024-04-03 12:33 112阅读 0赞

1.安装client

sudo apt-get install mysql-server

2.mysql8默认不开启用户root，默认用户是debian-sys-maint，其默认密码是存在/etc/mysql/debian.cnf

sudo cat /etc/mysql/debian.cnf

每次安装的密码都是随机生成的,所以必须查看:(password那一行对应的就是这个用户的密码)

![1428469d8d0146acb91c17d676dd50de.png][]

3.使用默认用户登录mysql

mysql -u -debian-sys-maint -p

输入password中的内容

4.修改密码

mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';

5.修改完在数据库中刷新权限

flush privileges;

6.重启mysql服务

sudo service mysql restart

7.用root登录

mysql -u root -p

输入修改过的密码123456

## 远程连接mysql ##

主要为两步骤:root的host修改和ip绑定的修改

1.首先进入mysql, 而后查看user和host

select user,host from user;

查询结果为如下图所示:

![ce2fcbaf237f4b139f985039c4e0bbe3.png][]

修改root的host:命令如下:

![33cdf1aef9a5417fb68b27cfff34c6e7.png][]

再次查询root的host值:

![29a6ceabbea34be3ba9922d2bc12466f.png][]

记得刷新:

![42c599ff233346af9f87c2fc82c5ad1f.png][]

2.修改配置文件中的bind

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

将下面这行注释掉

bind-address = 127.0.0.1

重启mysql服务:

sudo service mysql restart

至此虚拟机端的配置结束

开启datagrip侧配置:

点击加号

![e79691d92c8245358e418d31bbde46ee.png][]

![2ea569caf401470cbe7759d0727ce25f.png][]

![b09f60229ac2430693bcab86970c7782.png][]

![f496c10c25f64e889416140380de59c9.png][]

此处的username和password是虚拟机的

![ae7b4852d3814762897ef60db0e6fdbf.png][]

如果在这里连接失败,则需要进行如下配置:

![30664713f5ef4a42be419c5811bd68bc.png][]

"-Djava.security.properties=F:\\javaSoftWare\\.custom.java.security"

然后在对应的F:\\javaSoftWare下建立名为.custom.java.security的文件,文件内容写死为:

jdk.tls.disabledAlgorithms=SSLv3, TLSv1.1, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, include jdk.disabled.namedCurves

然后在进行连接测试~

如果成功连接,那么新多出来的数据库应该是这样的~

![9f2639161d33477abe8fc47d437a94dd.png][]

[1428469d8d0146acb91c17d676dd50de.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/6705b5d0420e4fd4af770836b1bf85e9.png
[ce2fcbaf237f4b139f985039c4e0bbe3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/ae887f79f2984c61b759fad639b12ff1.png
[33cdf1aef9a5417fb68b27cfff34c6e7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/8282dc4b70404180bdc8e4909e935b00.png
[29a6ceabbea34be3ba9922d2bc12466f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/bca9286cfedf4f28b6123936cd8f2a82.png
[42c599ff233346af9f87c2fc82c5ad1f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/69e40463b4be4dda8bddf7965ec4ede2.png
[e79691d92c8245358e418d31bbde46ee.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/0e1f1ea43b0b4693aa7070ab23af60f6.png
[2ea569caf401470cbe7759d0727ce25f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/2eb6c8d651d748fab1ec22da2c759367.png
[b09f60229ac2430693bcab86970c7782.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/3383b027e1fa4875947bfe71797cf7d9.png
[f496c10c25f64e889416140380de59c9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/efae5679d4ad4144a311ca9a09fd655c.png
[ae7b4852d3814762897ef60db0e6fdbf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/f91d83ac65114ed3afe7496def601cea.png
[30664713f5ef4a42be419c5811bd68bc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/0e0036b892a94331814a850702ca0972.png
[9f2639161d33477abe8fc47d437a94dd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/5ac720b13830416ca147846ad6acbd3b.png