阿里云服务器连接MYSQL

不念不忘少年蓝@ 2021-09-19 08:26 581阅读 0赞

# 阿里云服务器连接MYSQL #

阿里云建站参考文档地址：[https://blog.csdn.net/qq\_34227291/article/details/88241108][https_blog.csdn.net_qq_34227291_article_details_88241108]

PS:服务器连接MYSQL数据库步骤如下（以下的服务器是轻量级ECS服务器）

**1. 进入控制台-防火墙项-添加规则**  
![在这里插入图片描述][20190509202935624.png]

**2. 进入控制台-应用详情-远程连接;运行下面命令允许主机连接MYSQL数据库**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70]  
命令1：sudo /usr/local/mysql/bin/mysql -uroot –p密码

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

命令2：GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘yourpassword’ WITH GRANT OPTION;

%：代表任何主机都可以连接;指定的ip的话，更改%

![在这里插入图片描述][20190509203232593.png]

命令3：FLUSH PRIVILEGES //刷新修改  
![在这里插入图片描述][20190509203252354.png]  
命令4：quit //退出MYSQL

**3. 首页搜索DMS**  
PS：点击开通-同意-进入个人版  
![在这里插入图片描述][20190509203353377.png]  
![在这里插入图片描述][20190509203400680.png]

**4. 开始连接**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70 2]

点单【新增数据库】会弹出登录方式
    
    登录地址：是上页面步骤1的点击远程连接的命令输入框的左下角的ip地址
    
    端口是：3306
    
    用户名：root
    
    密码：上面修改密码是yourpassword; 命令2：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70 3]

**5. DMS连接成功页面**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70 4]  
![在这里插入图片描述][20190509203529694.png]

[https_blog.csdn.net_qq_34227291_article_details_88241108]: https://blog.csdn.net/qq_34227291/article/details/88241108
[20190509202935624.png]: /images/20210724/2afaff86b1d846239cfce872b48a63a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70]: /images/20210724/dc1fe5b3370f4af9a44e0ff50d6775bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70 1]: /images/20210724/92b92afb5be743c8b85dd11ecd8573c7.png
[20190509203232593.png]: /images/20210724/6599c4cd075843d8ad4bd7fa930bf2d8.png
[20190509203252354.png]: /images/20210724/9a4077258bea449dbeb4dfc74888d57e.png
[20190509203353377.png]: /images/20210724/d12cd0c36fe44dfba21dceb91604ea0b.png
[20190509203400680.png]: /images/20210724/61c74701509c478f9b2e28a1c4fa5146.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70 2]: /images/20210724/948489308b4c40f7a8d476b9fda79a86.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70 3]: /images/20210724/b2188681f5b445e1a62a178a254103c6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0MjI3Mjkx_size_16_color_FFFFFF_t_70 4]: /images/20210724/77540b05514d4242acea98c4b5bb5bec.png
[20190509203529694.png]: /images/20210724/5094b9d019c14709bc4524097118c4f0.png