mysql 외부에서 접속

# mysql -u root -p
를 통해 먼저 접속한 후.

> use mysql
> grant all privileges on *.* to 'root'@'%' identified by '비밀번호';
> flush privileges;

 

 

mysql > use mysql;
mysql > update user set password=password('password') where user='root';

mysql > flush privileges; or commit;