LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
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 02-12-2006, 08:18 PM   #1
jtapiaRedHat
LQ Newbie
 
Registered: Feb 2006
Posts: 15

Rep: Reputation: 0
Database Creation


I have installed Mysql in my linux box and I would like to know how to set this up right and also I like to know where do I go from here to create a database.

The Database that I am trying to make is one that I am going to put pictures in and have contact information.

Also one that I can use for inventory.

of Products.

Can anyone help me on this situation. I would greatly appreciate this. I like to make the system like an AS400 system.
 
Old 02-12-2006, 10:39 PM   #2
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
Read the documentation. There is a complete chapter how to start.

http://dev.mysql.com/doc/
 
Old 02-13-2006, 01:42 AM   #3
jtapiaRedHat
LQ Newbie
 
Registered: Feb 2006
Posts: 15

Original Poster
Rep: Reputation: 0
I am totally lost and I don't know how and where to start is there something less difficult please help me with this I am a newbie But I learn pretty fast
 
Old 02-13-2006, 04:51 AM   #4
muha
Member
 
Registered: Nov 2005
Distribution: xubuntu, grml
Posts: 451

Rep: Reputation: 37
maybe this helps a bit:
http://www.topology.org/linux/mysql.html <- written for suse but i guess it works the same in redhat
some basic commands and stuff ...
 
Old 02-13-2006, 08:07 AM   #5
onjoo
Member
 
Registered: Jan 2005
Location: Finland
Distribution: Suse 10, Suse-factory , RHEL4, SLES9, SLED10
Posts: 380

Rep: Reputation: 30
I would recommend you phpMyAdmin.
With that you can administer mysql with browser.

For command line access to MySql :
open konsole:
type : "mysql -u root -p"
then type your password and you are in.

Short guide :
commands end with ; !

"show datadases;" list databases
"create database pictures;" makes a new database
"use pictures;" changes the database you want to access
"show tables;" shows you tables (there are none)
"create table picture (
id INT NOT NULL,
name VARCHAR(64),
primary key (id)
)
type=MYISAM;
"
...
 
Old 02-13-2006, 06:05 PM   #6
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
Try this:
http://dev.mysql.com/doc/refman/4.1/en/index.html

The official MySQL docs online
 
Old 02-14-2006, 11:36 AM   #7
jtapiaRedHat
LQ Newbie
 
Registered: Feb 2006
Posts: 15

Original Poster
Rep: Reputation: 0
do I have to have apache activated
 
Old 02-14-2006, 12:22 PM   #8
g_srinivas
Member
 
Registered: Jul 2005
Location: USA
Distribution: SuSE 9
Posts: 49

Rep: Reputation: 15
Lightbulb

For phpMyAdmin you will need Apache and PHP configured else you could also try and use MySQL Query Browser for which you wont need to install/configure Apache and PHP.

But with MySQL usually PHP and Apache are best suited for content management. If you decide for phpMyAdmin then you could also go through the following links which help with phpMyAdmin configuration:

http://www.melonfire.com/community/c...cle.php?id=217

http://www.melonfire.com/community/c...cle.php?id=220

hope this info helps u...
 
  


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
Red Hat Linux Database Creation jtapiaRedHat Linux - Newbie 9 02-08-2006 11:20 PM
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 07:58 PM
Rpm Creation sajjadc Red Hat 1 07-10-2005 02:22 PM
3d game creation kenji Linux - Games 5 02-22-2005 12:11 AM
mysql database creation zuessh Linux - Software 17 05-14-2003 02:13 PM


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