Computer/DB

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

미처서 2015. 1. 21. 16:42

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';