Welcome Guest ( Log In | Register )



 
Closed TopicStart new topic
> Can You Make Your Own MySQL Databases?, Im an idoit
Jarvis
post Dec 14 2006, 07:04 PM
Post #1


Newbie [ Level 1 ]
Group Icon

Group: Banned
Posts: 8
Joined: 6-December 06
Member No.: 17,994



Can you make your own MySQL database or do they have to be bought or found from a free site i really need help on this guys please reply or send me a PM when you have the time because i need so much help with this atm smile.gif

thankyou very much regards Morex Gaming owner Jarvis
Go to the top of the page
 
+Quote Post
seec77
post Dec 14 2006, 07:24 PM
Post #2


Advanced Member
Group Icon

Group: Members
Posts: 157
Joined: 16-May 06
Member No.: 13,476



I'm not going to PM you the information I'm about to supply you for the benefit of the rest of the community. I hope you'll excuse me. tongue.gif

MySQL is a free (and open-source) server program that can be obtained easily and run on almost any computer. Yes, you can also create a database using said software on your home computer. The only thing is that queries wouldn't be processed if your computer is not active, and therefore most sites use MySQL installed on computer that their sole function is to act as a server (sometimes for other things besides being a Database Management System). Look here for downloading the actual software (I recommend the "Windows Essentials" or "Windows ZIP/Setup.EXE" packages for MS Windows), and here is a page from the MySQL manual for guiding you through the whole process of installing MySQL on your computer.

Good luck, and if you need further assistance please post to this thread as opposed to private messages.
Go to the top of the page
 
+Quote Post
yordan
post Dec 14 2006, 08:02 PM
Post #3


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,035
Joined: 16-August 05
Member No.: 7,896



QUOTE(Jarvis @ Dec 14 2006, 08:04 PM) *

Can you make your own MySQL database or do they have to be bought or found from a free site i really need help on this guys please reply or send me a PM when you have the time because i need so much help with this atm smile.gif

thankyou very much regards Morex Gaming owner Jarvis

if you are hosted at astahost, you simply have to create your database using astahost's cpanel.
When you install a Linux machine, MySQL comes automatically with Linux, it's free for a non-commercial usage.
Go to the top of the page
 
+Quote Post
Quatrux
post Dec 14 2006, 08:30 PM
Post #4


the Q
Group Icon

Group: [HOSTED]
Posts: 1,051
Joined: 13-July 05
From: Lithuania, Vilnius
Member No.: 7,059



QUOTE(yordan @ Dec 14 2006, 10:02 PM) *

When you install a Linux machine, MySQL comes automatically with Linux, it's free for a non-commercial usage.


Err, I don't understand this sentence a bit, Linux is a kernel, so a Linux machine is a computer which has Linux installed, GNU is environment for the kernel and that environment can have anything you want, including MySQL, but a lot of distributions don't really include mysql automatically.. So if you have Linux installed (the Kernel), that doesn't mean you have mysql, you have mysql only if it is installed (from sources or as binary) by some install script or by you. smile.gif
Go to the top of the page
 
+Quote Post
TavoxPeru
post Dec 15 2006, 05:40 AM
Post #5


Super Member
Group Icon

Group: [HOSTED]
Posts: 763
Joined: 8-April 06
From: Lima - Peru
Member No.: 12,579



To complete what seec77 says i recommend that you also download the MySql Gui Tools.

The MySql Gui Tools is a set of applications for administering MySQL Server and working with data, this includes in a single bundle all the GUI tools developed by MySql:
  • MySQL Administrator: Tool for administer and monitor your MySql environment, database management and maintenance.
  • MySQL QueryBrowser: Tool for working with your database data, such as creating, executing, and optimizing SQL queries.
  • MySQL MigrationToolkit: Tool for migrate proprietary databases to MySQL.
  • MySQL Workbench: Tool for database modeling, such design and create schemas.
I'm not 100% sure that this bundle works with MySql versions prior to 5.

Best regards,
Go to the top of the page
 
+Quote Post
yordan
post Dec 15 2006, 01:40 PM
Post #6


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,035
Joined: 16-August 05
Member No.: 7,896



QUOTE
Quoting myself :
When you install a Linux machine, MySQL comes automatically with Linux, it's free for a non-commercial usage

QUOTE(Quatrux @ Dec 14 2006, 09:30 PM) *

Err, I don't understand this sentence a bit, Linux is a kernel, so a Linux machine is a computer which has Linux installed, GNU is environment for the kernel and that environment can have anything you want, including MySQL, but a lot of distributions don't really include mysql automatically.. So if you have Linux installed (the Kernel), that doesn't mean you have mysql, you have mysql only if it is installed (from sources or as binary) by some install script or by you. smile.gif

Sorry, I was probably not clear enough. You cannot install simply a Linux kernel on a system. Usually, you buy a Linux distro (from Redhat or from Mandrake for instance) or you download from the internet a set of .iso files, you burn them on CD's, and you boot your machine from the first CD in order to install Linux.
When you boot from the installation CD, usually the installer asks you what you want to install, and usually, the mysql server is included in the installation media and is automatically handled by the automatic install program started when you boot from the install CD.
So, usually, when you install a Linux machine from a "standard" distro, mysql is included and very often it's automatically installed.
Of course, mysql is also available for Windows and for several proprietary Unix systems. Then, it has to be purchased as a separate product.
Go to the top of the page
 
+Quote Post
FirefoxRocks
post Mar 18 2007, 10:28 PM
Post #7


Super Member
Group Icon

Group: [HOSTED]
Posts: 695
Joined: 12-July 06
From: Ontario, Canada
Member No.: 14,464



If your web hosting service is AstaHost or Trap17, go to your cPanel and add a database and a database user.
The direct link is:

https://yoursite.trap17.com:2083/frontend/r.../sql/index.html

Replace yoursite.trap17.com with the actual domain name. tongue.gif

If you are running your own server with MySQL and PHP, you MUST have enough knowledge of how to use MySQL if you have a server running for your site tongue.gif
Go to the top of the page
 
+Quote Post
vhortex
post Mar 19 2007, 12:07 PM
Post #8


Guilty Until Proven Innocent
Group Icon

Group: Members
Posts: 372
Joined: 13-April 05
Member No.: 3,937



QUOTE(FirefoxRocks @ Mar 19 2007, 06:28 AM) *
If your web hosting service is AstaHost or Trap17, go to your cPanel and add a database and a database user.
The direct link is:

https://yoursite.trap17.com:2083/frontend/r.../sql/index.html

Replace yoursite.trap17.com with the actual domain name. tongue.gif

If you are running your own server with MySQL and PHP, you MUST have enough knowledge of how to use MySQL if you have a server running for your site tongue.gif


i guess this topic should be close. since the original poster was banned, there seems to purpose to continue this tread.
just my few cents..

Go to the top of the page
 
+Quote Post

Closed TopicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL Output Database Question(18)
  7. MySQL, Multiple Tables(24)
  8. Navcat For MySQL(8)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Login System Using A Mysql Db(5)
  12. Oracle Vs. Mysql Vs. Postgresql(9)
  13. Subqueries In Mysql(1)
  14. Apache Php With Mysql On Windows [solved](9)
  15. Mysql - So Hard(14)
  1. Mysql Problem(1)
  2. Free Graphical Tools For Databases(7)
  3. Databases(2)
  4. Sun Bought Mysql(6)
  5. Mysql Backup With Another Address?(4)
  6. I Have An Error With My Mysql Connection(7)
  7. Mysql And User File_priv(0)
  8. Mysql Database Management(1)
  9. Mysql Database Entry By Excel Sheets(2)
  10. Mysql On Computer(9)
  11. Any Website Provide Free Host Mysql Host?(4)
  12. Mysql Multiple Tables(1)
  13. Mysql Overhead(3)


 



- Lo-Fi Version Time is now: 8th October 2008 - 08:03 AM