MySQL basic question

Jan Schenkel janschenkel at yahoo.com
Thu Oct 14 02:38:32 EDT 2004


--- Bill Vlahos <bvlahos at mac.com> wrote:
> I don't know much about SQL access so sorry about
> this basic question.
> 
> We use A1 Support Pro HelpDesk style ticket tracking
> system where I 
> work. It consists of MySQL database running on a Mac
> OS X computer, 
> PERL scripts, and Apache web server. The system
> works really well for 
> us and is very inexpensive. (It would make a great
> Revolution app. but 
> that is another story).
> 
> 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?
> 
> Thanks,
> Bill Vlahos
> 

Hi Bill,

To connect, you'll need :
- IP address of the server
- Network port (only if it deviates from the standard
port)
- Name of the database

You could take apart the PERL code to figure out the
user name and password that it uses to connect to the
database.
Or you could add a new user to the MySQL database
(this doesn't have to be a new user on the server
machine!) and GRANT that user permission to SELECT
data from that database.

That way you can rest assure no changes are made by
the  Revolution front-end; and if you don't need to
add data you could always use the Automated Database
Queries to quickly develop a working application.

Hope this helped,

Jan Schenkel.

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the Use-livecode mailing list