-
June 24th, 2002, 05:17 AM
#1
Member
MySQL root password
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.
Sitting Duck Security check it out
(All right, all right, you guys talked me into it, I will just learn PHP instead of using ASP.)
-
June 24th, 2002, 05:26 AM
#2
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
-
June 24th, 2002, 05:32 AM
#3
Senior Member
# 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
#
-
June 24th, 2002, 05:43 AM
#4
Member
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.
Sitting Duck Security check it out
(All right, all right, you guys talked me into it, I will just learn PHP instead of using ASP.)
-
June 24th, 2002, 05:51 AM
#5
Senior Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|