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!

MySQL - Newbie - How to start !!!

Status
Not open for further replies.

rbarun

Programmer
May 10, 2003
2
US
Hi all,
I am new to MYSQL. I unzipped MySQL.zip, but how do I start the database and run the query..

Thanks in advance for your time..


Rbarun

 
I assume you are using Windoz (MySQL.zip)

After installing it and making sure that the service has started, open DOS prompt,

go to c:\mysql\bin

>mysql -u root (press enter)


Now you are logged on MySQL prompt. You can issue your queries there.

To avoid having to go to c:\mysql\bin dir every time you log on, add the same path to autoexec.bat (an entry would be something like SET PATH = C:\MYSQL\BIN)

The first thing you should do is GRANT correct rights for user root

I suggest you start downloading the full manual



Bye


Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top