Ubuntu LAMP with phpMyAdmin correct as of Jan 2023
Ubuntu LAMP with phpMyAdmin correct as of Jan 2023 Install Ubuntu Server. sudo apt update sudo apt upgrade sudo apt install lamp-server^ Note the '^' is required. Probably a good idea to reboot. login to the dbms with: sudo mysql Replace username and password with your required values CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; GRANT ALL ON * . * to username@localhost; You can then log into phpmyadmin using the provided credentials with http://hostname/phpmyadmin/ Create a new linux user and grant sudo proveliges sudo adduser USERNAME sudo usermod -aG sudo USERNAME Increase max upload size for larger database leah@database:/etc/php/8.1/apache2$ sudo nano php.ini^ Search php.ini for the items below, ctrl w in nano to search. memory_limit = 128M post_max_size = 128M upload_max_filesize = 128M sudo nano /etc/apt/sources.list add deb http://download.webmin.com/download/repository sarge contrib wget -q -O-