MariaDB

FAQ

User hat für Installationen wie NextCloud, phpIPam, ...kein Recht einem anderen User Rechte zu vergeben.

ab 2020 muss einem neuen User noch grant Recht vergeben werden.

Früher:

sudo mysql_secure_installation
# answer yes to all questions

sudo mysql -u root -p
	create database nextcloud;
	create user nxtcloudadmin@localhost identified by 'admin123';
	grant all privileges on nextcloud.* to nxtcloudadmin@localhost identified by 'admin123';
	flush privileges;
	exit;
	
sudo nano /etc/mysql/my.cnf
# add these lines at the bottom:
	log-bin = /var/log/mysql/mariadb-bin
	log-bin-index = /var/log/mysql/mariadb-bin.index
	binlog_format = mixed
	
sudo service mysql reload

Neu:

sudo mysql_secure_installation
# answer yes to all questions

sudo mysql -u root -p
	create database nextcloud;
	create user 'nxtcloudadmin'@'localhost' identified by 'admin123';
	grant all privileges on nextcloud.* to 'nxtcloudadmin'@'localhost' identified by 'admin123' with grant option;
	flush privileges;
	exit;
	
sudo nano /etc/mysql/my.cnf
# add these lines at the bottom:
	log-bin = /var/log/mysql/mariadb-bin
	log-bin-index = /var/log/mysql/mariadb-bin.index
	binlog_format = mixed
	
sudo service mysql reload