MySQL 데이터베이스 생성 및 접근권한

C:\ProgramFiles\MySQL\MySQLServer5.5\bin>mysqladmin-uroot-p create basicjsp

•로컬호스트(localhost)에접근할수있는권한

grant select,insert,update,delete,create,drop,alter

on basicjsp.*to'jspid'@'localhost'

identified by 'jsppass';

•모든서버(%)에접근할수있는권한

grant select,insert,update,delete,create,drop,alter

on basicjsp.*to'jspid'@'%'

identified by 'jsppass';