Create a Database in Virtualmin Panel

  1. When logged in to VirtualMin Panel, select the site you want to add a database into and then click “Edit Databases.”
virtualmin edit database menu
  1. Click “Create a new database.”
virtualmin create database
  1. Enter the database name. In most cases, you won’t need to set the “Additional Options” but if you do, you can click that and set the Collation and Character set. Click “Create” when done.
virtualmin database details

Note:

Your database user is the server user. We recommend that you add additional users to the database and don’t use the main user for database access:

Create a Database User in Virtualmin Panel

Your database user is the server user. We recommend that you add additional users to the database and don’t use the main user for database access:

  • Navigate to “Edit Users”.
add ftp user virtualmin
  • Click “Add a user to this server”.
virtualmin server add user
  • After entering in the username and generating a password, click “Other user Permissions” . For “Login Permissions” choose “Email only”. Select the database you want them to have access to. Create the user.
virtualmin select database for user

Scheduling a Cron in Virtualmin Panel

Here’s how to set up a Cron in Virtualmin Control Panel as many scripts require. Cron is a service for executing scheduled commands. You’ll need to be logged in to Virtualmin in order to do the following.

  1. Navigate to Webmin > System > Scheduled Cron Jobs.
virtualmin schedule cron menu
  1. Click “Create a new scheduled cron job”.
virtualmin file manager upload
  1. Choose the user to run as for “Execute cron job as” . (See screenshot below for steps 3-6)
  2. Enter the command to run into the “Command” field. For example, if you want to receive a list of all running processes, enter ps auxw for the command. For more details on commands, please see your script developer.
  3. Normally, you can skip “Input to command.” That’s only used if your command requires input after it begins running.
  4. Description is optional but helps you to know what this cron does in case you have several crons.
  5. Choose how frequently to run your command. By default, it will execute Hourly, meaning it will execute at the top of the hour, every hour. The Run and Time would have been given by the script developer. Check with them if you don’t know.
  6. To enable the Cron job, click “Create.”
virtualmin file manager upload

Any output will be emailed to the root user.

Upload and Extract Files in Virtualmin Panel

Virtualmin Panel includes a file manager where you can upload and extract zip files or any other files.

We recommend uploading files via FTP. However, if you prefer to upload via the file manager, follow the steps below. Step 5 shows how to extract uploaded files, whether they were uploaded via FTP or by the file manager.

  1. When logged in to VirtualMin Panel, select the site you want to upload files into and then click “File Manager.”
virtualmin file manager menu
  1. To the right, you’ll see a list of files on the server, a list of domains, and various buttons at the top middle.
  2. Open the directory you want to upload to. Our screenshot shows the public_html folder open.
  3. At the top click File > Upload to Current Directory. Select the file from your computer then drag and drop it into the popup and click Upload.
virtualmin file manager upload
  1. If you’ve uploaded a compressed file (zip, tar, etc), to extract it click the ellipses to the left of the file and select “Extract.”
virtualmin file manager extract

Installing phpMyAdmin in Virtualmin Panel

If you want to install phpMyAdmin to manage your databases, here’s how.

Note: You first need to have created databases to manage.

  1. In the left menu, click “Install Scripts.”
virtualmin install phpmyadmin menu
  1. Select phpMyAdmin and click “Show Install Options” at the bottom.
virtualmin install phpmyadmin button
  1. Choose to manage all databases or to select databases to manage. Click “Install Now” when done.
virtualmin install phpmyadmin details

Add a Website in Virtualmin Panel

Here’s how to add a website or subdomain in the Virtualmin panel.

  1. Click “Create Virtual Server” in the menu on the left.
create virtualmin website
  1. Enter the domain name you want. If creating a subdomain, click the “Sub-server” button first and then enter the subdomain as you want it.
create website virtualmin domain name
  1. Click “Create Server” if you want to leave the default options as they are (recommended for those without advanced knowledge).

Tip:

If you want to see the IP of the server, for DNS and other things, you can click “IP Address and Forwarding” which will open to show the server IP.

create domain virtualmin ip address

Adding FTP Users in Virtualmin Panel

  1. When logged in to Virtualmin, select the domain you want to add an FTP user for and click “Edit Users” in the left menu.
add ftp user virtualmin
  1. Click “add a website ftp access user.”
add ftp user button
  1. Fill in the “username” and click the key icon next to the password input field. If you want, you can make your own password instead of using the secure password generator. You can leave the “Real name” field blank. If you want to set a password recovery email, fill that in, otherwise leave blank. You are now done unless you want to restrict this user’s access to specific directories. If so, continue with step 4.
add ftp user details
  1. Click “Other User Permissions” to restrict the user’s access. You can add directories that this user can access by clicking the one(s) on the left to add them to the allowed list.
add ftp user permissions
  1. When finished, click the Create button at the bottom. This FTP user will connect via FTP with the credentials you set.

Tips

  • If you can’t see directory listings with this FTP user, try changing your FTP program to Passive mode. If that doesn’t work, try Active mode.
  • In some cases, your ISP provider will block certain ports from access. If you cannot get the directory listing after trying the above, please contact our support.
  • A few FTP programs to try are FileZilla, Cyberduck, WinSCP, and there are many others.
%d bloggers like this: