LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 09-26-2008, 04:22 AM   #1
leiw
Member
 
Registered: Apr 2006
Posts: 131

Rep: Reputation: 15
Tarball mysql installation problem


Hello,

The complie was sucessed, but I can't start the service by
/usr/local/share/mysql/mysql.server

[root@mysql mysql]# ./mysql.server start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
[root@mysql mysql]#

Thx
 
Old 09-26-2008, 05:28 AM   #2
prakash.akumalla
Member
 
Registered: Jun 2008
Location: India
Posts: 109

Rep: Reputation: 15
For successful installation you should follow these steps.

[root@localhost mysql-5.0.45]# groupadd mysql
[root@localhost mysql-5.0.45]# useradd -g mysql mysql
[root@localhost mysql-5.0.45]# ./configure --prefix=/usr/local/mysql--enable-thread-safe-client
make
make install


cp /mysql-5.0.45/support-files/my-huge.cnf /etc/my.cnf
cp /mysql-5.0.45/support-files/mysql.server /etc/rc.d/init.d/mysql
cd /etc/rc.d/init.d/
chmod 755 mysql
cd /data01/lamp/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
bin/mysqld_safe --user=mysql &

cd /usr/bin/
ln -s /usr/local/mysql/bin/mysql .
ln -s /usr/local/mysql/bin/mysql_config .
ln -s /usr/local/mysql/bin/mysqldump .
ln -sf -s /usr/local/mysql/bin/mysql .
cd /usr/lib/
ln -sf /usr/local/mysql/lib/mysql/lib* .
cd /usr/include/
mkdir mysql
cd /usr/include/mysql/
ln -sf /usr/local/mysql/include/mysql/* .



now you give service mysql start

then it will start successfully.

Regards,
Prakash.
 
Old 09-26-2008, 12:33 PM   #3
leiw
Member
 
Registered: Apr 2006
Posts: 131

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by prakash.akumalla View Post
For successful installation you should follow these steps.

[root@localhost mysql-5.0.45]# groupadd mysql
[root@localhost mysql-5.0.45]# useradd -g mysql mysql
[root@localhost mysql-5.0.45]# ./configure --prefix=/usr/local/mysql--enable-thread-safe-client
make
make install


cp /mysql-5.0.45/support-files/my-huge.cnf /etc/my.cnf
cp /mysql-5.0.45/support-files/mysql.server /etc/rc.d/init.d/mysql
cd /etc/rc.d/init.d/
chmod 755 mysql
cd /data01/lamp/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
bin/mysqld_safe --user=mysql &

cd /usr/bin/
ln -s /usr/local/mysql/bin/mysql .
ln -s /usr/local/mysql/bin/mysql_config .
ln -s /usr/local/mysql/bin/mysqldump .
ln -sf -s /usr/local/mysql/bin/mysql .
cd /usr/lib/
ln -sf /usr/local/mysql/lib/mysql/lib* .
cd /usr/include/
mkdir mysql
cd /usr/include/mysql/
ln -sf /usr/local/mysql/include/mysql/* .



now you give service mysql start

then it will start successfully.

Regards,
Prakash.
Thank you, I will try this method later, but I want to know what's data01?
 
Old 09-26-2008, 10:20 PM   #4
leiw
Member
 
Registered: Apr 2006
Posts: 131

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by leiw View Post
Thank you, I will try this method later, but I want to know what's data01?
Could you explain the following lines?

what's cd /data01/lamp/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
bin/mysqld_safe --user=mysql &

Line 1: I don't know what's data01

Line 2: So I can't find a mysql file to change owner and group

Line 5: Don't know where's root, mysql and var files.


Thanks
 
Old 09-27-2008, 12:46 AM   #5
prakash.akumalla
Member
 
Registered: Jun 2008
Location: India
Posts: 109

Rep: Reputation: 15
Hi,

Quote:
what's cd /data01/lamp/mysql

Sorry for that data01/lamp/mysql.

Its just the prefix i used to store mysql files. You can have it as /usr/local/mysql if you follow my above steps as

./configure --prefix=/usr/local/mysql--enable-thread-safe-client

Quote:
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
bin/mysqld_safe --user=mysql &

All that lines say about giving complete permissions to user mysql which you created in the first statement i have posted.

Quote:
groupadd mysql
useradd -g mysql mysql

Quote:
Don't know where's root, mysql and var files.

For this, if you give any prefix statement in addition to ./configure step you will find these directories in that location.

If you did not give any prefix there, you will find these files in /usr/local/ bin or var or what ever it is.

Regards,
Prakash.
 
Old 09-28-2008, 07:50 PM   #6
leiw
Member
 
Registered: Apr 2006
Posts: 131

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by prakash.akumalla View Post
Hi,




Sorry for that data01/lamp/mysql.

Its just the prefix i used to store mysql files. You can have it as /usr/local/mysql if you follow my above steps as

./configure --prefix=/usr/local/mysql--enable-thread-safe-client




All that lines say about giving complete permissions to user mysql which you created in the first statement i have posted.







For this, if you give any prefix statement in addition to ./configure step you will find these directories in that location.

If you did not give any prefix there, you will find these files in /usr/local/ bin or var or what ever it is.

Regards,
Prakash.
ok , thanks
 
  


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
LXer: MySQL defends paid tarball decision LXer Syndicated Linux News 0 08-15-2007 07:10 AM
Problem with my MySQL installation jabird Red Hat 12 03-07-2005 08:40 PM
tarball installation location uvone Slackware 3 11-19-2004 04:23 AM
Upgrading mysql 3.23 to 4.0 using tarball tinaa Linux - Software 2 05-21-2003 07:50 AM
MySQL 4.0.12 installation problem. Swift&Smart Linux - Software 10 04-07-2003 11:54 AM


All times are GMT -5. The time now is 08:35 PM.

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