MySQL命令行添加用户

登录Mysql

1
$ mysql -uroot -p

创建数据库

1
create database nextcloud charset utf8;

创建用户

1
create user nextcloud@'%' identified by 'nextcloud';

给用户添加权限

1
grant all privileges on nextcloud.* to nextcloud@'%' identified by 'nextcloud';

刷新权限

1
flush privileges