LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 11-08-2005, 02:14 AM   #1
dimsh
Member
 
Registered: Aug 2005
Distribution: Debian, Ubuntu, Fedora
Posts: 74

Rep: Reputation: 15
MySQL Can't connect to DB when passing passwd on command line


Hi,

On a linux box FC4 & MySQL Ver 14.7 Distrib 4.1.14" , I am using this command line to connect to mysql:
Code:
mysql -u root -p
then I am prompted to enter password, it is ok here no problem.


I need to use this command line
Code:
mysql -u root -p=passwd
I get
Code:
Access denied for user 'root'@'localhost' (using password: YES)
, although the password is correct.

I want this command to be available to be able to connect to my DB remotely using a client like "SQLyog"


How can I enable this command and why it is not working?

Thanks

Last edited by dimsh; 11-08-2005 at 02:15 AM.
 
Old 11-08-2005, 02:31 AM   #2
bathory
Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 10,883

Rep: Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322
Quote:
mysql -u root -p=passwd
You must write:
Code:
mysql -u root -ppasswd
i.e. your password must be right after the "p" without any space in betwwen.

Regards
 
Old 11-08-2005, 02:38 AM   #3
dimsh
Member
 
Registered: Aug 2005
Distribution: Debian, Ubuntu, Fedora
Posts: 74

Original Poster
Rep: Reputation: 15
Many thanks , it is working.
 
  


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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
connect to internet using command line ic_torres Slackware 5 12-05-2005 04:35 AM
How can I connect to my local machine using FTP at the command line? imagirlgeek Linux - Newbie 12 08-26-2004 02:57 PM
Command line direct connect client? Lenny Linux - Software 1 09-22-2003 01:41 AM
MySQL 4.0.12 - command-line tetractis Programming 0 07-04-2003 06:00 AM
MySQL command line buddy Linux - General 3 01-16-2003 08:14 AM


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

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration