LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 09-08-2011, 12:39 PM   #1
magicalshashank31
Member
 
Registered: Apr 2011
Posts: 81
Blog Entries: 1

Rep: Reputation: 0
mysql server in rhel 6


I have install mysql on my rhel 6,but dont know how to use it.

I have made a html form in apache server and want to store the output of the form to mysql database ,such as its username,password etc to a well defined database ,please tell me how to do it????
 
Old 09-08-2011, 01:41 PM   #2
Thor_2.0
Senior Member
 
Registered: Nov 2007
Location: Somewhere on my hard drive...
Distribution: Manjaro
Posts: 2,189
Blog Entries: 23

Rep: Reputation: 278Reputation: 278Reputation: 278
Hi, you'll need either

- the built-in manager, you'll have to shoot SQL at the database
- get the workbench
- install phpMyAdmin, and configure it.

Next, you're in for a ride.

By the way...

Quote:
I have made a html form in apache server and want to store the output of the form to mysql database ,such as its username,password etc to a well defined database ,please tell me how to do it???
That's a lot o' questions...

Lemme break it down for you:

Quote:
I have made a html form in apache server
Dont use HTML, use PHP...

Quote:
such as its username,password etc
Anything when issued in a <form></form> tag can be shot to the database

Quote:
a well defined database
You'll need to learn databse design and data normalisation...

Quote:
please tell me how to do it???
Now, if we told you exactly how to do it, where would all the fun be in that??? Not that I want you to RTFM it, either...but...this is your project, innit?

Elaborate about your project, maybe some magic will pop out of the hat

Luck

Thor

Last edited by Thor_2.0; 09-08-2011 at 01:42 PM.
 
Old 09-09-2011, 07:08 AM   #3
magicalshashank31
Member
 
Registered: Apr 2011
Posts: 81
Blog Entries: 1

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by Thor_2.0 View Post
Hi, you'll need either

- the built-in manager, you'll have to shoot SQL at the database
- get the workbench
- install phpMyAdmin, and configure it.

Next, you're in for a ride.

By the way...



That's a lot o' questions...

Lemme break it down for you:



Dont use HTML, use PHP...



Anything when issued in a <form></form> tag can be shot to the database



You'll need to learn databse design and data normalisation...



Now, if we told you exactly how to do it, where would all the fun be in that??? Not that I want you to RTFM it, either...but...this is your project, innit?

Elaborate about your project, maybe some magic will pop out of the hat

Luck

Thor



actually i have built mysql server and apache server in windows through xammp...bt i want to do it in linux, in windows i have graphical mysql server so i can made it easily....bt in linux ie rhel 6 i have install mysql in it and when type
Code:
#mysql

it shows.

mysql>
but dont know what to do now because this time i dont have graphical interface ,i just got the terminal of mysql

Last edited by magicalshashank31; 09-09-2011 at 07:12 AM.
 
Old 09-09-2011, 01:08 PM   #4
Thor_2.0
Senior Member
 
Registered: Nov 2007
Location: Somewhere on my hard drive...
Distribution: Manjaro
Posts: 2,189
Blog Entries: 23

Rep: Reputation: 278Reputation: 278Reputation: 278
Quote:
mysql>
Okay...so, enter some SQL here, see what comes back...

Just to get started:

Quote:
create database if not exists somedata
then, let's see if mySQL got the hint:

Quote:
show databases
you should get a list of databases on the server...

Then...well, you'll need to learn SQL...

Let's see where we get from here, ok?

Thor
 
Old 09-09-2011, 01:34 PM   #5
lrtward
Member
 
Registered: Feb 2011
Distribution: CentOS, Ubuntu
Posts: 97

Rep: Reputation: 9
Thor has given you great suggestions. He mentioned phpmyadmin but I wanted to underscore that. If you're accustomed to a graphical interface, then install phpmyadmin and get familiar with it.

It's always good to know how to do things from the command line, too, so in addition to Thor's commands I'd recommend taking a look at the MySQL tutorial at http://dev.mysql.com/doc/refman/5.0/en/tutorial.html and also a REALLY GOOD book called "PHP and MySQL Web Development" by Welling and Thomson. My copy is dog-eared. I refer to it several times per week. It is *excellent*.
 
Old 09-10-2011, 03:04 AM   #6
magicalshashank31
Member
 
Registered: Apr 2011
Posts: 81
Blog Entries: 1

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by lrtward View Post
Thor has given you great suggestions. He mentioned phpmyadmin but I wanted to underscore that. If you're accustomed to a graphical interface, then install phpmyadmin and get familiar with it.

It's always good to know how to do things from the command line, too, so in addition to Thor's commands I'd recommend taking a look at the MySQL tutorial at http://dev.mysql.com/doc/refman/5.0/en/tutorial.html and also a REALLY GOOD book called "PHP and MySQL Web Development" by Welling and Thomson. My copy is dog-eared. I refer to it several times per week. It is *excellent*.

thanks its being great site to learn mysql,now i am able to manage databases
 
Old 09-10-2011, 06:51 AM   #7
Thor_2.0
Senior Member
 
Registered: Nov 2007
Location: Somewhere on my hard drive...
Distribution: Manjaro
Posts: 2,189
Blog Entries: 23

Rep: Reputation: 278Reputation: 278Reputation: 278
Quote:
thanks its being great site to learn mysql,now i am able to manage databases
You're welcome! And, if you encounter anything else, get right back for more help-n-answers, we're here to help!

Enjoy!

Thor
 
  


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
Can MySQL log on via SSH/bash? mysql:x:27:101:MySQL Server:/var/lib/mysql:/bin/bash Ujjain Linux - Newbie 2 04-24-2009 02:21 PM
I have RHEL 5.0 and MySQL start problem, my MySQL server doesn't start rsatya Linux - Enterprise 4 02-03-2009 12:04 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM


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