How to install and configure MYSQL application

mierlp · Post by **mierlp** » Fri 23 Nov 2007 17:14

hi,

I've created a application using MySQL and Data Access Components
Works great, but now i have to deliver it to a lot of customers.
So i was wondering what's the best way to do this.
MySQL setup is easy, but the difficult part is to config the users/computers
which need to have access to MYsql. How can i automate it so when
installing it on 1 computer this computer/user has access to mysql or
even when i need to install it on a server with 3 computers.

Greetings Peter

Antaeus · Post by **Antaeus** » Mon 26 Nov 2007 15:28

As far as I understood, you want your application can connect to MySQL server from different computers, and you do not want to create accounts for each computer/user. In this case you can create several accounts in MySQL and let them connect to your server from several hosts. You can use wildcards like ‘%’, ‘_’ in the computer name when granting privileges. For more information see the GRANT Syntax description in the MySQL Reference Manual.