LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysql accounts (https://www.linuxquestions.org/questions/linux-software-2/mysql-accounts-374095/)

lord-fu 10-17-2005 09:31 PM

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.

stickman 10-17-2005 10:08 PM

Try this:
mysql -u root -p

lord-fu 10-17-2005 10:12 PM

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.....

comprookie2000 10-18-2005 05:07 PM

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


All times are GMT -5. The time now is 04:17 PM.