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