阿里云服务器上部署java项目(安装mysql)

朱雀 2021-11-09 00:18 467阅读 0赞

我的博客链接 [https://www.cnblogs.com/tomingto/p/11287881.html][https_www.cnblogs.com_tomingto_p_11287881.html]

安装mysql步骤如下：

1.安装MySQL官方的yum repository：

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjExNTU1NzY5MC00NzMyMTI5MTEucG5n][]

2.下载rpm包：

yum -y install mysql57-community-release-el7-10.noarch.rpm

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjExNTgwOTcxMy04ODQ5NDc5MjMucG5n][]

3.安装MySQL服务，最后会出现个complete

yum -y install mysql-community-server

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjExNTkxODQ3Ny0yNTkxNzgyMjQucG5n][]

安装完成后会出现

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMDAzNzQ5My0xMTI0MzAyNTUzLnBuZw][]

4。.修改MySQL配置文件(或者修改etc目录下的my.cnf文件并保存)，跳过密码登录：

vi /etc/my.cnf

按 i 进入修改模式；在末尾处添加  skip-grant-tables （表示跳过密码登录），按esc退出编辑模式，

输入：wq 保存并退出。

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMDI0NTM3My04Njc3MzYzNDIucG5n][]

5.启动mysql服务：

systemctl start mysqld.service

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMDcwOTAxMi0zMzEzNjk0MDgucG5n][]

6.登录mysql

mysql -u root （此时不用密码即可登录）。出现 mysql>

7.进入数据库修改密码  
mysql> use mysql;

Database changed

然后修改密码：mysql> update mysql.user set authentication\_string=password('admin123') where user='root' ;

8.退出mysql，重新在刚刚那个配置文件中去掉skip-grant-tables，然后重启MySQL:

mysql> exit,

vi /etc/my.cnf 进入mysql配置文件，去掉刚添加的最后一行，再重启mysql此时再登陆需要密码。

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMTU0MjA5My04OTEzNjQ2MzcucG5n][]

输入

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMTYyNjEyNC0xNjY3MTMwNDMzLnBuZw][]

9.重设密码，并设置密码等级与最小长度：

1 SET PASSWORD = PASSWORD('admin123');

1 mysql> set global validate_password_policy=0;  //改变密码等级

1 mysql> set global validate_password_length=4;   //改变密码最小长度

10.配置远程登录（root为用户名，1234为密码）,以及刷新系统权限：

1 mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234' WITH GRANT OPTION;

1 mysql> flush privileges;

到这一步就可以创建你的数据库了。create database test\_rep

n.使用Navicat数据库管理工具连接阿里云数据库，如下图所示：

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMjIwOTk2OS0yODM5NzA3MDAucG5n][]

注意：阿里云服务器的端口3306默认是不开启的，所以需要自行开启。登陆阿里云服务器，将Mysql服务端口开启

![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMjMzMzE4Ny01OTg1OTEyNjgucG5n][]

就大功告成了。。。。。。。。。。。。。。。。

[https_www.cnblogs.com_tomingto_p_11287881.html]: https://www.cnblogs.com/tomingto/p/11287881.html
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjExNTU1NzY5MC00NzMyMTI5MTEucG5n]: /images/20211108/f6c60dc35cc74451812225036ea27a66.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjExNTgwOTcxMy04ODQ5NDc5MjMucG5n]: /images/20211108/b0c1232f10c5474795d9e8568057a4de.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjExNTkxODQ3Ny0yNTkxNzgyMjQucG5n]: /images/20211108/8e456ddbb03b4c54bd735a3ed63620ca.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMDAzNzQ5My0xMTI0MzAyNTUzLnBuZw]: /images/20211108/cf0babdac7ba4180a90b11b644a62cc4.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMDI0NTM3My04Njc3MzYzNDIucG5n]: /images/20211108/02ed5ac63f7448909ab9927a49fed8d7.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMDcwOTAxMi0zMzEzNjk0MDgucG5n]: /images/20211108/3c53db55b8cb4da1999a3e9a891ffcc5.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMTU0MjA5My04OTEzNjQ2MzcucG5n]: /images/20211108/257d0fa0906349f88fcbc857cdcdee72.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMTYyNjEyNC0xNjY3MTMwNDMzLnBuZw]: /images/20211108/60465e12c0334c849bb60af44de2f897.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMjIwOTk2OS0yODM5NzA3MDAucG5n]: /images/20211108/901f1720eb9e46748daa663343d7e3f4.png
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTY4Mjc0My8yMDE5MDgvMTY4Mjc0My0yMDE5MDgwMjEyMjMzMzE4Ny01OTg1OTEyNjgucG5n]: /images/20211108/cf7dadcf11214c9e8db87d652afe6f4a.png