MySQL Forums
Forum List  »  Newbie

How to create scripts for final users
Posted by: Claudia Merida
Date: August 09, 2004 04:03PM

Hi everybody,

I have some experience in Microsoft SQL server. But I am a new MySQL user.
We have an online MySQL database hosted outside our office.
I need to build batch files/scripts that content defined queries. We need some final users (secretaries for example) to just click an icon in their desktop and run the query and then save it in CSV format.

What is the best way to do this?


I installed mysql on MS Windows XP Pro:
---------------------------------------
C:\mysql\bin>mysqlshow
+-----------+
| Databases |
+-----------+
| test |
+-----------+

C:\mysql\bin>mysqlshow -u root mysql
Database: mysql
+--------------+
| Tables |
+--------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+--------------+

C:\mysql\bin>mysqladmin version status proc
mysqladmin Ver 8.40 Distrib 4.0.20a, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.0.20a-nt
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 1 hour 46 min 0 sec

Threads: 2 Questions: 1289 Slow queries: 0 Opens: 6 Flush tables: 1 Open ta
bles: 0 Queries per second avg: 0.203
Uptime: 6360 Threads: 2 Questions: 1289 Slow queries: 0 Opens: 6 Flush tabl
es: 1 Open tables: 0 Queries per second avg: 0.203
mysqladmin: process list failed; error: 'Access denied. You need the PROCESS pri
vilege for this operation'
----------------------------------------------

When I try to connect the database by executing:
C:\mysql\bin>mysql -h staging.starrynight.ca -u snc-dev -p
Enter password: ******
ERROR 2003: Can't connect to MySQL server on 'staging.starrynight.ca' (10060)

I receive the mentioned error message.

I will really appreciate your suggestions.

Claudia
claudiajimenita@hotmail.com

Options: ReplyQuote


Subject
Written By
Posted
How to create scripts for final users
August 09, 2004 04:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.