LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
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 04-06-2003, 09:19 PM   #1
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Rep: Reputation: 15
MySQL tutorial


I am wondering what a good tutorial is for MySQL. I am mainly focused on installing it first. I want to make sure it installs it and have php being able to use it (because of phpbb). Could somebody link me to a good turorial? I have read the mysql.com tutorial, but it didnt explain everything. I am on RHL 8.0.
 
Old 04-06-2003, 09:45 PM   #2
Swift&Smart
Member
 
Registered: Jan 2003
Location: Hong Kong,China
Distribution: Slackware,OpenSUSE
Posts: 472

Rep: Reputation: 30
Post Your tutorial

I hope this LAMP tutorial can help you.http://www.bio.utexas.edu/staff/jun/computing/map.html
 
Old 04-07-2003, 03:31 PM   #3
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Thanks, the I tried the make command on the binary but it said that there is no make file. Is the mysql-standard the right binary version?

Thanks
 
Old 04-07-2003, 04:10 PM   #4
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Once I can figure out which file to download, how do I install it? I have seen different versions of installing it on different websites. What my end goal is to be able to use phpBB2. Anyway I can get there is fine with me. I already have php installed from the binary file, will I need to reinstall it?

Thanks
 
Old 04-07-2003, 07:17 PM   #5
wdingus
Member
 
Registered: Aug 2001
Location: Kingsport, TN
Distribution: RHEL & FC
Posts: 267

Rep: Reputation: 30
MySQL 3.23.54 comes with RedHat 8.0 and is installed automatically if you choose it during initial install. If not, it's on the CDs you already have. Installing it from downloaded files at mysql.com is also quite easy and they have excellent documentation describing the process:

http://www.mysql.com/doc/en/Installing.html
 
Old 04-07-2003, 07:30 PM   #6
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Thanks, how to I join it with php?
 
Old 04-07-2003, 07:37 PM   #7
wdingus
Member
 
Registered: Aug 2001
Location: Kingsport, TN
Distribution: RHEL & FC
Posts: 267

Rep: Reputation: 30
Again, if you install MySQL and PHP and all related packages (specifically php-mysql-version#) then they will be "joined" automatically. They'll work together straight "out of the box" so to speak.

I'm talking about installing them from the RedHat 8 CDs...
 
Old 04-07-2003, 07:49 PM   #8
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Okay, thanks. I do not have MySQL installed, but I have php installed from the binary. Is there anyway I can get so MySQL (from the Red Hat 8 cd) can see php without having to reinstall php?
 
Old 04-07-2003, 07:58 PM   #9
wdingus
Member
 
Registered: Aug 2001
Location: Kingsport, TN
Distribution: RHEL & FC
Posts: 267

Rep: Reputation: 30
You won't have to re-install anything, as long as all the appropriate packages are installed they will work together. The order of install should not really matter...

Make sure Apache is installed, PHP is installed, MySQL is installed, php-mysql is installed. Then test PHP to make sure at least it is working. Easy way, go to /var/www/html and create a file "phpinfo.php" and in it place:

<?php
phpinfo();
?>

Then surf to the box's IP address/phpinfo.php or a virtual host if you have one configured, etc...

Testing integration with MySQL requires a bit more effort but at the very least check the output of phpinfo() to be sure you see mention of MySQL support being included.

Good luck!
 
Old 04-07-2003, 08:16 PM   #10
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Thanks, I have apache and php already installed and working. Do you have any idea how I would test MySQL working with php?

Thanks
 
Old 04-07-2003, 08:44 PM   #11
wdingus
Member
 
Registered: Aug 2001
Location: Kingsport, TN
Distribution: RHEL & FC
Posts: 267

Rep: Reputation: 30
Easiest way? Probably just put your PHPbb online and follow it's configuration/installation instructions and see what happens. I installed it for the first time a few weeks back and it was fairly easy. Not a bad forum software either...

Other than that it would take a bit more complex of a PHP program than just a simple phpinfo() Unless you're wanting to get into PHP coding, just try installing some app like PHPbb and see what you run into.
 
Old 04-07-2003, 09:00 PM   #12
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Thanks, you have helped a lot.

Do you remeber any of the phpBB installation? I have some questions about it concerning the database part.

I am wondering what to put for basically all of the database part, Database Server Hostname / DSN, Your Database Name, Database Username, Database Password, Prefix for tables in database.

I dont know what to put for any of it. What do I put for DSN and Database name? How would I create a username? Also, will this automatically make the database or do I have to make it before? The prefix tables it already put something in, phpbb_

Thanks again.
 
  


Reply



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
Tutorial for BIND with mySQL backend mrEgg Red Hat 3 12-14-2004 03:20 AM
mysql tutorial tommytomato Linux - Newbie 7 09-16-2004 08:50 PM
Mysql Tutorial!!! baby_linu Linux - Newbie 3 03-07-2004 06:42 AM
MySQL tutorial stuff tarballed Linux - General 4 02-14-2003 09:37 PM
Installation Tutorial Apache 2, PHP 4, MySQL 3.23 freddymio Programming 2 07-03-2002 09:40 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

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