Getting started with MySQL

mat106 · 01-24-2005, 01:51 AM

Hi.

I'm completely new to MySQL. My host has MySQL installed and i'd like to experiment with using it but don't know how to get started. I know i have to create a table and put some data in it but i don't know how to connect to the server or database (if that's what i have to do?!?)

Where would i go to get started?

Brandoe85 · 01-24-2005, 01:54 AM

Search google for mysql tutorials. http://www.google.com/search?hl=en&q...=Google+Search

mat106 · 01-24-2005, 01:56 AM

Yeah i've done that but any tutorial i read seems to assume that i know how to connect to the database which i don't

. I haven't installed MySQL locally. It's on the hosts server.

Brandoe85 · 01-24-2005, 02:06 AM

You host should provide you with what you need to connect to it. Do they provide you with phpmyadmin or something in that matter that lets you connect? If not, you'll have to contact them and see how you can connect.

mat106 · 01-24-2005, 02:08 AM

Thanks. Will check and see.

Yaggles · 01-24-2005, 07:50 AM

If your host has CPanel on their server and allows you to access the mysql part, then it should have your database name and database username with a string for connecting to it with PHP and Perl. An example is:
<?
$dbh=mysql_connect ("localhost", "username", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database");
?>

That is how you do so in PHP.

01-24-2005, 01:51 AM	PM User \| #1
mat106 New Coder Join Date: Jun 2004 Posts: 51 Thanks: 0 Thanked 0 Times in 0 Posts	Getting started with MySQL Hi. I'm completely new to MySQL. My host has MySQL installed and i'd like to experiment with using it but don't know how to get started. I know i have to create a table and put some data in it but i don't know how to connect to the server or database (if that's what i have to do?!?) Where would i go to get started?

01-24-2005, 01:54 AM	PM User \| #2
Brandoe85 teh Moderatorinator Join Date: Sep 2004 Location: USA Posts: 2,435 Thanks: 2 Thanked 38 Times in 38 Posts	Search google for mysql tutorials. http://www.google.com/search?hl=en&q...=Google+Search __________________ -Brando Why using tables for eating is stupid!

01-24-2005, 02:06 AM	PM User \| #4
Brandoe85 teh Moderatorinator Join Date: Sep 2004 Location: USA Posts: 2,435 Thanks: 2 Thanked 38 Times in 38 Posts	You host should provide you with what you need to connect to it. Do they provide you with phpmyadmin or something in that matter that lets you connect? If not, you'll have to contact them and see how you can connect. __________________ -Brando Why using tables for eating is stupid!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

01-24-2005, 01:56 AM	PM User \| #3
mat106 New Coder Join Date: Jun 2004 Posts: 51 Thanks: 0 Thanked 0 Times in 0 Posts	Yeah i've done that but any tutorial i read seems to assume that i know how to connect to the database which i don't . I haven't installed MySQL locally. It's on the hosts server.

01-24-2005, 02:08 AM	PM User \| #5
mat106 New Coder Join Date: Jun 2004 Posts: 51 Thanks: 0 Thanked 0 Times in 0 Posts	Thanks. Will check and see.

01-24-2005, 07:50 AM	PM User \| #6
Yaggles Regular Coder Join Date: Jan 2005 Posts: 153 Thanks: 0 Thanked 0 Times in 0 Posts	If your host has CPanel on their server and allows you to access the mysql part, then it should have your database name and database username with a string for connecting to it with PHP and Perl. An example is: <? $dbh=mysql_connect ("localhost", "username", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("database"); ?> That is how you do so in PHP.