LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-27-2003, 09:55 PM   #1
studentforever
LQ Newbie
 
Registered: Jun 2003
Posts: 27

Rep: Reputation: 15
starting mysql


Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! what does this mean?
 
Old 07-27-2003, 11:05 PM   #2
dkaplowitz
Member
 
Registered: Oct 2002
Location: Havertown PA
Distribution: Ubuntu/RHEL/Fedora
Posts: 253

Rep: Reputation: 31
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.
 
Old 07-28-2003, 01:11 AM   #3
haobaba1
Member
 
Registered: Jul 2003
Location: VA Tech
Distribution: Mandrake 9.1
Posts: 73

Rep: Reputation: 15
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.
 
Old 07-28-2003, 02:20 AM   #4
studentforever
LQ Newbie
 
Registered: Jun 2003
Posts: 27

Original Poster
Rep: Reputation: 15
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.
 
Old 07-28-2003, 02:41 AM   #5
balaji2001com
Member
 
Registered: Jun 2003
Location: Chennai,India
Distribution: Almost all the flavours of linux
Posts: 39

Rep: Reputation: 15
start ur mysql using
safe_mysqld &
or check whether ur mysql is running
 
Old 07-28-2003, 02:50 AM   #6
studentforever
LQ Newbie
 
Registered: Jun 2003
Posts: 27

Original Poster
Rep: Reputation: 15
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
 
Old 07-28-2003, 03:00 AM   #7
balaji2001com
Member
 
Registered: Jun 2003
Location: Chennai,India
Distribution: Almost all the flavours of linux
Posts: 39

Rep: Reputation: 15
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.
 
Old 07-28-2003, 03:05 AM   #8
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

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

Cool
 
Old 07-28-2003, 03:18 AM   #9
balaji2001com
Member
 
Registered: Jun 2003
Location: Chennai,India
Distribution: Almost all the flavours of linux
Posts: 39

Rep: Reputation: 15
thanks for ur compliment buddy
 
Old 07-28-2003, 03:19 AM   #10
studentforever
LQ Newbie
 
Registered: Jun 2003
Posts: 27

Original Poster
Rep: Reputation: 15
thank you I really appreciate your help...it is running. I checked by typing
ps auwx | grep msyqld
 
Old 09-18-2003, 05:34 PM   #11
jacsmith510
LQ Newbie
 
Registered: Sep 2003
Posts: 4

Rep: Reputation: 0
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 07:23 AM
Starting MySQL... darkarcon2015 Slackware 52 12-28-2005 06:52 AM
Help starting up mysql . rullman Linux - Software 4 05-24-2004 06:00 AM
Starting up MySQL bwreath Linux - Software 2 01-20-2004 04:20 PM
starting mysql apax Linux - Newbie 4 12-28-2003 08:50 AM


All times are GMT -5. The time now is 08:41 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration