LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-01-2003, 03:22 AM   #1
Z28kid
Member
 
Registered: Jan 2003
Location: Long Island
Posts: 72

Rep: Reputation: 15
Need help with my sql..


i can't seem to get it started or even find the directory. when i do a search this is what i get for my sql..

/usr/bin/mysql

/usr/lib/mysql

/usr/include/mysql

I get all these when i do a seach.. What do they mean?

Also how do i get mysql running???
 
Old 03-01-2003, 03:01 PM   #2
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
If you have mysql installed correctly you can start it by doing:

/etc/init.d/mysqld start

Remember there is a mysql server and mysql client package.
 
Old 03-01-2003, 04:44 PM   #3
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Rep: Reputation: 78
If you don't have the init script then there is a script that comes with MySQL for starting the server. It should be in /usr/bin according to what you stated above. It's called safe_mysqld and you can run it like this:

/usr/bin/safe_mysqld&

be sure to add the '&' or your console will be tied up.
 
Old 03-01-2003, 07:55 PM   #4
Z28kid
Member
 
Registered: Jan 2003
Location: Long Island
Posts: 72

Original Poster
Rep: Reputation: 15
i did "/ect/int.d/mysqld start" and it said there was no such file or directory.

Then i did "/usr/bin/safe_mysqld&" and it said [1] 1138 then after that it said "bash: /usr/bin/safe_mysqld:" no file or directory

I am totally confused about this. i can't seem to get it started

anymore help please???
 
Old 03-01-2003, 07:59 PM   #5
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
It seems as though you don't have MySQL installed. If you are running RedHat 8.0 go to System Settings->Packages . You can install all the necessary packages for MySQL from there.
 
Old 03-01-2003, 08:22 PM   #6
Z28kid
Member
 
Registered: Jan 2003
Location: Long Island
Posts: 72

Original Poster
Rep: Reputation: 15
i did have it installed but i took it out.

anyway i did "/usr/bin/safe_mysqld&"

This is what i got:

[1]

starting mysqld daemon with databases from /var/lib/mysql

mysqld ended.

is it suppose to end?
 
Old 03-01-2003, 08:23 PM   #7
Z28kid
Member
 
Registered: Jan 2003
Location: Long Island
Posts: 72

Original Poster
Rep: Reputation: 15
oops i meant to say i took it out but i reinstalled it and i got those things from previous post.
 
Old 03-01-2003, 08:26 PM   #8
Z28kid
Member
 
Registered: Jan 2003
Location: Long Island
Posts: 72

Original Poster
Rep: Reputation: 15
i just did ps -ax and at the end of it i got:

[1]+ Done /usr/bin/safe_mysqld

then i did ps -ax again and nothing came up.

any help?

sorry for posting so many times but this is getting to me.
 
Old 03-01-2003, 11:09 PM   #9
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Rep: Reputation: 78
This might be becuase the user you are trying to run mysql as is not authorized. Create a user 'mysql' with group 'mysql' and try:
/usr/bin/safe_mysqld --user=mysql&
 
Old 03-02-2003, 08:37 PM   #10
Z28kid
Member
 
Registered: Jan 2003
Location: Long Island
Posts: 72

Original Poster
Rep: Reputation: 15
how would i give access to this user?
 
  


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
sql naflan Programming 6 11-14-2005 12:53 AM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 03:20 PM
my sql................ apenguinlinux Programming 2 01-24-2005 11:39 PM
Which SQL is suitable for EMbedded SQL on C? hk_michael Programming 4 01-10-2005 06:07 PM
what to do with -> ' <- in SQL? kvasarnomad Programming 3 10-16-2004 11:51 AM


All times are GMT -5. The time now is 10:24 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