Mysql server

Overview

Mysql server 사용 관련 내용 정리

Installation

Debian 8(Jessie) 에서 Mysql-server-5.6 이상 버전을 설치하기 위해서는 다음의 스크립트를 사용하면 된다.<ref>http://blog.programster.org/debian-8-install-mysql-5-6/</ref> <source lang=bash>

1. !/bin/bash

cd /tmp

1. Confirm the version at http://dev.mysql.com/downloads/repo/apt/

wget -O mysql-apt-config.deb https://dev.mysql.com/get/mysql-apt-config_0.3.7-1debian8_all.deb

sudo dpkg -i mysql-apt-config.deb

1. At the popup-page, select "Apply"

1. Install mysql-server package

sudo apt-get update sudo apt-get install mysql-server-5.6 -y </source>

Errors

corrrupt or were not closed cleanly

mysql 서버 실행시, 다음과 같은 메시지가 나타날 때가 있다. 그렇게 문제가 되는 메시지는 아니며, 간단히, 에러가 아니다.

# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . ..
Checking for tables which need an upgrade, are corrupt or were 
not closed cleanly..

• http://serverfault.com/questions/613533/how-to-fix-corrupt-not-cleanly-closed-and-upgrade-needing-tables-in-mysql/637499?newreg=b9c0ff5045234b3990b71eb59099dae1