1、新创建库和用户
创建一个superset库,然后对这个库的superset用户授予所有的权限,用户superset密码设置在最后,然后刷新库。
create database superset;grant all privileges on superset.* to superset@'172.17.%.%' identified by '密码'; grant all privileges on superset.* to superset@'172.18.%.%' identified by '密码'; flush privileges;
2、单独修改用户密码
修改数据库用户root的密码
use mysql;update user set password=password('密码') where user='root' and host='localhost'; flush privileges;
转载于:https://www.cnblogs.com/tengfei520/p/7550815.html