starting mysql
 

Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! what does this mean?

How did you install MySQL? If after installing it, have you created a password for root?

You should start MySQL with something like

mysql -h localhost -p -u root

Then it should prompt you for a password. If you've not created the root pass, it's real simple, just search on mysql.com for "root password" and it'll tell you how to change it.

if you have trouble and can't login because of a lost or unknown password for the root then you have to stop the mysql server by killing it or if you are using mandrake like I am and the mysql server started up at a boot time then you have to kill mysql in the mandrake control center then restart mysql like so:
mysqld --skip-grant-tables
then you will be able to set a new password for root.

ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

I am now getting the above error. I'm new to linux. Steps to produce this error

1. went to /etc/init.d
2. then I mysql start

Please tell me what I'm doing wrong. I spoke to someone on Friday who told me these were the correct steps, however , I 'm getting the above error. Whe I first installed mysql I was able to get mysql prompt, now I'm not. I checked to see if the process is running and it says that it is running under root. Also when I checked the init.d directory, I see mysqld. Should I start mysqld?


Are there any good references out there that I might purchase? Mysql cookbook is not very helpful.

start ur mysql using
safe_mysqld &
or check whether ur mysql is running

what is ur? how do you check? Let me get this straight I'm suppose to in the /etc/init.d directory type

start ur mysql

check whether ur mysql service is running by listing the process
the line
safe_mysqld &
is supposed to be present in ur konsole.just type safe+TAB u'll see the options if there is nothing then u have to think abt reinstallation of mysql.

Translation from MasterC:
ur = Your
u = You
abt = About
u'll = You'll

Cool

thanks for ur compliment buddy :D

thank you I really appreciate your help...it is running. I checked by typing
ps auwx | grep msyqld

Problem launching Mysql 3.23.56 on Linux
 

Dear Colleagues, please let me know any suggestions. I have tried to install MySQL 3.23.56- rpm package on red hat 9.0 and the install goes without error but when I try to lauch I receive the error 2002, unable to conect to mysql.sock and when I check I fdo not see msql running as a process. Please let me know any suggestions and thanks again