Manjaro19 Mysql配置和workbench使用

雨点打透心脏的1/2处 2023-07-24 05:50 20阅读 0赞

用户界面和以前在windows上的不太一样了，刚用的时候有点蒙蔽。

## 1. 下载workbench ##

下载workbench很简单

yaourt -S mysql-workbench

下载后有了这样的图形化界面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70]

## 2. 初始化配置mysql ##

#### 初始化MySql数据目录 ####

sudo mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
    # 注意记录root临时密码

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 1]

#### 查看Mysql状态 ####

sudo systemctl mysql status

#### 启动Mysql服务&开机自启动 ####

sudo systemctl enable mysqld
    sudo systemctl start mysqld

#### 账户安全设置/需要使用root临时密码登陆 ####

mysql_secure_installation

## 3. 创建数据库 ##

File -> New Model

创建好的数据库是这个样子的  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 2]  
创建新的Schema，点击上面的图标就好，和windows一样，接下来创建一个table  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 3]  
点击Columns，就可以创建列了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 4]  
创建sql脚本文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 5]  
往下拉就有，之前习惯点击上面的一排图标创建脚本

> Update: 发现我煞笔了，之前没有初始化所以根本就没有mysql服务……让我产生了linux和window上操作界面不同的错觉

所以不如远程登录mysql

mysql -h (服务器ip) -P (端口号) -p (数据库名称) -u (用户)

> 参考博客：  
> [https://www.jianshu.com/p/12c871f937f7][https_www.jianshu.com_p_12c871f937f7]  
> [https://www.cnblogs.com/jackadam/p/9505562.html][https_www.cnblogs.com_jackadam_p_9505562.html]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70]: /images/20230528/25614b673f11404b9129f8350cf4326c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 1]: /images/20230528/845a57cda55d4586a479685b2f632a78.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 2]: /images/20230528/4a04e5d202fe44cf95bbc7844b1cf47f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 3]: /images/20230528/e426f00064774364975857aa1e213910.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 4]: /images/20230528/0a162124714748d9a94f8c79c8190c53.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQyMjEyMQ_size_16_color_FFFFFF_t_70 5]: /images/20230528/739c7d21ee6c423090f78c3bc0bd74be.png
[https_www.jianshu.com_p_12c871f937f7]: https://www.jianshu.com/p/12c871f937f7
[https_www.cnblogs.com_jackadam_p_9505562.html]: https://www.cnblogs.com/jackadam/p/9505562.html