I have created apache but to install many websites I need to always use the root username and password! Can I make it so each website is it's own root so if any one website gets hacked there not all at risk? so in general I would like to have a username password with each website database!
If you are saying that you want a username n password for each DB... then yes it is possible just in case you are using cPanel goto MySQL Databases there you can create separate usernames and passwords for different databases... or in case you are not having cPanel goto phpMyAdmin, click the privileges button then create a username n password having different right n access to different databases... Hope this helps!
Thanks Rashy I took a closer look and after your explanation I got it and have now added a username and password to each separate database! Thanks so much
as root do an 'adduser' command. This will create a user and password for each. In /etc/passwd you can then specify the users home directory. If you however want to limit SSH access you could setup an FTP server and grant each FTP user access to a specific site only.
Thanks guys I got this all done and it's working great! I still need help here tho, http://forums.digitalpoint.com/showthread.php?t=1104220 http://forums.digitalpoint.com/showthread.php?t=1104220 http://forums.digitalpoint.com/showthread.php?t=1104298 Cheers