What exactly is MySQL???

newBum76

15 years ago

It's a free database, usually used with PHP which is a scripting language.

Thanks
1 reply

Signature

Now THIS is how to write a successful ebook in any niche..... even if you have ZERO writing experience!

{{ DiscussionBoard.errors[1215775].message }}

Thomson

15 years ago

MySQL is a database just like MSSQL (used for Windows). MySQL is supported on both Windows and Linux hosting packages and it is free of cost, whereas, MSSQL requires licensing fee (like other products of Microsoft

).

Basically, it is a database of website which is required or say recommended (if you do not wish to have databases, you can still have a website) if you have your website or you wish to create a website.

Thanks
1 reply

{{ DiscussionBoard.errors[1215792].message }}

fthomas137

15 years ago

Big JP, all the above answers are 100% correct. But I have a simpler answer that I give my customers. Think of it as a 3 dimensional excel spreadsheet. Where you could have sheets reference other sheets. That my friend is a database! Pretty cool, don't you think?

Frank

Thanks
3 replies

Signature

Finally Stream Live Events With Ease and Get All The Ranking Goodness From Google, in Under 5 Minutes...

{{ DiscussionBoard.errors[1215822].message }}

Big JP

15 years ago

Originally Posted by fthomas137

Big JP, all the above answers are 100% correct. But I have a simpler answer that I give my customers. Think of it as a 3 dimensional excel spreadsheet. Where you could have sheets reference other sheets. That my friend is a database! Pretty cool, don't you think?

Frank

Not sure I quite understand you on that one?

Thanks

Signature

>> WORDPRESS ROBOT VERSION 3!!! MASSIVE UPDATE = MASSIVE DISCOUNT?
GET IT WHILE YOU CAN <<

{{ DiscussionBoard.errors[1215832].message }}

Andyhenry

15 years ago

Originally Posted by fthomas137

Big JP, all the above answers are 100% correct. But I have a simpler answer that I give my customers. Think of it as a 3 dimensional excel spreadsheet. Where you could have sheets reference other sheets. That my friend is a database! Pretty cool, don't you think?

Frank

A 3 dimensional excel spreadsheet is your simple answer ? hehe...

Since I'm playing with OLAP and pivot tables I know what you mean, but I doubt a technophobe will 'get' your 'simple' version

Thanks
1 reply

Signature

nothing to see here.

{{ DiscussionBoard.errors[1215834].message }}

Big JP

15 years ago

Originally Posted by Andyhenry

A 3 dimensional excel spreadsheet is your simple answer ? hehe...

Since I'm playing with OLAP and pivot tables I know what you mean, but I doubt a technophobe will 'get' your 'simple' version

Maybe with I little more detail, even I (a technophobe) would

Thanks

Signature

>> WORDPRESS ROBOT VERSION 3!!! MASSIVE UPDATE = MASSIVE DISCOUNT?
GET IT WHILE YOU CAN <<

{{ DiscussionBoard.errors[1215851].message }}

Bewley 15 years ago

An easy way to administrate it is to use phpMyAdmin -this should should be pre-installed on your hosting package.
- Thanks
{{ DiscussionBoard.errors[1215848].message }}

Andyhenry

15 years ago

It's a type of database with its own query language.

It's nothing to do with hosting per se, but many people want to run websites and scripts which require some sort of backend database, and since sql (the big brother of MySql) and MySql are usually provided by hosts who understand this, it's become a common part of most hosting company offerings.

You can happily build a website without using and databases, but many people now prefer to use very quick and simple content management systems like blogging platforms - these require a database to store their information and allow easy and quick changes.

Most blog platforms require MySql to run.

If you're a complete technophobe and don't want to get your hands dirty at all, you can use hosting that has cpanel with 'Fantastico' which lets you choose your details for your blog and will install and setup the database side of things for you.

Most programmers looking to develop web applications tend to consider skills with LAMP essential (Linux - the operating system on most hosts, Apache - the web server on most hosts, MySql - as just covered, PHP - the language used to combine web page functions with grabbing data from the MySql data).

Andy

Thanks

Signature

nothing to see here.

{{ DiscussionBoard.errors[1215786].message }}

AverageGuy

15 years ago

mysql is a database system. it can be used in linux/unix and windows. it is much cheaper to use it than other database, so, it is popular on most linux server.

david

Thanks

{{ DiscussionBoard.errors[1215790].message }}

Big JP

15 years ago

So basically It is a stand alone product, which is free? and included in hosting/cpanel, and also available to use without hosting.

Fantastico would install the blogging scrips onto the MySQL database, rite?
Then the MySQL database is where all the files for the site/blog are held, and the database is hosted on whatever hosting account it is registered too, I am on the rite track???

Cheers

JP

Thanks
2 replies

Signature

>> WORDPRESS ROBOT VERSION 3!!! MASSIVE UPDATE = MASSIVE DISCOUNT?
GET IT WHILE YOU CAN <<

{{ DiscussionBoard.errors[1215816].message }}

Big JP

15 years ago

Originally Posted by Big JP

So basically It is a stand alone product, which is free? and included in hosting/cpanel, and also available to use without hosting.

Fantastico would install the blogging scrips onto the MySQL database, rite?
Then the MySQL database is where all the files for the site/blog are held, and the database is hosted on whatever hosting account it is registered too, I am on the rite track???

Cheers

JP

Is this right or wrong?

Thanks
1 reply

Signature

>> WORDPRESS ROBOT VERSION 3!!! MASSIVE UPDATE = MASSIVE DISCOUNT?
GET IT WHILE YOU CAN <<

{{ DiscussionBoard.errors[1215897].message }}

SageSound

14 years ago

Originally Posted by Big JP

So basically It is a stand alone product, which is free? and included in hosting/cpanel, and also available to use without hosting.

Fantastico would install the blogging scrips onto the MySQL database, rite?
Then the MySQL database is where all the files for the site/blog are held, and the database is hosted on whatever hosting account it is registered too, I am on the rite track???

Cheers

JP

Is this right or wrong?

Yes and no.

MySQL is not a "standalone product". It's called a "database service", and it runs on the server along with a bunch of other services, like your mail servers, Apache (web server), php (usually as an Apache addin), and others.

It is loaded up by default in virtually every Linux-based web server distribution, but it's not the only database server that exists or can be used. Another one is mSQL. Also, postgresql, and some others.

Blogging scripts don't get installed into the database. They get installed onto the file system. The related data gets installed into the database.

That's like saying your paycheck gets deposited into your wallet -- you can carry the check around in your wallet, but it eventually gets deposited into your bank account. Until then, you cannot use the funds it represents.

Similarly, the files are stored in the file system, not in the database.

Look ... consider an accounting program like QuickBooks or Quicken. There are a bunch of files. When you install it, the files get put into your hard drive, into the file system. When you run the program and start entering checks and deposits, that DATA gets entered into a DATBASE that's managed by QuickBooks. If you look at the files using Windows Explorer, you cannot read the data in the database. You need the program to do that.

QuickBooks uses it's own database. But it could conceivably use another database like MySQL.

A blog like Wordpress is an example of a more general type of program called a "Content Management System", or CMS. One characteristic of CMSs is they store their DATA in a database of some kind.

The main thing that's different between a CMS like Wordpress and a plain old static web site that you'd create with Front Page is ... with Wordpress there's no "web site" there. All there is is a script that runs queries against the database and then displays the data inside of some templates that give the illusion that there's a web site there. When in fact, there is not one single static web page to be found anywhere.

MySQL happens to be free, easy to use, and one of the most popular Open Source database products in the world. You'd be hard-pressed to find a Linux-based web server that does NOT have MySQL installed on it. It can also be installed on Windows machines, but it's not there by default.

HTH
-David

Thanks

{{ DiscussionBoard.errors[1357480].message }}

seasoned

14 years ago

Originally Posted by Big JP

So basically It is a stand alone product, which is free? and included in hosting/cpanel, and also available to use without hosting.

Fantastico would install the blogging scrips onto the MySQL database, rite?
Then the MySQL database is where all the files for the site/blog are held, and the database is hosted on whatever hosting account it is registered too, I am on the rite track???

Cheers

JP

Fantastico has NOTHING to do with DBMS systems like MYSQL! Some PACKAGES it INSTALLS, on the O/S filesystem, can use a product such as MYSQL.

The database is made SPECIFICALLY so it does NOT have to be tied to any particular user. And AMAZON, for example, doesn;t want to spend TRILLIONS of dollars storing different pages, so they store the info, in a database, to GENERATE them.

BESIDES, database systems predate the open internet and/or WWW.

And it CAN be a stand alone product, but it is usually used with other things.

Steve

Thanks

{{ DiscussionBoard.errors[1358853].message }}

zapseo

15 years ago

Hi JP --

MySQL (and databases, in general) -- are a place to store structured data.
For instance, your checkbook register has structured data (if anyone uses checks any more ???):
the check number, who it is made out to, the date, the amount and maybe even a "category."
Geeks (and others) called these "records."
And perhaps one of the easiest visible representations of these records are seen in "tables" -- like the tables you would see on a web page (if I knew a bit more about you, I could give you a better example.)

And, in fact, a bunch of common records are called, in the database world "a table."
(please, purists, this is not the time or place for nuances!).

Sometimes, you have 2 different kinds of structured data that want to inter-relate.
So, in your check register, you have a piece of data (called a "field") that is who the check is made out to -- us geeky types would call this a "name" field. (Although the name of the name field could be something other than "name" -- however, it's descriptive, and short.)

You might have some other structured data that is a list of names addresses and phone numbers. If you made out a check, you probably have to send it somewhere, needing the address. So you would look up in your "address book" (the database folks likely would call it an address table.) the name of the person you made the check out to in order to find out what address to write on the envelope.

That would be 2 tables, and they inter-relate based upon the "name" field.

Hope that's not too confusing!

Live JoyFully!

Judy

Thanks
1 reply

Signature

Speed Read Copy -- 97% Off Value -- RAVE Reviews!

{{ DiscussionBoard.errors[1215879].message }}

Big JP

15 years ago

Originally Posted by zapseo

Hi JP --

MySQL (and databases, in general) -- are a place to store structured data.
For instance, your checkbook register has structured data (if anyone uses checks any more ???):
the check number, who it is made out to, the date, the amount and maybe even a "category."
Geeks (and others) called these "records."
And perhaps one of the easiest visible representations of these records are seen in "tables" -- like the tables you would see on a web page (if I knew a bit more about you, I could give you a better example.)

And, in fact, a bunch of common records are called, in the database world "a table."
(please, purists, this is not the time or place for nuances!).

Sometimes, you have 2 different kinds of structured data that want to inter-relate.
So, in your check register, you have a piece of data (called a "field") that is who the check is made out to -- us geeky types would call this a "name" field. (Although the name of the name field could be something other than "name" -- however, it's descriptive, and short.)

You might have some other structured data that is a list of names addresses and phone numbers. If you made out a check, you probably have to send it somewhere, needing the address. So you would look up in your "address book" (the database folks likely would call it an address table.) the name of the person you made the check out to in order to find out what address to write on the envelope.

That would be 2 tables, and they inter-relate based upon the "name" field.

Hope that's not too confusing!

Live JoyFully!

Judy

That sounds clear, but if you related to how this works with websites, I would have gotten a better understanding I think

Thanks

Signature

>> WORDPRESS ROBOT VERSION 3!!! MASSIVE UPDATE = MASSIVE DISCOUNT?
GET IT WHILE YOU CAN <<

{{ DiscussionBoard.errors[1215910].message }}

seasoned

15 years ago

Actually, the first real popular STANDARD SQL data base was mSQL, but it was a real mess, Someone decided to make it better, and they came up with MySQL. The term SQL is because it uses S.Q.L.(Structured Query Language). Sybase, MSSQL, Oracle are popular database Management systems that ALL use basic SQL.

I could say a lot more, but basically it...

1. Allows access of data in a fast and standard way.
2. Works over a network. Earlier, data generally had to be local.
3. automatically handles locsk to prevent corruption.

Steve

Thanks

{{ DiscussionBoard.errors[1215915].message }}

spazz896

15 years ago

mysql is a database, you store information in it. For Example. names,emails. so that you can call it back later.

If you want to use wordpress, you need a database

Thanks
1 reply

Signature

My Blog BradleyBurnie.com

{{ DiscussionBoard.errors[1215951].message }}

edhan 15 years ago

Hope to make this simple to understand.

Take example for wordpress.

It will create a mysql database when installed. This create all the necessary fields for wordpress blog.

These field tables will be categorized for different information.

For example:

One table field for keeping records of your admin login record as well as other users you may allow to login your wordpress blog to be contributor, writer, etc. This info is kept in the table and whenever it is required, it will be pull out from the database.

Same like the content of the article post. There is a table for that in the database. So, everytime you make a post, it will be saved in the table. To display it whenever someone views it, it will show on your website.

Basically, it is like a storage, whenever you require the info, it will pull out from the database to display online.

Hope this simple explanation is clear.
- Thanks
Signature

Be blessed with Thai Buddha Amulets & Tibetan dZi to accumulate wealth, health & good fortune
Build your own community business
Article Directory Source Code with blog & Classified Ads
Understanding the cycle of Karma & Merits
{{ DiscussionBoard.errors[1216131].message }}

Johnny

15 years ago

MySQL is a database. One of the many out there in the market. MySQL is well known and used around the world as it is good and the most important -- FREE

When my client ask me what is database, I will tell them that it is a place that data can be stored.

Like excel, you can store information in worksheet.
For database, you store information in table.

You need database to store information, so that your script/software can store and retrieve information.

For lay man, I think that is all you need to know. You will have a nightmare if you wanna go in depth

Cheers

Thanks

Signature

________________________________________

>>> Johnny <<<

{{ DiscussionBoard.errors[1216158].message }}

newBum76

15 years ago

Here's a basic explanation of how MySQL fits in with everything:

1. Basic web page - created with HTML, a basic page is just static, meaning the visitor can only look at stuff, text, images etc. and can't really interact with the page much beyond clicking on a link to go to another page.

2.PHP - this is a programming language used to create "scripts" for the web page. These scripts do lots of different things that allow the visitor to interact with the page. For example, filling out and submitting a form that asks for your name and email address to get on a list.

3. MySQL - so what happens to the name and email address once it's submitted? It needs to be stored in a database to be retrieved later. MySQL is a specific database that is often used together with PHP.

It gets much more complicated than this, but this is pretty much the gist of it.

Thanks

Signature

Now THIS is how to write a successful ebook in any niche..... even if you have ZERO writing experience!

{{ DiscussionBoard.errors[1221249].message }}

e.calabio

14 years ago

In mysql, you create the database the old-fashioned/manual way. What do you call SQLYog , MySQL Query that also creates database but more efficiently. What's the term to call them?

Thanks
1 reply

{{ DiscussionBoard.errors[1357216].message }}

seasoned

14 years ago

Originally Posted by e.calabio

In mysql, you create the database the old-fashioned/manual way. What do you call SQLYog , MySQL Query that also creates database but more efficiently. What's the term to call them?

Actually, MYSQL doesn't allow you to create databases in the old-fasioned/manual way. One reason for a DBMS is to AVOID the old-fashioned/manual way! Most SQL DBMSs, like MYSQL, have been aroound since only about 1980. Even the PAPER credited with its inspiration only occured in the 70s. The basis for SQL was developed in 1974. The old traditional format is FAR older.

SQLYOG CAN'T create databases, etc... and stores NO data! It is a front end for MYSQL so that, IRONICALLY, if you want to access MYSQL in a MORE manual way, it is easier.

The MYSQL QUERY *****BROWSER***** is basically just a competitor to SQLYOG.

Steve

Thanks

{{ DiscussionBoard.errors[1357437].message }}

badfun

14 years ago

everything you need to know about mysql is at ....gasp! ..... mysql.com

MySQL Query Analyzer - Improving SQL Query Performance

brent

Thanks

{{ DiscussionBoard.errors[1357773].message }}

What exactly is MySQL???

Trending Topics

Been a while! Any of you Old Timers here?

How much does the rebranding affect CR ?

Clickbank low cost recurring

Boat and Jet Ski Rentals...... Door Hangers Effective?

Are billboards still effective in driving customers?