I just got a server and want to setup mySQL DB for the shared hosting users.

As I have no experience in setting up mySQL for shared users, I need some advice and help here.

1. Is there any particular issues that i need to pay attention to?

2. What is the best web-based interface for user to manage the DB?

3. Will users see other databases? I have been using MS SQL and it shows all the databases, which is no good. Can mySQL prevent such disadvantage? If yes, how to?

Thanks!!!!

Welcome to WHT :)

1. User accounts and rights. Make sure people can't see other people's database, or can't write over other's databases.

2. http://www.phpmyadmin.net

3. Depends on how you configure the database. Use the program mentioned in number 2.

http://www.mysql.com/manual :)