安装mysql
apt-get install mysql
使用安全设置,禁用root,匿名等,然后用root登录mysql
mysql_secure_installation
mysql -u root -p
输入root密码
切换数据库
mysql>use mysql;
查看当前用户
mysql>SELECT Host,User,Select_priv,Grant_priv from user;
新建用户
mysql>CREATE USER 'aaa'@'%' IDENTIFIED BY '123';
授于全部权限
mysql>grant all on *.* to abc@% with grant option;
myql -u root//进入入mysql
create database nextcloud;
create user ‘123’@’%’ identified by ‘456’;
grant all privileges on nextcloud.* to ‘123’@’%’;