I host a couple of website and I currently have a open MySQL account for them. Is it save for them to all share one account? If not, how do I have PHP create users on a linux Fedora Core 5 (it would use cron or what ever is needed)
I would suggest a different database (if your hosting can afford it) and definitely setup different usernames/passwords for each site. This reduces your exposure to the risk of someone finding out what the username is, in which case you will only potentially have one site down instead of all of them. How? If you have access to phpMyAdmin then you might be able to do it from there. If not, or if you have access but don't have the rights, then you will need to ask your webhost to create some accounts for you. Be aware that some hosts only give you one account, so asking for more may cost you something. It's really up to you i guess, are you happy to put up with the risk of using one username/password across all sites? Jay