ubuntu 18.04 mysql 설치

sudo apt update sudo apt install mysql-server sudo mysql_secure_installation

sudo mysql_secure_installation

Check authentication method for MySQL users

#주석처리 #bind-address=127.0.0.0 vi /etc/mysql/mysql.conf.d/mysqld.cnf

ufw allow 연결 설정 Or IPtable Port open

Mysql WorkBench

 

[mysql] Data Import ERROR 1067 (42000) at line 431

solution:

mysql Error -> mysql_upgrade

Error Saving Account Error creating account vpopmail@%: Column countof mysql.user is wrong, Expected 42… Please use myslq_upgrade to fix this error.

mysql_upgrade -u root -p

mysql update error SQL_SAFE_UPDATES=0

YOU ARE USING SAFE UPDATE MODE AND YOU TRIED TO UPDATE A TABLE WITHOUT A WHERE THAT USES A KEY COLUMN

Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column Every found that kind of error when trying to update […]

mysql dump 백업

필요에 따른 mysql dump 방법

1. database 전체 데이터베이스 dump

2. 특정 테이블만 dump

3. 스키마(테이블구조만) dump

4. 데이터만(테이블구조 제외) dump

5. 특정테이블 제외 dump