Closed Thread Icon

Topic awaiting preservation: My SQL Pages that link to <a href="https://ozoneasylum.com/backlink?for=12073" title="Pages that link to Topic awaiting preservation: My SQL" rel="nofollow" >Topic awaiting preservation: My SQL\

 
Author Thread
Dark
Neurotic (0) Inmate
Newly admitted
posted posted 03-01-2002 21:13

Well I just got my domain and they offer a great bag of goodies for free. There is some options to add a MySQL database. I have been to the SQL site and got some standard info on MySQL it'self, but not really on what it can do really. I mean my domain has an option to add the database .. so I clicked it .. and well nothing has really changed and I don't really anyway to modify it like the SQL site said.. so I'm wondering if what I am being offered is something diffent. Are they just going to keep a database on my site or what?



ICQ # 132364102

Dark
Neurotic (0) Inmate
Newly admitted
posted posted 03-01-2002 21:20

Once I had the database I get something like this ..




ICQ # 132364102

[This message has been edited by Dark (edited 03-01-2002).]

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 03-01-2002 21:21

Dark: I assume that clicking on the link started the process of setting up your DB (as it sounds like it didn't come set up by default). I suspect you should get an email in a few days telling you about the DB details (you may need to consult your host to find out what is actually going on). Then pop over here and read their tutorials:
www.devshed.com/Server_Side/MySQL

[edit: Thanks for the extra info - it looks like it is all up and running. phpMyAdmin will be a great help in constructing your tables.]

Emps

[This message has been edited by Emperor (edited 03-01-2002).]

Dark
Neurotic (0) Inmate
Newly admitted
posted posted 03-01-2002 21:26

thanks emp.



ICQ # 132364102

[This message has been edited by Dark (edited 03-01-2002).]

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 03-01-2002 22:22

Dark: Thanks for the screenshot. You can now avoid the bits of the tutorials which demonstarte how to connect to your DB and create tables by hand just go to the create table option that you can see specify the numbers of fields and the forms will help you fill in the rest of the information. Adding and editing are also made easy with this.

Emps

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted posted 03-01-2002 22:31

What you are looking at there is a MySQl front end called phpMyAdmin.

A database isn't really so much something you see, it's just a way of oganizing data. That screenshot shows just one easy way to manage it. It's mostly for admin chores. You should be putting info into and out of your database via PHPscripts.



:[ Computers let you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila. ]:

Dark
Neurotic (0) Inmate
Newly admitted
posted posted 03-03-2002 02:18

Thanks for your help guys .. I may need a bit of help with the php later on, but so far I'm doing pretty good with it.

So cheers!



ICQ # 132364102

Dark
Neurotic (0) Inmate
Newly admitted
posted posted 03-05-2002 13:00

Update: ok just to let you know what I was working on Emps. I hooked up the Database and everything seems to be working great there. The DB was for a PHP shoutbox that I am going to be working. So instead of starting a new thread I'll just run it by you here. Everything on the Shoutbox is straight foward and just about installs it'self, but I am stuck on a minuscule detail.

I have this in the configuration file.

code:
<?php
$servername = "";
$dbusername = "kriek_admin";
$dbpassword = "***";
$dbname = "kriek_shoutbox";
?>



(No my pass isn't that short .. I just threw that in.)

My question is .. where do I find the same of my server? Is this the "name server" that it's refering to? I was told that it was something like localhost.$servername = "localhost";.



ICQ # 132364102

[This message has been edited by Dark (edited 03-05-2002).]

Xdreamer.ch
Maniac (V) Inmate

From: Switzerland
Insane since: Mar 2001

posted posted 03-05-2002 13:33

most time it is simply: "localhost"

If its different than look up your email from your
isp.

4question: 78595266

cu
~Xdreamer.ch~
-------------------------------
to stupid for transparent sigs

Dark
Neurotic (0) Inmate
Newly admitted
posted posted 03-05-2002 17:47

Edit: "Local host" worked.

[This message has been edited by Dark (edited 03-06-2002).]

« BackwardsOnwards »

Show Forum Drop Down Menu