BellaOnline
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo



new
Natural Living
Folklore and Mythology
Baptist
Florida
Cosmetics
Distance Learning
Reading




dailyclick
All times in EST

Clairvoyance: 08:00 PM

Full Schedule
g
g ASP Site

BellaOnline's ASP Editor

g

Basic MySQL Commands


If you're just getting started with MySQL, here are the basic commands to work with your database.

Starting MySQL:
To start MySQL, type in the command:

mysqld-nt --defaults-file="INIFILENAME"

You can put that in as a service, as long as you give the full proper path before both the executable name and the defaults file name.

To monitor what MySQL is doing, go to a command prompt and type:

mysql -u root -p

the system will prompt you for the root password, and then give you a

mysql>

prompt. You can now type in commands to mysql, to find out its health. When you're done, type in

quit

to get out of the tool.

from the command line you can also type

net stop mysql
net start mysql

to start and stop the mysql service, assuming you have the service set up properly with that name.

Add Basic+MySQL+Commands to Twitter Add Basic+MySQL+Commands to Facebook Add Basic+MySQL+Commands to MySpace Add Basic+MySQL+Commands to Del.icio.us Digg Basic+MySQL+Commands Add Basic+MySQL+Commands to Yahoo My Web Add Basic+MySQL+Commands to Google Bookmarks Add Basic+MySQL+Commands to Stumbleupon Add Basic+MySQL+Commands to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the ASP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2018 by Lisa Shea. All rights reserved.
This content was written by Lisa Shea. If you wish to use this content in any manner, you need written permission. Contact Lisa Shea for details.

g


g features
Regular Expression Pattern Matching

Split ASP String Function

Saving Changes is Not Permitted error

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter

Note: BellaOnline uses cookies to help provide a consistent user experience. Our advertisers may use cookies to help customize ads. Please contact us with any question about our cookie use.



vote
Summertime Foods
Corn on the Cob
Sangria
Burgers on the Grill
Apple Pie



g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2018 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor