#!/bin/bash
DBS=`mysql -uroot -e"show databases"`
for b in $DBS ;
do
mysql -uroot -e"show tables from $b"
done

#!/bin/bash
mysql -uuserid -ppassword database_name<<EOFMYSQL
SELECT * FROM table_name;
EOFMYSQL

user : blog
pwd : blog
dbname : blog 로 가정

DB 백업
#mysqldump -ublog -pblog blog > blog.sql
DB 복원
#/usr/bin/mysql -ublog -pblog blog < blog.sql

DB 생성
create database blog;

계정 추가
insert into user (host, user, password) values ('localhost', 'USER명', password('암호'));

권한 부여
insert into db values ('localhost', 'DB명', 'USER명', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y');

권한 적용
flush privileges;