mysql tip

매뉴얼 : http://dev.mysql.com/doc/refman/5.1/en/index.html


[콘솔 로그인]
shell> mysql --user=root mysql


[계정추가]
중요: 계정@IP주소로 등록해야함. 그리고, xp경우 방화벽에 3306 포트도 추가해줘야 외부에서 접속할수 있음.

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> WITH GRANT OPTION;
mysql> CREATE USER 'admin'@'localhost';
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> CREATE USER 'dummy'@'localhost';