root # mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and you haven't set the root password yet, the password will be blank, so you should just press enter here.
Enter current password for root (enter for none):
root #
... (output sequel of previous command)
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation.
Set root password? [Y/n] y
输入y：
root #
... (output sequel of previous command)
New password:
输入给root用户的密码：
root #
... (output sequel of previous command)
Re-enter new password:
输入确认密码：
root #
... (output sequel of previous command)
Password updated successfully!
Reloading privilege tables.. ... Success! By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment.
Remove anonymous users? [Y/n]
输入y来移除匿名用户：
root #
... (output sequel of previous command)
... Success!
Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n]
输入y：
root #
... (output sequel of previous command)
... Success!
By default, MariaDB comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment.
Remove test database and access to it? [Y/n]
输入y：
root #
... (output sequel of previous command)
- Dropping test database...
... Success! - Removing privileges on test database... ... Success! Reloading the privilege tables will ensure that all changes made so far will take effect immediately.
Reload privilege tables now? [Y/n]
输入y，最后输出下面内容，表示成功：
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!
nextcloud install Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE. ``` 解决方法： 1. 进入mariadb控制台，键入以下命令并回车；
mysql -u root -p
1 2
2. 输入mariadb的root密码，回车登录； 3. 输入以下命令并回车；
SET GLOBAL innodb_read_only_compressed=OFF;
1 2 3 4
4. 这时候再次注册nextcloud，发现成功解决。
> 如果出现如下错误：
Your Data directory is invalid 请确保文件根目录下包含有一个名为“.ocdata”的文件。