Hi, everyone. I would like to find out how to create separate databases space and user account for users in Mysql. I really appreciate if someone could assist me.

Regards,
Major Dynamic123

Search the MySQL site for "grant" and "create database"

HTH,

Chris

Hi, Chris. Thanks for the reply.

Currently, I am trying to allow client computers(Mac OS9 and Windows) to access the database via the LAN. I've successfully installed Mysql Server 4.1, Mysql Administrator(GUI), Mysql System tray monitor and Mysql query browser.

How do I go about setting up the client machines so that they can connect to the database server which I've installed on windows xp?

Appreciate if you could provide some guidelines.

Thanks.

Regards,
Major

Hi Major,

You can create different users in MySQL and include the machine names they will be accessing from using the GRANT statement, e.g.

GRANT ALL ON mydatabase.* TO myusername@myservername IDENTIFIED BY mypassword;

then

FLUSH PRIVILEGES;

Then you then can connect to your db from server myservername using username myusername.

HTH,

Chris