[SOLVED] mysql server in rhel 6

magicalshashank31 · 09-08-2011, 12:39 PM

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????

Thor_2.0 · 09-08-2011, 01:41 PM

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

magicalshashank31 · 09-09-2011, 07:08 AM

Quote:

Originally Posted by Thor_2.0

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

Thor_2.0 · 09-09-2011, 01:08 PM

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

lrtward · 09-09-2011, 01:34 PM

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*.

magicalshashank31 · 09-10-2011, 03:04 AM

Quote:

Originally Posted by lrtward

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

Thor_2.0 · 09-10-2011, 06:51 AM

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