I am getting conflicting information on how and who should install MySQL on our virtual host account. The hosting company has Solaris servers that seem to have MySQL installed under /usr/local/mysql. We have asked them to create a database for our domain. They have replied and said the web developer must INSTALL MySQL on our domain. My understanding is we would need ROOT access to do a MySQL install, is this correct? Is it normal to have a separate MySQL installation for each domain on a shared server? Or is the hosting provider supposed to create a Database in the shared install of MySQL, then setup rights for our domain only? Any insight into our problem is greatly appreciated.
Thanks,
Spencer
Usually, there's one copy of MySQL installed, and the sysadmin/root user would create you a database, and set up a user that has access to it, giving you the username/pass for that database.
