Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
deb13:mariadb [2026/05/18 16:15] – [Installation from Debian 13 repositories] Bernard Condraudeb13:mariadb [2026/05/18 22:01] (current) – [Installation from Debian 13 repositories] Bernard Condrau
Line 13: Line 13:
   - We will create a new account called //user// with the same capabilities as the root account, but configured for password authentication. Open up the MariaDB prompt from your terminal:<code>$ sudo mariadb   - We will create a new account called //user// with the same capabilities as the root account, but configured for password authentication. Open up the MariaDB prompt from your terminal:<code>$ sudo mariadb
 MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
 +MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION;
 MariaDB [(none)]> FLUSH PRIVILEGES; MariaDB [(none)]> FLUSH PRIVILEGES;
 MariaDB [(none)]> exit</code> MariaDB [(none)]> exit</code>
   - Install phpMyAdmin:<code>$ sudo apt install phpMyAdmin</code>   - Install phpMyAdmin:<code>$ sudo apt install phpMyAdmin</code>
 +  - if your host is behind a proxy server you need to add the following line to your virtualhost configuration file:<code>RequestHeader set X-Forwarded-Proto "https"</code>
   - Check configuration [[deb11:phpmyadmin#configuration|phpMyAdmin Configuration]]   - Check configuration [[deb11:phpmyadmin#configuration|phpMyAdmin Configuration]]
   - If you are migrating from an old server, follow the [[deb11:migrate#mariadb|How to migrate a (web) server]] guide   - If you are migrating from an old server, follow the [[deb11:migrate#mariadb|How to migrate a (web) server]] guide

Know How

© 2007-2026 Bernard Condrau - Powered by DokuWiki