Differences

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

--- setup_adminer_phpmyadmin_alternative [15.10.2020 11:00] – created Pascal Suter
+++ setup_adminer_phpmyadmin_alternative [15.10.2020 12:53] (current) – [create a mysql admin user] Pascal Suter
@@ Line 4: / Line 4: @@
 here are the few steps needed to set it up.
-first, you need a working php setup on your web server
+===== If you already have a working webserver with PHP =====
 download the latest version of adminer to your document root
   wget http://www.adminer.org/latest.php -O adminer.php
-create a mysql admin user
+create an admin user as described below and then access your adminer.php file to see the gui
+===== ubuntu: if you start with a plain installatin =====
+actually installing adminer in ubuntu is probably one of the fastest ways to get a full LAMP stack up and running in a matter of seconds:
+  apt install adminer mariadb-server
+this installs all you need, next enable the adminer config in apache
+  a2enconf adminer
+  systemctl reload apache2
+follow the next paragraph to add an admin user and finally open ''http://myserver/adminer'' to get to the gui
+===== create a mysql admin user =====
+on the command line as root:
   mysql
   CREATE USER 'admin'@'localhost' IDENTIFIED BY 'some_pass';
@@ Line 15: / Line 28: @@
 finally open your adminer.php in a browser and login with your admin user, it's as simple as that :)