LinuxQuestions.org
Visit Jeremy's Blog.
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 10-17-2005, 08:31 PM   #1
lord-fu
Member
 
Registered: Apr 2005
Location: Ohio
Distribution: Slackware && freeBSD
Posts: 676

Rep: Reputation: 30
mysql accounts


Hello,
I am running freeBSD 5.4 and MySQL 4.1.
I have read tons of documentation on this topic but none seems to solve my issue. Mostly from this site..

http://dev.mysql.com/doc/refman/4.1/...tallation.html

I start mysql like so

OSIRIS# ./mysql-server.sh start --user=mysql &
[1] 16844

make sure it is running

OSIRIS# ps u | grep mysql
root 16876 0.0 0.1 352 204 p0 R+ 8:54AM 0:00.00 grep mysql
[1] + Done ./mysql-server.sh start --user=mysql

just to test version

OSIRIS# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I get this on every command I try almost. I need to change root password but I get the above error...well here I'll try it.

OSIRIS# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

OSIRIS# mysqladmin -u root password "password"
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Same thing everytime.I have tried with the --skip-grant-tables option....tried creating a file with the pass in it and forcing to read from that.....really really stuck here.Just trying to get my foot in the door on this, could someone help me please?
On a side note, didn't think it would matter but I have tried this with firewall dropped also.
 
Old 10-17-2005, 09:08 PM   #2
stickman
Senior Member
 
Registered: Sep 2002
Location: Nashville, TN
Posts: 1,552

Rep: Reputation: 53
Try this:
mysql -u root -p
 
Old 10-17-2005, 09:12 PM   #3
lord-fu
Member
 
Registered: Apr 2005
Location: Ohio
Distribution: Slackware && freeBSD
Posts: 676

Original Poster
Rep: Reputation: 30
Thanks for the reply, while talking to one of my freinds online and after a little bit of flaming (a little hot in here now).I was told to do this
mysql status --password
Which then prompted me for a password and I was able to change.
If there is anything else I should have done or do please inform me,like I said I am following from the above link.Pretty much step by step.
Thank you.
[edit]
Got excited and ahead of myself, actually my buddies idea did not work. So I tried the above and still recieved the same error.
OSIRIS# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
OSIRIS# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I also have tried with a blank pass, and everypassword I have ever used just in case I might have set it along the line somewhere.....

Last edited by lord-fu; 10-17-2005 at 09:24 PM.
 
Old 10-18-2005, 04:07 PM   #4
comprookie2000
Gentoo Developer
 
Registered: Feb 2004
Location: Fort Lauderdale FL.
Distribution: Gentoo
Posts: 3,291
Blog Entries: 5

Rep: Reputation: 58
Did you run mysql_install_db
http://dev.mysql.com/doc/refman/4.1/...tallation.html
 
  


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
samba accounts/ unix accounts Buzz88 Linux - Newbie 3 09-25-2005 08:16 AM
qmail -- new accounts can't receive mail, but old accounts can b:z *BSD 1 07-13-2005 12:42 AM
Copying MySQL and Email Accounts imangm Linux - Newbie 3 01-28-2005 05:13 AM
MySQL user accounts. How do I modify them? correro Linux - Software 3 03-15-2003 07:39 PM
libnss-mysql (Store your UNIX user accounts in MySQL) markus1982 Linux - Security 0 01-26-2003 02:24 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:33 PM.

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
Open Source Consulting | Domain Registration