LinuxQuestions.org
Visit Jeremy's Blog.
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 03-06-2004, 09:41 PM   #1
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Rep: Reputation: 36
mysql installation weird...


I downloaded mysql 4.0 and I'm following this tutorial: http://www.madpenguin.org/Article751.html

apache went well so far... but mysql is weird. I did the ./configure thing but I got a bunch of stuff and it said that it did not need to do a configure. then I typed make and just got an error make: *** No rule to make target `install'. Stop. and same thing for make install.

But I can't do anything, I can't start mysql. I was even playing with some of the executables and one of them told me I need to do a make install first. what the heck is going on? It should let me do the make install but it's not. and yes I'm doing it from the right folder (main mysql folder).

any suggestions on why this is happening?
 
Old 03-06-2004, 09:43 PM   #2
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Original Poster
Rep: Reputation: 36
I noticed a few threads here with some of the issues I'm having such as the "mysql ended" when I try to start the mysqld_safe, when I try to start the mysqld I just get some error saying to read the manual about running it under root (I AM under root). Since these issues seem to be known, should I maybe use an older version, would it solve the problems?
 
Old 03-07-2004, 08:45 AM   #3
MunterMan
Member
 
Registered: Nov 2003
Location: The North of England
Distribution: Suse 10.3
Posts: 172

Rep: Reputation: 30
It looks like it wont install because you already have it.
Is mysql running? It is started by the system at bootup.
Try this;

ps aux|grep mysqld

If it is running, stop it with
/usr/local/bin/mysqld stop

then restart it with
/usr/local/bin/safe_mysql &

I am using version 4.0.15 with Mandrake 9.2 without problems (so far).
 
Old 03-07-2004, 09:43 AM   #4
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
You downloaded the source code yeah, not the binary versions? I've done the same thing myself when I've been a bit quick on the mouse buton.
 
Old 03-07-2004, 01:14 PM   #5
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Original Poster
Rep: Reputation: 36
That's the thing, I don't know what I downloaded, I just downloaded whatever mysql.com gave me. How can I tell if it's source or binnary? I don't have it installed already either. If I type mysqld out of nowhere it just says it's an invalid command. I need to go in the bin folder and use the ./ method.
 
Old 03-07-2004, 01:20 PM   #6
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 64
When you went to mysql.com you had the choice of binary of source. I can't imagine it "gave" you one in particular. You can see a list of downloads for mysql 4 at:
http://www.mysql.com/downloads/mysql-4.0.html
 
Old 03-07-2004, 03:09 PM   #7
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Original Poster
Rep: Reputation: 36
I downloaded the first one in the list.
Linux (x86, libc6) Standard 4.0.18 15.1M

Is that the right one?
 
Old 03-07-2004, 03:13 PM   #8
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
Not if you want to compile it. The source code is right down the bottom of the page or click on the source downloads link on the page.
 
Old 03-07-2004, 03:26 PM   #9
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Original Poster
Rep: Reputation: 36
I noticed that, but what about this?

"For maximum stability and performance, we recommend that you use the binaries we provide."

Does it mean it will crash allot if I use those? They seem to be more of a "use at your own risk" bassis and that, I don't like.

Last edited by Red Squirrel; 03-07-2004 at 03:28 PM.
 
Old 03-07-2004, 03:57 PM   #10
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
Well I haven't had it crash on me, the downloadable documention has siggested compiler directives you can use when compiling to make it as stable as possible, I guess all the downloads are "use at your own risk" unless you actually pay the good folk for a license/support or whatever.
 
Old 03-07-2004, 05:01 PM   #11
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Original Poster
Rep: Reputation: 36
I got it installed, I have no clue wether it's good or not, but now I need to start it, how do I do that? mysqld_safe returns this:

The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/mysqld_safe.


I tried doing what it says, nothing. I also tried mysqld but it can't find it.
 
Old 03-07-2004, 05:20 PM   #12
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
Look in especially for the mysql_install_db

/usr/local/mysql/bin


you might want to copy over one of the example configurations i.e mysql_small .cnf to
/etc/my.cnf examples are in the /usr/local/mysql/ subdirectories, have a look around in them.
 
Old 03-07-2004, 06:12 PM   #13
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Original Poster
Rep: Reputation: 36
well I'm getting somewhere... now when I try to start mysqld I only get this instead of that other error I got before.


[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/data
040307 19:10:07 mysqld ended

[root@localhost mysql]#


What what's bothering me is that if I only use mysqld it says it does not exist.... that's the right one, mysqld_safe is only to test right?
 
Old 03-07-2004, 06:17 PM   #14
Red Squirrel
Member
 
Registered: Dec 2003
Distribution: FC9 on main server
Posts: 784

Original Poster
Rep: Reputation: 36
Sweet! I was not done the tutorial and I had to do

chown -R root:mysql /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql/data

Now it works (I think... it does not end). But can someone explain what those commands actually do?


Edit: all is working for me now, apache, php and mysql!!!

only took me a few weeks.

Last edited by Red Squirrel; 03-07-2004 at 07:54 PM.
 
Old 03-08-2004, 08:19 AM   #15
MunterMan
Member
 
Registered: Nov 2003
Location: The North of England
Distribution: Suse 10.3
Posts: 172

Rep: Reputation: 30
You have changed the ownerhip of the files.
The first command changed the ownership of the mysql binary to root, so only root can run it.
The second one changed the data to mysql users who are members of the group mysql, so any users who are members of the group 'mysql:' can access the data.

For more on groups and users see the mandrake documentation page.
http://www.mandrakelinux.com/en/fdoc.php3

For more on chown, and other linux commands see;
http://man.he.net/?topic=chown&section=all
http://man.linuxquestions.org/index....ction=0&type=2
 
  


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
mysql-installation: Not enough space in /var/lib/mysql/ linus123 Linux - Software 8 11-10-2006 02:19 PM
PHP-MySQL Weird Error Fordor Slackware 2 02-24-2005 12:01 PM
MySQL 3.23.58-14 installation prolem - mysql.sock not found lightcom Linux - Software 4 02-23-2005 12:46 AM
php4 mysql, installation, php-pages with mysql info stay empty dnla Linux - Software 2 03-14-2004 02:54 PM
Weird installation problem... dyvvu Slackware - Installation 5 03-14-2004 01:35 AM


All times are GMT -5. The time now is 03:17 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration