MySQL 사용자 추가

MySQL 콘솔 상에서 다음과 같이 입력한다

mysql>grant select, insert, update, delete, create, drop on DBNAME.* to 'DBUSER'@'localhost
' identified by 'DBUSERPWD';

※ mysql 계정추가방법

[root@hompia root]# mysql -uroot -p
Enter password: ********
mysql> use mysql
mysql> create database shinboard;
mysql> insert into user values

          ('localhost','shinboard',password('shinboard'),'n','n','n','n','n','n','n','n',

          'n','n','n','n','n','n','n','n','n','n','n','n','n','','','','','0','0','0');
mysql> insert into db values

          ('localhost','shinboard','shinboard','y','y','y','y','y','y','y','y','y','y','y','y');
mysql> FLUSH PRIVILEGES;
mysql> exit    
[root@hompia root]# /usr/local/mysql/bin/mysqladmin -uroot -p reload;
Enter password: ********
[root@hompia root]#

[출처] ※ mysql 계정추가방법|작성자 까마귀