This is going to sound like a real n00b but I can't find it anywere, what command do I use to set the root password for mysql? I looked at the mysql command but I can't find any args to set the root password.
Printable View
This is going to sound like a real n00b but I can't find it anywere, what command do I use to set the root password for mysql? I looked at the mysql command but I can't find any args to set the root password.
http://www.mysql.com/doc/D/e/Default_privileges.html
hope this helps,
I dont want to flame you too hard, but, that was the very first item in the results for the google search listed below using the words MySQL set root password.
http://www.google.com/search?hl=en&i...+root+password
# mysqladmin -u root -p password '[newpassword]'
Enter password: [oldpassword]
and if you are setting up for the first time i recommend following up with.
# mysql -u root -p
mysql> use mysql;
Database changed
mysql> delete from user where user='';
Query OK, 1 rows affected (0.00) sec
mysql> exit;
Bye
#
yeah this is my first time using mysql, but now when I try to set the password I get,
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
:( Can someone help me get this working.
is mysql running?
i really agree IchNiSan, so far your questions have both been located in the authoritative locations - as well as many others. you might try searching for some of this, as the best anyone else is going to be able to do is provide you with what they either already know or have found _for_ you. in the event that you have tried what is suggested, then it would be advisable to return with specific evidence of the problem to query for more help. just my 2 cents on generic tech-help via bbs.
http://www.mysql.com/doc/C/a/Can_not...to_server.html
http://www.google.com/search?hl=en&i...Fmysql.sock%27