idea连接MySQL

怼烎@ 2021-09-27 19:28 356阅读 0赞

1 安装idea  
2 在本地安装MySQL  
MySQL下载地址https://www.mysql.com/或http://blog.csdn.net/enweitech/article/details/52353114  
3 安装MySQL  
~1 以管理员身份打开dos  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70]  
~2将”mysql-8.0.11-winx64.zip”解压到任何地方,如解压到c:\\java 下面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 2]  
~3 以管理员身份启动一个dos(命令提示符)  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 4]  
命令 cd c:\\java\\mysql-8.0.11-winx64  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 5]  
~4 安装命令  
bin\\mysqld install  
bin\\mysqld Unstall(卸载),  
bin\\mysqld remove(删除)  
执行完以后效果:![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 7]  
初始化 bin\\mysqld --initialize  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 8]  
多了一个data目录;  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 9]  
启动mysql服务器端  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 10]  
命令 bin\\mysql -u root -p  
Mysql:是自带的客户端,-u:root(用户名),-p(密码)![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 11]  
密码data目录下面主机名.err文件中,每台电脑,每次安装密码都不一样  
![在这里插入图片描述][20181114143311294.png]  
出现以下界面表示连接成功,mysql数据库安装成功  
![在这里插入图片描述][20181114143323529.png]  
必须先重置密码;  
![在这里插入图片描述][20181114143335726.png]  
– 密码的过期策略:  
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’ PASSWORD EXPIRE NEVER;  
– mysql8.0加密有三种方式;本地(native),cache2(默认,navicate程序,都不能连接);  
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql\_native\_password BY ‘123456’;  
重新登陆,使用新密码OK  
3 如何用idea 连接MySQL  
~1 在窗口界面有个Database  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 12]  
~2 点击 后 选择 MySQL  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 13]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 14]  
之后就成功了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 15]  
列表名字 和字段就会加载到idea中

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70]: /images/20210923/b6d8729221644e479106ee558448653d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 1]: /images/20210923/fecc1cde733f4509a2f084bcfd44846b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 2]: /images/20210923/a0bd2d6801d34e8796602bb18917e65a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 3]: /images/20210923/2b0f671e646942518797a8d73289d53e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 4]: /images/20210923/a55bed9180ed4d5aab1576d4a24da09c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 5]: /images/20210923/d055b19d85a14ed18ea7d83f983d11bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 6]: /images/20210923/ec8e575a0f214154a8a8423d1a61b76b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 7]: /images/20210923/2a25c01200bc43dd944c7cbebf619e8f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 8]: /images/20210923/e202dfb348bd47818f00eae35d1edd8e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 9]: /images/20210923/e7d1789762414bfbb4fa67a7dcfc46b4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 10]: /images/20210923/abf8eefeebcb4893b48da312d5b38274.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 11]: /images/20210923/fc77fd56f08f44028ebd54c6d27d2168.png
[20181114143311294.png]: /images/20210923/df0920f7a4e1453c96922751c0eceed0.png
[20181114143323529.png]: /images/20210923/295bb436b0f64268b1f53527759fc4ae.png
[20181114143335726.png]: /images/20210923/8d08114ac5624deb8971e22efbc25ab4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 12]: /images/20210923/1d84d66be69e4a43a65459088e72e2c4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 13]: /images/20210923/93b4196630d14c00b18dd6c5aec321b6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 14]: /images/20210923/77d330cda67d422eb6f8ab48c99103cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzY5NDE0NA_size_16_color_FFFFFF_t_70 15]: /images/20210923/e12c277abb1647429ebc11480446e898.png