LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 01-16-2003, 07:54 AM   #1
buddy
LQ Newbie
 
Registered: Dec 2002
Location: Montreal
Distribution: Mdk9
Posts: 20

Rep: Reputation: 0
MySQL command line


Hey there mates,

Ok yet another potenitially stoopid question here - but I gotta ask.

I have Apache, MYSQL/PHP running [of course]. I noticed an error with one of my queries, and wanted to get the mysql command line to edit - but alas - I can't seem to get into it.

Could someone please give me the proper commands to get into the mysql command line so I can test and play around with the DB.

Cheers folks
Buddy
 
Old 01-16-2003, 07:58 AM   #2
te_conway
Member
 
Registered: Apr 2001
Location: MA
Distribution: redhat 7.2
Posts: 182

Rep: Reputation: 30
mysql -u (username) -p

This will prompt you for your password.

Then

use Database;
select ...

The select can be multiple lines trggered by the final semi-colon.
 
Old 01-16-2003, 08:01 AM   #3
buddy
LQ Newbie
 
Registered: Dec 2002
Location: Montreal
Distribution: Mdk9
Posts: 20

Original Poster
Rep: Reputation: 0
GREAT! cheers - and which file contains the passwords for the users? i'll get this one day I promise ...
 
Old 01-16-2003, 08:14 AM   #4
te_conway
Member
 
Registered: Apr 2001
Location: MA
Distribution: redhat 7.2
Posts: 182

Rep: Reputation: 30
The DB is MYSQL

I would read the docs on www.mysql.com about adding and granting privileges. It's quite good
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Can't connect to DB when passing passwd on command line dimsh Linux - Software 2 11-08-2005 02:38 AM
MySQL: Login as Blank User From Command Line tortle Linux - Software 1 05-14-2005 05:01 PM
Command to output file content line by line aznluvsmc Programming 2 09-12-2004 07:45 PM
51 characters only in the 1st Line of command line eggCover Linux - General 2 07-29-2004 01:28 PM
MySQL 4.0.12 - command-line tetractis Programming 0 07-04-2003 06:00 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 07:38 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration