MySQL basic question

Sarah Reichelt sarahr at genesearch.com.au
Wed Oct 13 22:36:18 EDT 2004


> We have someone who is tasked to run our own queries to the data base 
> to generate our own reports. I'm going to suggest he use Revolution 
> for this but I need to know what needs to be set up on the server side 
> for this. I'm thinking that the reports would be run on a computer 
> other than the MySQL server.
>
> What are the requirements for the MySQL server? Here is what I think I 
> need so far. Please let me know if this is wrong or incomplete.
> 	Name of data base
> 	Database admin login
> 	Database admin password
> 	Network port number
>
> Do I need to set up an account for the user on the Mac OS X computer?

Hi Bill,

You have just about all the info you need and unless the MySQL server 
has been altered to use a non-standard port, you don't need the port 
number. You will need the IP address of the computer hosting the 
server. The people accessing the MySQL server will not need user 
accounts set up on that computer, but they will need to be granted 
privileges to the database(s). Check the MySQL docs under "GRANT" for 
details on this.

Have a look at the 2 MySQL stacks on my web site which may help you 
debug the connections and get started.

Cheers,
Sarah
sarahr at genesearch.com.au
http://www.troz.net/Rev/



More information about the use-livecode mailing list