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. |
Try this:
mysql -u root -p |
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..... |
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 08:34 PM. |