// 계정 생성 GRANT ALL PRIVILEGES ON *.* TO TEST_ID@"%" IDENTIFIED BY '비밀번호' WITH GRANT OPTION; FLUSH PRIVILEGES;
// 계정 생성 또다른 방법 (로컬에서만 사용할경우 %로한다) GRANT ALL PRIVILEGES ON *.* TO TEST_ID@localhost IDENTIFIED BY '12345' WITH GRANT OPTION; FLUSH PRIVILEGES;
//비번 바꾸기
use mysql;
update user set password=password('newpass') where user = 'root';
FLUSH PRIVILEGES;
mysql> CREATE USER [user 이름]@localhost IDENTIFIED BY ‘[password]’;
Query OK, 0 rows affected (0.04 sec)
mysql> GRANT ALL PRIVILEGES ON connectdb.* TO ‘[user 이름]’@’localhost’;
Query OK, 0 rows affected (0.00 sec)