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