阿里云服务器安装mysql数据库及连接使用

冷不防 2021-12-16 00:13 460阅读 0赞

第一步：安装mysql

我个人是申请的阿里云ecs服务器CentOs操作系统，由于是初装咱们直接进行安装

1.首先从官网下载安装mysql-serve

` # wget http:``//dev``.mysql.com``/get/mysql-community-release-el7-5``.noarch.rpm`

![1477131-20190413105805204-1697863727.png][]

\# rpm -ivh mysql-community-release-el7-5.noarch.rpm

\# `yum``install` `mysql-community-server`

2.安装成功后，重启mysql：

\# service mysqld restart

3.设置密码：

`mysql>``set` `password` `for` `‘root‘@``'localhost'` `=``password``(‘``password``');`

修改密码：

1.登陆mysql 
    
    # mysql -u root -p 输入密码

2.选择数据库

use mysql;

https://www.cnblogs.com/hf8051/p/4775627.html

![1477131-20190413110817517-188636704.png][]

4.远程连接设置

GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

--查看mysql服务是否已启动
    service mysqld status 如果是 mysqld is stopped 那就说明mysql服务是停止状态， 如果是 mysqld is running 那就说明mysql服务是启动状态 查看mysql版本 方法一：status; 方法二：select version(); 使用 service 启动停止重启 service mysqld start service mysqld stop service mysqld restart

最后使用Navicate客户端进行连接：

![1477131-20190413112313359-1369278855.png][]

如果连接中连接失败请检查：

1.服务器mysql服务是否已启动

2.服务器是否正常连接

3.服务器安全组是否已配置3306端口

[配置说明  https://help.aliyun.com/document\_detail/25471.html?spm=5176.100241.0.0.IneJPl&accounttraceid=10206933-1ceb-45a4-9604-765fb7174b56][https_help.aliyun.com_document_detail_25471.html_spm_5176.100241.0.0.IneJPl_accounttraceid_10206933-1ceb-45a4-9604-765fb7174b56]

![1477131-20190413112957001-1315405670.png][]

参考解决连接：[https://www.jb51.net/article/121173.htm][https_www.jb51.net_article_121173.htm]

[https://www.jb51.net/article/148189.htm][https_www.jb51.net_article_148189.htm]

转载于:https://www.cnblogs.com/zjc2018/p/10700423.html

[1477131-20190413105805204-1697863727.png]: /images/20211215/e768c8588abb433192cc60ac566a711a.png
[1477131-20190413110817517-188636704.png]: /images/20211215/174a2d2882424d279685b854449fce9c.png
[1477131-20190413112313359-1369278855.png]: /images/20211215/de6824e726474714ae0cdefdb001b6d4.png
[https_help.aliyun.com_document_detail_25471.html_spm_5176.100241.0.0.IneJPl_accounttraceid_10206933-1ceb-45a4-9604-765fb7174b56]: https://help.aliyun.com/document_detail/25471.html?spm=5176.100241.0.0.IneJPl&accounttraceid=10206933-1ceb-45a4-9604-765fb7174b56
[1477131-20190413112957001-1315405670.png]: /images/20211215/5e24f5adb8a94d0eab0ec335170c2115.png
[https_www.jb51.net_article_121173.htm]: https://www.jb51.net/article/121173.htm
[https_www.jb51.net_article_148189.htm]: https://www.jb51.net/article/148189.htm