服务器装置MySQL

服务器应用CentOS7

数据库装置

1. 查看是否有装置MySQL

   <code class="bash">yum list installed | grep mysql

2. 下载MySQL安装包，这里下载的是8.0

   <code class="bash">wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm

3. 应用yum装置rpm包

   <code class="bash">yum -y install mysql80-community-release-el7-2.noarch.rpm

4. 装置MySQL服务，过程比较慢，须要下载

   <code class="bash">yum -y install mysql-community-server

MySQL配置

1. 启动MySQL服务，记得是mysqld

   <code class="bash">systemctl start mysqld.service

2. 查看MySQL运行状态

   <code class="bash">systemctl status mysqld.service
   
   ● mysqld.service - MySQL Server
      Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
      Active: active (running) since 三 2021-07-28 16:44:56 CST; 1min 26s ago
        Docs: man:mysqld(8)
              http://dev.mysql.com/doc/refman/en/using-systemd.html
     Process: 17913 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 18001 (mysqld)
      Status: "Server is operational"
      CGroup: /system.slice/mysqld.service
              └─18001 /usr/sbin/mysqld
   
   7月 28 16:44:47 VM-12-5-centos systemd[1]: Starting MySQL Server...
   7月 28 16:44:56 VM-12-5-centos systemd[1]: Started MySQL Server.

3. 重启/进行服务

   <code class="bash">service mysqld restart                  #重新启动Mysql
   systemctl stop mysqld.service   #进行Mysql

4. 查看MySQL的root用户初始密码

   <code class="bash">grep "password" /var/log/mysqld.log
   
   2021-07-28T08:44:50.767029Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: r!FYj6ujDhx%

5. 登录root用户

   <code class="bash">mysql -u root -p

6. 批改root明码

   <code class="mysql"># 能够先设置容许简略明码set global validate_password.policy=0;set global validate_password.length=4;# 批改明码ALTER USER 'root'@'localhost' IDENTIFIED BY '你的明码';

7. 敞开yum自动更新

   <code class="bash">yum -y remove mysql80-community-release-el7-2.noarch

至此MySQL曾经装置实现

客户端近程操作数据库

1. 查看是否开启了3306端口

   我的服务器是腾讯云，所以在控制台配置端口就行了，如果不是能够自行百度

2. MySQL设置容许近程登录

   <code class="mysql">USE mysql;UPDATE USER SET host = '%' WHERE USER = 'root';FLUSH PRIVILEGES;

3. 而后应用客户端登录即可

不定期更新：Github

喜欢 (0)赏

[搞代码]

分享 (0)