questions about user accounts for virtual domains

Submitted by responsiveny on Thu, 09/15/2011 - 13:58

Two questions:

  1. when I create a new virtual domain, an administrative user is automatically created. It seems this user cannot ftp into the default website for the virtual domain. It is required to create another user for ftp purposes? If not, how can I enable the admin user to ftp files to the website for that virtual domain?

  2. How can I enable the user above to access the mysql server for the domain from outside, using an external tool like Navicat?

thanks

Status: 
Closed (fixed)

Comments

Submitted by andreychek on Thu, 09/15/2011 - 14:18

when I create a new virtual domain, an administrative user is automatically created. It seems this user cannot ftp into the default website for the virtual domain.

The admin user created when a Virtual Server is created should be able to upload files for that domain. You'd first need to go into the public_html folder.

How can I enable the user above to access the mysql server for the domain from outside, using an external tool like Navicat?

MySQL doesn't listen for remote connections for security reasons. If you like, that can be enabled.

First, go into Webmin -> Servers -> MySQL Database -> MySQL Server Configuration, and set "MySQL server port" to "3306", and "MySQL server listening address" to "0.0.0.0".

Then click "Save and Restart MySQL".

Second, you need to grant permissions for the user who is going to remotely access MySQL. To do that, go into Virtualmin, and select their domain from the drop-down on the top-left. Then click Edit Databases -> Remote Hosts, and add the IP address the user will be connecting from.