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- http://www.webmin.com/jcameron-key.asc | sudo apt-key add

sudo apt update 

Then install Webmin:

1. sudo apt install webmin 

#Login to MySQL Console
mysql -u root -p
Enter password:
#Modify user
GRANT ALL PRIVILEGES ON *.* TO 'dhani'@'%' IDENTIFIED BY '12345678';
FLUSH PRIVILEGES
EXIT;