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:phpmyadmin [2026/09/26 10:36] – [phpMyAdmin Configuration] Bernard Condraudeb13:phpmyadmin [2026/09/26 10:42] (current) – [apache2 Configuration] Bernard Condrau
Line 47: Line 47:
  
 ===== apache2 Configuration ===== ===== apache2 Configuration =====
-  - Create ''/home/user/html/phpMyAdmin/apache.conf'':<code># phpMyAdmin default Apache configuration+  - Create ''/etc/apache2/conf-available/phpmyadmin.conf'':<code># phpMyAdmin default Apache configuration
  
 Alias /phpmyadmin /home/user/html/phpMyAdmin Alias /phpmyadmin /home/user/html/phpMyAdmin
Line 101: Line 101:
 </Directory> </Directory>
 </code> </code>
-  - You can replace the directives for the setup directory with ''Require all denied'' as we will not use the setup script. However, if you do want to use the setup script prior to creating ''config.inc.php'', first create the password file to access the setup script's directory:<code>$ sudo htpasswd -c /home/user/html/phpMyAdmin/htpasswd.setup user</code> +  - Enable the configuration, check the configuration, and restart apache:<code>$ sudo a2enconf phpmyadmin 
-  - Symlink the configuration file for Apache and restart the service:<code>$ sudo ln -s /home/user/html/phpMyAdmin/apache.conf /etc/apache2/conf-enabled/phpmyadmin.conf +$ sudo apachectl configtest 
-$ sudo service apache2 restart</code> +$ sudo systemctl restart apache2</code> 
-  - Create a regular MariaDB user for the purpose of managing databases through phpMyAdmin, if you haven't done that yet when configuring MariaDB. You could create a user that has privileges to all tables within the database, as well as the power to add, change, and remove user privileges, with this command. Whatever privileges you assign to this user, be sure to give it a strong password as well:<code>$ sudo mariadb+  - Create a regular MariaDB user for the purpose of managing databases through phpMyAdmin, if you haven't done that yet when configuring MariaDB. You would create a user that has privileges to all tables within the database, as well as the power to add, change, and remove user privileges, with this command. Whatever privileges you assign to this user, be sure to give it a strong password as well:<code>$ sudo mariadb
 MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
 MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname'; MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname';

Know How

© 2007-2026 Bernard Condrau - Powered by DokuWiki