在ubuntu17下安装mysql56
1. 安装
sudo apt-get update
sudo apt-get install mysql-server
2. 配置mysql
sudo mysql_secure_installation # 可以设置mysql的安全设置(可选)
安装完成后输入下面的指令检查mysql版本
mysql --version
如果版本小于 5.7.6,要通过下面这个指令初始化数据文件夹
sudo mysql_install_db
3. 测试数据库是否安装
service mysql status
如果输出的是
mysql start/running, process 2*** # PID
说明mysql已经启动,否则需要通过输入
sudo service mysql start
来启动mysql
为了进一步测试,可以输入指令链接数据库
mysqladmin -p -u root version
如果输出的结果和这个类似,则说明mysql安装好了
mysqladmin Ver 8.42 Distrib 5.5.47, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2015, 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.5.47-0ubuntu0.14.04.1
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 4 min 15 sec
Threads: 1 Questions: 602 Slow queries: 0 Opens: 189 Flush tables: 1 Open tables: 41 Queries per second avg: 2.360
mysql 配置官方地址