阿晨的运维笔记 | Ubuntu部署MySQL

209 阅读1分钟

开始部署之前,建议先按照Ubuntu切换到国内镜像源操作一下,能省下大把宝贵时间!

Ubuntu上部署MySQL比在Windows简单了不少!

废话少说,开始部署!

安装

$ sudo apt-get update
$ sudo apt-get install mysql-server

💡 提示:在安装过程中,系统将提示您创建root密码。请务必记住root密码

配置

运行安全脚本

$ mysql_secure_installation

值得一提的是,Disallow root login remotely?,如果你需要使用root账号进行远程连接,请选择No

验证

接下来测试下是否安装成功了

运行状态

$ systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2019-07-18 23:38:43 PDT; 11min ago
 Main PID: 2948 (mysqld)
    Tasks: 28
   Memory: 142.6M
      CPU: 545ms
   CGroup: /system.slice/mysql.service
           └─2948 /usr/sbin/mysqld

登录查看版本

$ mysqladmin -p -u root version
mysqladmin  Ver 8.42 Distrib 5.7.26, for Linux on x86_64
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version		5.7.26-0ubuntu0.16.04.1
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/run/mysqld/mysqld.sock
Uptime:			12 min 18 sec

Threads: 1  Questions: 36  Slow queries: 0  Opens: 121  Flush tables: 1  Open tables: 40  Queries per second avg: 0.048

到这里,Mysql安装完成!你可以使用你喜欢的工具进一步测试。

如果本篇博客对您有一定的帮助,大家记得留言+点赞+收藏哦。

image-20210723185904932

我是阿晨,在技术的道路上我们一起砥砺前行!