在数据库命令下授权 数据库账户root 密码5a5da0a6fdd45eba


首先进入数据库 mysql

mysql -uroot -ppwd    账户root 密码 123
mysql -uroot -p123


GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '5a5da0a6fdd45eba' WITH GRANT OPTION;

FLUSH PRIVILEGES;

授权指定IP192.168.2.100
grant all privileges on *.* to 'root'@'192.168.2.100' identified by '5a5da0a6fdd45eba';


所有人授权 

grant all privileges on *.* to 'root'@'%' identified by '5a5da0a6fdd45eba'WITH GRANT OPTION;

FLUSH PRIVILEGES;

flush privileges;
这个是刷新授权的意思，如果没有这句话，授权可能无法立刻生效。