title: How do I correctly set ownership and privileges in MariaDB (MySQL)?
body: <p>I'm trying to setup a database schema on MariaDB which originally comes from PostgreSQL.</p>
  
  <p>What is the correct syntax in MariaDB for:</p>
  
  <pre><code>ALTER DATABASE mydbname OWNER TO someuser
  </code></pre>
  
  <p>and similar for granting privileges:</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON DATABASE mydbname TO someotheruser
  </code></pre>
  
  <p>Both works on PostgreSQL and is valid SQL-99 syntax. MariaDB (the PHPMyAdmin frontend) gives me: #1064 - You have an error in your SQL syntax;</p>