LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CollegeLinux
User Name
Password
CollegeLinux This forum is for the discussion of CollegeLinux.

Notices


Reply
  Search this Thread
Old 12-29-2003, 09:05 AM   #1
digital bots
Member
 
Registered: Feb 2002
Distribution: Slack 10.1
Posts: 215

Rep: Reputation: 30
Installing MYSQL to CL


well first off i downloaded the mysql-standard-4.0.17-pc-linux-i686 from mysql and tried to follow these steps that can be found here
now i got the following errors from each step.

shell> groupadd mysql
bash-2.05a# groupadd mysql
groupadd: group mysql exists

shell> useradd -g mysql mysql
bash-2.05a# useradd -g mysql mysql
useradd: user mysql exists

shell> gunzip < mysql-VERSION.tar.gz | tar -xvf - <-unpacks fine


shell> cd mysql-VERSION

shell> ./configure --prefix=/usr/local/mysql
bash-2.05a# ./configure --prefix=/usr/local/mysql
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Neither host 'darkstar' and 'localhost' could not be looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

shell> make <- this wouldnt run because the config never went off

shell> make install <- dito

shell> scripts/mysql_install_db
bash-2.05a# scripts/mysql_install_db
Neither host 'darkstar' and 'localhost' could not be looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

(this is what happend when i forced it)

bash-2.05a# scripts/mysql_install_db --force
Installing all prepared tables
031228 3:43:03 ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h darkstar password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com



shell> chown -R root /usr/local/mysql <-didnt work because dir wasnt created
shell> chown -R mysql /usr/local/mysql/var <- dito
shell> chgrp -R mysql /usr/local/mysql <-double dito
shell> cp support-files/my-medium.cnf /etc/my.cnf <- worked

shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &
bash-2.05a# /usr/local/mysql/bin/mysqld_safe --user=mysql &
[1] 11579
bash: /usr/local/mysql/bin/mysqld_safe: No such file or directory
bash-2.05a#

Now i use to have slackware 8.1 then 9 andi got the same issues and when i moved over to CL i get the same issues so the problem as to be me and not the disto so can some one help me out.
 
Old 01-02-2004, 05:02 AM   #2
The_Q
LQ Newbie
 
Registered: Dec 2003
Location: Ngaruawahia, New Zealand.
Distribution: College Linux
Posts: 12

Rep: Reputation: 0
My suggestion. Download 2.5 it comes with Apache, Mysql and PHP all configured as part of the install.

And it might be just me , but I think it runs faster.
 
Old 01-04-2004, 08:41 AM   #3
digital bots
Member
 
Registered: Feb 2002
Distribution: Slack 10.1
Posts: 215

Original Poster
Rep: Reputation: 30
Quote:
Originally posted by The_Q
My suggestion. Download 2.5 it comes with Apache, Mysql and PHP all configured as part of the install.

And it might be just me , but I think it runs faster.
download apache 2.5?
 
Old 01-04-2004, 02:28 PM   #4
The_Q
LQ Newbie
 
Registered: Dec 2003
Location: Ngaruawahia, New Zealand.
Distribution: College Linux
Posts: 12

Rep: Reputation: 0
apache on cl 2.5

Umm no download CollegeLinux 2.5. all this is preinstalled and has all the config tools too. During install all this is set up.

also slapt-get so you can add new software, fixes, upgrades very quickly

apache + mysql + php from the box

also slackeware 9.1 compatable.


Last edited by The_Q; 01-04-2004 at 02:31 PM.
 
Old 01-05-2004, 02:05 PM   #5
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 270Reputation: 270Reputation: 270
You can most likely download and install the Slackware mysql package from www.linuxpackages.net as well.

Then simply do a:

installpkg mysql<version>.tgz

It will install for you. Then you can continue the steps to get mysql running, etc.

mysql_install_db
chown -R mysql.mysql /var/lib/mysql
mysqld_safe &
 
Old 01-05-2004, 05:43 PM   #6
The_Q
LQ Newbie
 
Registered: Dec 2003
Location: Ngaruawahia, New Zealand.
Distribution: College Linux
Posts: 12

Rep: Reputation: 0
use the slackeware 8.1 package for cl2.3

Just remember that College is based on slackware with Cl 2.3 based on the slack 8.1 and 2.5 being based on the newer 9.1

If you do download a slack package make sure you get the right one.

But I still think the newer CollegeLinux 2.5 is the better option.

Have fun whatever you choose to do.
 
Old 02-16-2004, 08:22 AM   #7
mahin
LQ Newbie
 
Registered: Sep 2003
Location: Karachi
Posts: 1

Rep: Reputation: 0
PHP,MySQL and Apache in College 2.5 ?

Quote:
Originally posted by The_Q
My suggestion. Download 2.5 it comes with Apache, Mysql and PHP all configured as part of the install.
Installed College Linux 2.5 but can not find all three. What I am doing wrong that they are not showing up or is there any specific ISO.

BTW there is Open Office present in 2.5 I have, my impression was that it is not there.
 
  


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 error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Installing MySQL heho Linux - Software 6 11-25-2004 01:49 PM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 03:43 PM
Installing MySQL carlg Linux - General 7 04-17-2004 03:17 PM
Installing MySQL.4.0.17 and php support for Mysql on RedHat 9.0 Neha Linux - Software 13 12-29-2003 01:06 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CollegeLinux

All times are GMT -5. The time now is 06:40 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
Open Source Consulting | Domain Registration