I downloaded MySQL version 4, as wanting to evaluate it as a VB/Access replacement as Access limited. I installed MySQL, although I think I did, but there is no greeting shortcut, and no direction as to whether it has any comunication to the world forms etc. How do you kick start it to know its there? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you wake up MYSQL?
- Thread starter ZOR
- Start date
sleipnir214
Programmer
You have to remember, MySQL is not a replacement for Access. MySQL is closer to a replacement for SQL Server.
MySQL has no user interface. Generally you must look for the presence of the mysqld application in your list of active applications to determine whether it's running.
Want the best answers? Ask the best questions: TANSTAAFL!!
MySQL has no user interface. Generally you must look for the presence of the mysqld application in your list of active applications to determine whether it's running.
Want the best answers? Ask the best questions: TANSTAAFL!!
PROFESSORSPARKIE
Instructor
MySQL on your system runs as a dameon/server
program in the background. You should start the
server in your system each time you start your
system for SQL support.
I do this with a .bat file in a DOS shortcut in my
STARTUP folder under windows.
The command I use, for my education class, to let
students run standalone is :
C:>MYSQLD-SHAREWARE --standalone
note the 2 dashes in front of standalone. Also the
parameter is in lower case.
There are other format options for the server on
a network.
Now each time I start up my system I have MySQL
running in the background.
To shutdown the server execute:
c:>MYSQLADMIN.EXE shutdown
To verify, just press CTRL-ALT-DEL and you will
see the program is running.
It just does not have a window.
It is up to the application program(client) to communicate
with the server or you can use the mysql interactive program to enter & execute a statement at a time. Since this program is written like a filter you can write a group of statements in a script and redirect them into the interactive interface.
A sample is"
C:>MYSQL <A:CUST_QUERY.SCR >lpt1:
program in the background. You should start the
server in your system each time you start your
system for SQL support.
I do this with a .bat file in a DOS shortcut in my
STARTUP folder under windows.
The command I use, for my education class, to let
students run standalone is :
C:>MYSQLD-SHAREWARE --standalone
note the 2 dashes in front of standalone. Also the
parameter is in lower case.
There are other format options for the server on
a network.
Now each time I start up my system I have MySQL
running in the background.
To shutdown the server execute:
c:>MYSQLADMIN.EXE shutdown
To verify, just press CTRL-ALT-DEL and you will
see the program is running.
It just does not have a window.
It is up to the application program(client) to communicate
with the server or you can use the mysql interactive program to enter & execute a statement at a time. Since this program is written like a filter you can write a group of statements in a script and redirect them into the interactive interface.
A sample is"
C:>MYSQL <A:CUST_QUERY.SCR >lpt1:
- Status