MySql000——MySql数据库管理系统的下载、安装以及使用图形化工具MySQL Workbench创建数据库和表

拼搏现实的明天。 2024-05-05 22:18 52阅读 0赞

## 一、[下载MySql][MySql]数据库管理系统 ##

![在这里插入图片描述][e6a87a1f490f4c1c941f03eee4f54763.png]  
![在这里插入图片描述][ccb3eac0d3434b719bf5eda2a41c4702.png]  
![在这里插入图片描述][e6aa8c05955d4b6f870c17b801572d26.png]

## 二、[下载MySQL驱动][MySQL] ##

![在这里插入图片描述][e256ede40553468b92410b07e9df880f.png]  
![在这里插入图片描述][72dcd919a33b40eeabb5a1ea094d8586.png]

## 三、安装数据库管理系统 ##

![在这里插入图片描述][b301d8bd8cf447d1b82e5a6e53ce9867.png]  
![在这里插入图片描述][cacdb4b580bc4e7ab876cd319da84e64.png]  
![在这里插入图片描述][c14b39c4b88542a294089b4d08241fcb.png]  
![在这里插入图片描述][ebf6ba270ad749f3ae7cbeea4b7ad4ae.png]  
![在这里插入图片描述][21ac5c4b90f2464791c6ed6249cc5be5.png]  
![在这里插入图片描述][e6b4dc1fb6044cb4aa56017c933c35bf.png]  
![在这里插入图片描述][e055e3cb80a74a17ab1bdf6580ebbd23.png]  
![在这里插入图片描述][e03e090b76644b7aba6036a45b1e5158.png]  
![在这里插入图片描述][5f7338823afa4af4b02592fad98e2723.png]  
![在这里插入图片描述][2662986da1fd40b5be046a5c0b37223e.png]  
![在这里插入图片描述][0f9225aa8ab94bd3ab48b3739dd2f170.png]  
![在这里插入图片描述][34a7623c78c84155a5f4e8a28208a286.png]  
![在这里插入图片描述][d4790ec3bb04470d98985b98998e5bb2.png]  
![在这里插入图片描述][081012953e204c5da596a6d26189f5fb.png]  
![在这里插入图片描述][86943cbbe2684f8d8194dab49da1889c.png]  
![在这里插入图片描述][bec94efd9ff644aba9fe5b596043f797.png]  
![在这里插入图片描述][fbcb45d465484f54983f57c17737ab27.png]  
![在这里插入图片描述][b03c25c3c3144cbfbc91e7ed5e0f5598.png]  
![在这里插入图片描述][15a41ca9e8ae481abf654561d03c0ce3.png]  
![在这里插入图片描述][efe08a40ede14c7c8430c064e1616f9b.png]  
![在这里插入图片描述][5824f5ab88994ed7a81b1868fc72bd4f.png]  
![在这里插入图片描述][9f416247ca754f14ac4c190aad896f25.png]  
![在这里插入图片描述][0260f38c7e39458d9c0c5cb66b09e6d5.png]  
![在这里插入图片描述][67c6ca78ddbc4cedad3aec7eb4c810f3.png]  
![在这里插入图片描述][afb45492fbd14629862213da3f2d23c5.png]  
到此，成功安装

## 四、创建一个数据库和表 ##

点击打开图形化界面  
![在这里插入图片描述][b521b06cfe6c43a9904eb067aad0c63f.png]  
输入密码，点击上图的ok  
![在这里插入图片描述][1322dbb8ee6b41439eaf948ddef78253.png]  
后就进入以下界面。

![在这里插入图片描述][6e249a2a85924e5c89e480e56d12475f.png]  
![在这里插入图片描述][b640eef55c1d4ac698d953892d0e09a3.png]

### 4.1、创建数据库 ###

现在创建一个名叫study的数据库  
![在这里插入图片描述][7efb2febdf014e39871be0a82d3c391f.png]  
![在这里插入图片描述][35b803c328774c0da50ee42b956d350b.png]  
![在这里插入图片描述][6a8f4118084d461cbc8c7578c8cc76dd.png]  
![在这里插入图片描述][7a93bdbcc8bf4c368d4ad5582004bb7d.png]  
![在这里插入图片描述][a2525c50650441b58ad553b55e975039.png]

### 4.2、创建表 ###

下面我们将在上面的数据库study中创建数据表user（代表用户表）  
![在这里插入图片描述][1a17e1e1c6674b7e965b740cd4b1957e.png]  
![在这里插入图片描述][1740b80f6298461bbabdb05424e1e193.png]  
![在这里插入图片描述][1ecd9603a92d4227ac8b14d811b8b187.png]  
![在这里插入图片描述][448fa08481954bd08b8cb73c93eeb389.png]  
![在这里插入图片描述][7940e7ebdd644d5f8cf1e689de7685ce.png]

### 4.3、手动向表中添加数据 ###

![在这里插入图片描述][b3740a9301dd479485add9b6f9991de9.png]  
![在这里插入图片描述][2a074f00e4da4e1895fb5f88360d7eac.png]  
![在这里插入图片描述][51ae3bab52d8404e943471b87d409db9.png]  
![在这里插入图片描述][dd150ae536ce47259b6d30c0de604b1a.png]  
到此数据库和表以及手动插入数据全过程就好了  
![在这里插入图片描述][c75c1bb7b0fa4941b6120c010ea53b1a.png]

## 与君共享 ##

?????最后，有兴趣的小伙伴可以点击下面链接，这里有我整理的MySQL学习博客内容，谢谢~ ?????

[《MySQL数据库学习》][MySQL 1]

[MySql]: https://dev.mysql.com/downloads/
[e6a87a1f490f4c1c941f03eee4f54763.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/3d1dc53b6f7340a896a93d48134afc9d.png
[ccb3eac0d3434b719bf5eda2a41c4702.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/64270d57b8204b029bc37c6991d47cd8.png
[e6aa8c05955d4b6f870c17b801572d26.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/fbf76daf718a4d77abd83fbe45ffa858.png
[MySQL]: https://dev.mysql.com/downloads/connector/j/
[e256ede40553468b92410b07e9df880f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/537cd47e2718499dac72c68d915f86c2.png
[72dcd919a33b40eeabb5a1ea094d8586.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/ea80f85259424df19aee6a6ce419c1c6.png
[b301d8bd8cf447d1b82e5a6e53ce9867.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/54a66ad4e3e942f29b33da4776d72139.png
[cacdb4b580bc4e7ab876cd319da84e64.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/3c61c2bf64f9480b96ea785ba9b6c365.png
[c14b39c4b88542a294089b4d08241fcb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/f3d3aa9e755b4136865ce1de5886cf5d.png
[ebf6ba270ad749f3ae7cbeea4b7ad4ae.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/eec9dc5dca374a6b9c84ff83c6bc96ec.png
[21ac5c4b90f2464791c6ed6249cc5be5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/f22b5a78594a4dd8b04636ccd5bfc19d.png
[e6b4dc1fb6044cb4aa56017c933c35bf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/76b4860f868545e284ece05d6a6a9b66.png
[e055e3cb80a74a17ab1bdf6580ebbd23.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/ff232a06fdd54dab8e7642e9d96b06b6.png
[e03e090b76644b7aba6036a45b1e5158.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/1da514857d9d45cdb02599f5e6f3cce7.png
[5f7338823afa4af4b02592fad98e2723.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/551e17a3fb1c4f4a9274a94c63690218.png
[2662986da1fd40b5be046a5c0b37223e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/b5aab3c9a1d34407810a16d998ff99ed.png
[0f9225aa8ab94bd3ab48b3739dd2f170.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/fb7f5387045c44fd981c01b990bd663c.png
[34a7623c78c84155a5f4e8a28208a286.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/384f27b637634ec28d0bc0f05e1ca09c.png
[d4790ec3bb04470d98985b98998e5bb2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/772e0e7f354b47cca896854a5a347d4d.png
[081012953e204c5da596a6d26189f5fb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/db4b3fb60b5d4fbdb5746d08332dbd0c.png
[86943cbbe2684f8d8194dab49da1889c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/67a1dbbed7784de3bf307828fd95dabb.png
[bec94efd9ff644aba9fe5b596043f797.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/6e20d18c44f54b7092ca07b6502cd87d.png
[fbcb45d465484f54983f57c17737ab27.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/296a000574364a74b635b2ad9868ec59.png
[b03c25c3c3144cbfbc91e7ed5e0f5598.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/7021d1f20a59481b94f205b70b6d9096.png
[15a41ca9e8ae481abf654561d03c0ce3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/c3187a1549f14ceea83183c60e58e4ba.png
[efe08a40ede14c7c8430c064e1616f9b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/9fca54af138e4b569d740ad1621f21f2.png
[5824f5ab88994ed7a81b1868fc72bd4f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/1e1d22441a724da2b9af48b18c86384a.png
[9f416247ca754f14ac4c190aad896f25.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/c2d8d37220134299aeea08d4acfadae5.png
[0260f38c7e39458d9c0c5cb66b09e6d5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/f5e3dc45ed9340319e8e0206f1500c72.png
[67c6ca78ddbc4cedad3aec7eb4c810f3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/b155d56a3f664a12b22348c3a30d952e.png
[afb45492fbd14629862213da3f2d23c5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/05ec622b99334eadb32e569834bb8b98.png
[b521b06cfe6c43a9904eb067aad0c63f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/cb47ef34d22447b282108ee95424f674.png
[1322dbb8ee6b41439eaf948ddef78253.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/a5fd5add2e94441f968d84b8fd4e8c91.png
[6e249a2a85924e5c89e480e56d12475f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/c9bf33ed24f54eafb055bb46a3d0f974.png
[b640eef55c1d4ac698d953892d0e09a3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/3044d61276bb46f49685b40fcc875f64.png
[7efb2febdf014e39871be0a82d3c391f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/184cb2a5d7df4f5da65eb7574a98666d.png
[35b803c328774c0da50ee42b956d350b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/0bd3f1f1ec1c4e5680de10a51d117179.png
[6a8f4118084d461cbc8c7578c8cc76dd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/509f73a33e9749aebecb80de11d2ccf5.png
[7a93bdbcc8bf4c368d4ad5582004bb7d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/1d4d29de8f354a6ca65bd5e81b79f427.png
[a2525c50650441b58ad553b55e975039.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/5ed2492aaa4f4f8d8082f88e179dbf69.png
[1a17e1e1c6674b7e965b740cd4b1957e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/9a18ccc0b97f4c0b96d097efb39b0202.png
[1740b80f6298461bbabdb05424e1e193.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/2944d96e126a49a1bcf6fa2084da8827.png
[1ecd9603a92d4227ac8b14d811b8b187.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/7dd6cd91d1214f0a961e34517ec323cb.png
[448fa08481954bd08b8cb73c93eeb389.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/33c72bb7a13e4cb08ad20fa7345eb5e1.png
[7940e7ebdd644d5f8cf1e689de7685ce.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/ba5e84364e824aecb1034d4e98d3f10f.png
[b3740a9301dd479485add9b6f9991de9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/52af098bb5424b61b871a782a0324a64.png
[2a074f00e4da4e1895fb5f88360d7eac.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/c11d745857fd419894a5fec56df2d5c2.png
[51ae3bab52d8404e943471b87d409db9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/971033d85d05448bb8aeee3c97474a66.png
[dd150ae536ce47259b6d30c0de604b1a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/83912aba15b94c8fb0ffbd7f5e104a1d.png
[c75c1bb7b0fa4941b6120c010ea53b1a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/05/4fc339f2aa3f4364b8de627611f18d93.png
[MySQL 1]: https://blog.csdn.net/weixin_45084986/category_10980911.html