bq46P9OyfEA3YyUakUy5YLvf7GEVjwYOk
rpYm3ws6GRPXiviP3I0gqHa86lvXkBot5
1saI5iSx3+STo7s/x1Qf+ps13XYKCZ9cL
yHKWYIGkndpDNfraTtQISaoW6me8QjE3n
UwLKsqHmYWNdVUT6f7zFU5A5EYBcmohdD
ggpHiPY2MWkDB3dcJnEvFkVT1VOwYDXAb
TngNwvYYaWm1STf5si549bmp1Cnk6ISVS
t4AMLXLkWhh5XTJP03SykDUdgOw7Gj1/g
gZfRTlNJkna3ig==
添加一个用户,名为username密码为pasword,第一行为添加一个本地用户,第二行为添加一个所有人都可以连接的用户
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;
完成后需要重新启动数据库,或是执行如下语句生效
flush privileges;