title: How to upgrade MariaDB within Xampp
body: <p>I want to upgrade to MariaDB 10.2 and I'm using xampp ( I like that mysqld.exe runs in the background and easy On/Off with a single click ). What happens is that the latest version as of now is 3.2.2 and it has MariaDB 10.1.29 comes with it.
  I'm looking for a general healthy way to do it.
  I've tried <a href="https://medium.com/@meness/steps-to-upgrade-mariadb-for-xampp-7924326731d3" rel="nofollow noreferrer">those steps</a> that pretty much look good :</p>
  <ul>
  <li>Unzipping/installing the new MariaDB then copying the data directory and the config|bat files + phpMyAdmin from the old to the new installation.
  After starting for an instant, it shuts down complaining :</li>
  </ul>
  <blockquote>
  <pre><code>13:44:33  [main]  Control Panel Ready
  13:52:46  [mysql]     Attempting to start MySQL app...
  13:52:46  [mysql]     Status change detected: running
  13:52:49  [mysql]     Status change detected: stopped
  13:52:49  [mysql]     Error: MySQL shutdown unexpectedly.
  13:52:49  [mysql]     This may be due to a blocked port, missing dependencies, 
  13:52:49  [mysql]     improper privileges, a crash, or a shutdown by another method.
  13:52:49  [mysql]     Press the Logs button to view error logs and check
  13:52:49  [mysql]     the Windows Event Viewer for more clues
  13:52:49  [mysql]     If you need more help, copy and post this
  13:52:49  [mysql]     entire log window on the forums
  </code></pre>
  </blockquote>
  <h2>Notes:</h2>
  <ul>
  <li><p>I'm not gonna try <a href="https://stackoverflow.com/questions/18022809/xampp-mysql-shutdown-unexpectedly">some random deletes</a> that are very likely to
  make my db tables corrupt (even though I did before and it didn't
  work)</p>
  </li>
  <li><p>Please take notice that if I run the server itself using an unprivileged user
  (not administrator) on the command line, it runs as expected.
  Furthermore, the status in the Xampp control panel would change to green :</p>
  </li>
  </ul>
  <blockquote>
  <p><code>14:00:35  [mysql]    Status change detected: running</code></p>
  </blockquote>
  <p>And I could even shut down the MySQL server from it, by clicking on stop.</p>
  <ul>
  <li>If I run Xampp as administrator (which could be a bad idea), I get the same error message above.</li>
  <li>Please note also that running MySQL server as an administrator involves security risks.</li>
  <li>I know I can run it as a service, but I'd rather like to have instant control over when to turn it On/Off.</li>
  </ul>
  <h2>The purpose :</h2>
  <p>Looking for a clean way to upgrade MariaDB within xampp, on windows (Windows7)</p>