Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
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. | here are the few steps needed to set it up. | ||
- | first, | + | ===== If you already have a working |
download the latest version of adminer to your document root | download the latest version of adminer to your document root | ||
wget http:// | wget http:// | ||
- | 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 '' | ||
+ | |||
+ | ===== create a mysql admin user ===== | ||
+ | on the command line as root: | ||
mysql | mysql | ||
CREATE USER ' | CREATE USER ' | ||
Line 15: | Line 28: | ||
finally open your adminer.php in a browser and login with your admin user, it's as simple as that :) | finally open your adminer.php in a browser and login with your admin user, it's as simple as that :) | ||
+ | |||
+ | | ||