# Databases
Below is a list of all supported databases along with their compatible operating systems. You can click on each tab to view more details.
MYSQL [Ubuntu 24.04/22.04]
**Create User & Database, Then Run Security Script**
**Step 1: Run the Security Script**
```
sudo mysql_secure_installation
```
You’ll be prompted to:
* Set a root password (if not already set)
* Remove anonymous users
* Disallow remote root login
* Remove the test database
* Reload privilege tables
> **Tip**: Press `Y` to accept the recommended security settings.
**Step 2: Log In to MySQL**
With the admin password set, you can now access your MySQL instance by running the following command:
```
sudo mysql -u root -p
```
* **Username**: `root`
* **Password**: *(enter the password you set in Step 1)*
MYSQL [Alma Linux 9.5/ 8.5]
**Create User & Database, Then Run Security Script**
**Run the MySQL Security Script:**
```
sudo mysql_secure_installation
```
You’ll be prompted to:
* Change the root password
* Remove anonymous users
* Disallow remote root login
* Remove the test database
* Reload privilege tables
**Tip**: Press `Y` to accept the recommended security settings.
**Log In to MySQL**
```
mysql -u root -p
```
Enter the root password you set during the security script.
**Configure MySQL for Remote Access**
```
sudo nano /etc/my.cnf
```
Find the line with `bind-address` and change it to:
```
bind-address = 0.0.0.0
```
Save and exit the file.
**Restart MySQL Service**
```
sudo systemctl restart mysqld
```
**Open MySQL Port in Firewall**
```
sudo firewall-cmd --permanent --add-service=mysql
sudo firewall-cmd --reload
```
**Verify MySQL Access**
```
sudo mysql -u root -p
```
Username: root\
Password: (your admin password)
PostgreSQL [Ubuntu 24.04]
**Create User & Database**
```
sudo -i -u postgres
createuser --interactive
createdb mydatabase
```
**Or via SQL:**
```
psql
CREATE USER myuser WITH PASSWORD 'mypassword';
CREATE DATABASE mydb OWNER myuser;
\q
```
**Optional: Enable Remote Access**
```
sudo nano /etc/postgresql/16/main/postgresql.conf
Set:
listen_addresses = '*'
sudo nano /etc/postgresql/16/main/pg_hba.conf
Add:
host all all 0.0.0.0/0 md5
sudo systemctl restart postgresql
```
MariaDB [Ubuntu24.04/22.04]
**Create User & Database, Then Run Security Script**
**Run the Security Script**
```
sudo mysql_secure_installation
```
You’ll be prompted to:
* Set a root password (if not already set)
* Remove anonymous users
* Disallow remote root login
* Remove the test database
* Reload privilege tables
**Tip**: Press `Y` to accept the recommended security settings.
**Log In to MariaDB**
```
sudo mariadb -u root -p
```
Username: root\
Password: (enter the password you set above)
**Enable Remote Access (Optional)**
```
sudo nano /etc/my.cnf
```
Locate the `bind-address` line and update it to:
```
bind-address = 0.0.0.0
```
Save and exit the file.
**Restart MariaDB Service**
```
sudo systemctl restart mysqld
```
**Open MariaDB Port in Firewall**
```
sudo firewall-cmd --permanent --add-service=mysql
sudo firewall-cmd --reload
```
MongoDB [Ubuntu 24.04/22.04]
**In order to start and enable service:**
```
sudo systemctl enable mongod
sudo systemctl start mongod
sudo systemctl status mongod
```
With an admin without password you can now access your MongoDB instance, run command.
**Launch the MongoDB Shell**
```
mongosh
```
**View Available Databases**
Once inside the shell, run:
```
show databases;
```
**Expected Output:**
```
admin 40.00 KiB
config 12.00 KiB
local 72.00 KiB
```
**Exit the MongoDB Shell**
Press `Ctrl + Z` to exit the shell and return to the command prompt.
**For secure access to Mongo DB (Optional)**
**Step 1: Start MongoDB Shell**
```
mongosh
```
**Step 2: Switch to `admin` Database**
```
use admin
```
**Step 3: Create an Admin User with Password**
Replace `YourStrongPassword123!` with your own strong password.
```
db.createUser({
user: "admin",
pwd: "YourStrongPassword123!",
roles: [ { role: "root", db: "admin" } ]
})
```
**Step 4: Enable Authentication**
Edit the MongoDB config file:
```
sudo nano /etc/mongod.conf
```
Find the section:
```
#security:
```
Uncomment and enable:
```
security:authorization: enabled
```
Save and exit (`CTRL+O`, `CTRL+X`).
**Step 5: Restart MongoDB**
```
sudo systemctl restart mongod
```
**Step 6: Log in with Password**
Now you must use your username and password:
```
mongosh -u admin -p YourStrongPassword123! --authenticationDatabase admin
```
MongoDB [Alma Linux 9.5/8.10]
**In order to start and enable service:**
```
sudo systemctl enable mongod
sudo systemctl start mongod
sudo systemctl status mongod
```
**Open Firewall (Optional for remote access):**
```
sudo firewall-cmd --zone=public --add-port=27017/tcp --permanent
sudo firewall-cmd –reload
```
With an admin without password you can now access your MongoDB instance, run command.
**Launch the MongoDB Shell**
```
mongosh
```
**View Available Databases**
Once inside the shell, run:
```
show databases;
```
**Expected Output:**
```
admin 40.00 KiB
config 12.00 KiB
local 72.00 KiB
```
**Exit the MongoDB Shell**
Press `Ctrl + Z` to exit the shell and return to the command prompt.
**For secure access to Mongo DB (Optional)**
**Step 1: Start MongoDB Shell**
```
mongosh
```
**Step 2: Switch to `admin` Database**
```
use admin
```
**Step 3: Create an Admin User with Password**
Replace `YourStrongPassword123!` with your own strong password.
```
db.createUser({
user: "admin",
pwd: "YourStrongPassword123!",
roles: [ { role: "root", db: "admin" } ]
})
```
**Step 4: Enable Authentication**
Edit the MongoDB config file:
```
sudo nano /etc/mongod.conf
```
Find the section:
```
#security:
```
Uncomment and enable:
```
security:authorization: enabled
```
Save and exit (`CTRL+O`, `CTRL+X`).
**Step 5: Restart MongoDB**
```
sudo systemctl restart mongod
```
**Step 6: Log in with Password**
Now you must use your username and password:
```
mongosh -u admin -p YourStrongPassword123! --authenticationDatabase admin
```
Redis Server [Ubuntu24.04/22.04] / AlmaLinux 9.5/8.10
You can access your Redis instance using the default admin user without a password. To verify connectivity and run basic commands, please follow the steps below:
**Launch the Redis CLI:**
```
redis-cli
```
**At the prompt, test the connection by running:**
```
ping
```
You should see the response:
```
PONG
```
To exit the Redis CLI, simply type: exit
LAMP [Ubuntu24.04/22.04]
**Getting Started After Deploying LAMP**
**LAMP MOTD**
On your first SSH login to the VM or launch of the VM console of your PhpMyAdmin VM 1-Click; you will be greeted by a message of the day which includes the admin password for your PhpMyAdmin instance:
**LAMP passwords location**
If for any reason, you are unable to access the message of the day, you can get the admin password by simply reading the /root/.neoncloud\_password file in your VM:
**PhpMyAdmin login screen**
With an admin password, you can now access your PhpMyAdmin instance, by visiting:
```
http:///phpmyadmin
```
Username → admin\
Password → StrongPass123!