mysql setup - arcturus9/useful-link GitHub Wiki

< Install Mysql >

• A Quick Guide to Using the MySQL APT Repository
  https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

• Ubuntu Logo packages
  => for mysql.h in [/usr/include/ .. ] ?
  https://packages.ubuntu.com/search?suite=xenial&arch=i386&searchon=contents&keywords=mysql.h

• Install MySQL Server on Ubuntu
  https://support.rackspace.com/how-to/installing-mysql-server-on-ubuntu/

• How To Install MySQL on Ubuntu 16.04
  https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04

• 2.2 Installing MySQL on Unix/Linux Using Generic Binaries
  https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html

< Uninstall Mysql >

Completly uninstall mysql:

https://askubuntu.com/questions/172514/how-do-i-uninstall-mysql/939548

sudo service mysql stop  #or mysqld
sudo killall -9 mysql
sudo killall -9 mysqld
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo deluser -f mysql
sudo rm -rf /var/lib/mysql
sudo apt-get purge mysql-server-core-5.7
sudo apt-get purge mysql-client-core-5.7
sudo rm -rf /var/log/mysql
sudo rm -rf /etc/mysql

(and + )

rm -rf /etc/apparmor.d/abstractions/mysql /etc/apparmor.d/cache/usr.sbin.mysqld /etc/mysql /var/lib/mysql /var/log/mysql* /var/log/upstart/mysql.log* /var/run/mysqld ~/.mysql_history
updatedb

https://stackoverflow.com/questions/37165586/mysql-installation-ubuntu-server-could-not-open-abstractions-mysql

rm -rf /etc/apparmor.d/abstractions/mysql 
rm -rf /etc/apparmor.d/cache/usr.sbin.mysqld 

sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
sudo apt-get autoremove -y
sudo apt-get autoclean
rm -rf /etc/mysql

https://help.cloud66.com/node/how-to-guides/databases/shells/uninstall-mysql.html

< Mysql 기본 명령어 >

http://kwon37xi.egloos.com/1634694

• 설명 매우 좋음
  https://mrrootable.tistory.com/29
  [예제 내용]

$service mysql start
$mysql

$mysql -u root -p
$mysql -u root -p 192.168.0.3

mysql>show databases;
mysql>use mysql;
mysql>create table members(
 -> memberid char(4) primary key,
 -> password varchar(10) not null,
 -> membername varchar(20) not null,
 -> phone_number varchar(11));

mysql>show tables;
mysql>describe members;
mysql>insert into members(memberid, password, membername) values('mrrootable', '1234', 'Mr.Rootable');

mysql>select memberid, membername, password from members;

$mysqldump --tab=/tmp --user root -p mysql members;
$ls  
 --> ~~~~~~ members.sql
 --> ~~~~~~ members.txt
mysql>cat members.txt
mrro  1234  Mr.Rootable   \N

< Heidisql 설치(GUI) >

1. wine설치 https://hunit.tistory.com/253
2. heidisql 설치
   https://threenation9.tistory.com/32