http://wiki.zovi.ch/index.php?action=history&feed=atom&title=MariaDB 2026-04-17T02:35:26Z Versionsgeschichte dieser Seite in Zovis Wikili MediaWiki 1.31.0 http://wiki.zovi.ch/index.php?title=MariaDB&diff=646&oldid=prev 2020-08-10T15:06:02Z

<p>Die Seite wurde neu angelegt: „ == FAQ == User hat für Installationen wie NextCloud, phpIPam, ...kein Recht einem anderen User Rechte zu vergeben. ab 2020 muss einem neuen User noc…“</p> <p><b>Neue Seite</b></p><div><br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> == FAQ ==<br /> <br /> User hat für Installationen wie NextCloud, phpIPam, ...kein Recht einem anderen User Rechte zu vergeben.<br /> <br /> ab 2020 muss einem neuen User noch grant Recht vergeben werden. <br /> <br /> Früher:<br /> sudo mysql_secure_installation<br /> # answer yes to all questions<br /> <br /> sudo mysql -u root -p<br /> create database nextcloud;<br /> create user nxtcloudadmin@localhost identified by 'admin123';<br /> grant all privileges on nextcloud.* to nxtcloudadmin@localhost identified by 'admin123';<br /> flush privileges;<br /> exit;<br /> <br /> sudo nano /etc/mysql/my.cnf<br /> # add these lines at the bottom:<br /> log-bin = /var/log/mysql/mariadb-bin<br /> log-bin-index = /var/log/mysql/mariadb-bin.index<br /> binlog_format = mixed<br /> <br /> sudo service mysql reload<br /> <br /> Neu:<br /> sudo mysql_secure_installation<br /> # answer yes to all questions<br /> <br /> sudo mysql -u root -p<br /> create database nextcloud;<br /> create user 'nxtcloudadmin'@'localhost' identified by 'admin123';<br /> grant all privileges on nextcloud.* to 'nxtcloudadmin'@'localhost' identified by 'admin123' with grant option;<br /> flush privileges;<br /> exit;<br /> <br /> sudo nano /etc/mysql/my.cnf<br /> # add these lines at the bottom:<br /> log-bin = /var/log/mysql/mariadb-bin<br /> log-bin-index = /var/log/mysql/mariadb-bin.index<br /> binlog_format = mixed<br /> <br /> sudo service mysql reload</div>

Zovi