Ubuntu14.04安装mysql5.6

1.前提

  • 此安装方法的前提是,链接互联网

2.安装mysql

  • 更新源

    sudo apt-get update
    
  • 安装MySQL-client-core-5.6

sudo apt-get install MySQL-client-core-5.6
  • 安装mysql-client-5.6
sudo apt-get install mysql-client-5.6
  • 安装mysql-server-5.6
sudo apt-get install mysql-server-5.6

3.检查mysql状态

执行完成上面的命令之后,正常情况mysql服务会自启动

  • 检查mysql的启动状态
    ## 查看进程
    ps -ef | grep mysql
    

查看端口监听

netstat -tap | grep mysql


* 链接mysql进行状态检查

mysql -h localhost -u root -p
Enter password:

mysql> status;

mysql Ver 14.14 Distrib 5.6.33, for debian-linux-gnu (x86_64) using EditLine wrapper

Connection id: 37
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ""
Using delimiter: ;
Server version: 5.6.33-0ubuntu0.14.04.1 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 25 min 27 sec

Threads: 1 Questions: 115 Slow queries: 0 Opens: 87 Flush tables: 1 Open tables: 80 Queries per second avg: 0.075


## 4.修改必要的配置
sudo vim /etc/mysql/my.cnf
* 修改远程访问

sudo apt-get autoremove mysql* --purge


文章导航