Welcome Guest ( Log In | Register)



5 Pages V   1 2 3 > »   
Reply to this topicStart new topic
> Mysql Database Help, need help with MySQL databases...skip to page three
Dayzed
post Apr 3 2005, 09:40 PM
Post #1


Member [Level 2]
*****

Group: Members
Posts: 78
Joined: 18-January 05
Member No.: 3,318



I just got hosted on Friday, and I just uploaded all the FTP files and SQL file. Now, I am losted at what to do. I thought since I uploaded all the files, it would work, but it doesnt. I am making a LUE2/OG-like site. You can help by posting a message here or emailing me or AIMing at mutatedmonkeycat. (AIM perfered..)

This post has been edited by snlildude87: Apr 9 2005, 07:01 PM
Go to the top of the page
 
+Quote Post
JaVe
post Apr 4 2005, 02:12 PM
Post #2


Super Member
*********

Group: Members
Posts: 262
Joined: 2-October 04
Member No.: 1,393



So, it uses sql? Did you put it to the right adress a.k.a localhost (because it's hosted on trap's server). Btw, what is not working? What are the error messages? We need the details because it's like saying, my computer doesn't work, can you fix the problem. Details details...
Go to the top of the page
 
+Quote Post
NilsC
post Apr 4 2005, 09:47 PM
Post #3


Administrator
*********

Group: Members
Posts: 377
Joined: 28-December 04
From: USA
Member No.: 2,992



did you signup using gigapass.com like you said on your application?

1 you have not pointed your "DNS Record" nameservers to trap17 name servers yet. Until you do that I don't know how any of your data would be accessible. Your cpanel is accessible using the IP address only.
QUOTE
Your NS records at the parent servers are:

ns.kornet.net. [211.216.50.150] [TTL=172800] [KR]
ns2.kornet.net. [211.216.50.160] [TTL=172800] [KR]

[These were obtained from m.gtld-servers.net]


So until you update your NS record everything you do are in vain. smile.gif

Nils
Go to the top of the page
 
+Quote Post
Dayzed
post Apr 8 2005, 08:49 PM
Post #4


Member [Level 2]
*****

Group: Members
Posts: 78
Joined: 18-January 05
Member No.: 3,318



There are no error messages, it just doesnt work. :\

I uploaded all the files, and when I try to go to my site afterwards (www.gigapass.trap17.com) it gets the "Welcome to your site!" thing. :\

NilsC, where do I put those numbers? >_>
Go to the top of the page
 
+Quote Post
Dayzed
post Apr 8 2005, 08:54 PM
Post #5


Member [Level 2]
*****

Group: Members
Posts: 78
Joined: 18-January 05
Member No.: 3,318



Also, what is the data base name?
Go to the top of the page
 
+Quote Post
Argoth
post Apr 8 2005, 09:57 PM
Post #6


Newbie [Level 2]
**

Group: Members
Posts: 29
Joined: 6-April 05
Member No.: 5,318



First, what folder did you upload your files to?
Next, your batabase name is USERNAME_ then the database name, er, at least I Think it is...

Also make sure that the index page is changed to be your index page not the index page that was on when you first got your account...
Go to the top of the page
 
+Quote Post
Dayzed
post Apr 9 2005, 01:10 AM
Post #7


Member [Level 2]
*****

Group: Members
Posts: 78
Joined: 18-January 05
Member No.: 3,318



QUOTE(Argoth @ Apr 8 2005, 04:57 PM)
First, what folder did you upload your files to?
Next, your batabase name is USERNAME_ then the database name, er, at least I Think it is...

Also make sure that the index page is changed to be your index page not the index page that was on when you first got your account...
*




Er, I uploaded the files to seperate files. There are about 50 of 'em. I still dont know what the database name is, would it be USERNAME_trap17 (so really it would be dayzed_trap17?)

How do you change the index page?
Go to the top of the page
 
+Quote Post
Argoth
post Apr 9 2005, 04:12 PM
Post #8


Newbie [Level 2]
**

Group: Members
Posts: 29
Joined: 6-April 05
Member No.: 5,318



Go to, Cpanel click on file manager, click on the folder next to "public_http", click on index.html then click edit on the right. A window will open with the code to the index page.

Make sure that the files you uploaded are in the public_http folder or you won't be able to access them.

You need to make a database before you can access it. To make a database go to cpanel, click on MySQL Databases, type whatever you want to call the database in the textbox and click "Create MySQL database". Then create a new user to access the database. Click on "go back", scroll down to where it says "Existing MySQL Users", type a name for the new user there and a password. Click "Create MySQL user".
Now allow the user to change the database. Click "go back", scroll to where it says " Grant permissions on a MySQL database to a MySQL user" and choose the user you made and the database you made. make sure "ALL" is clicked under privileges then click "Grant Permissions".

The database name is then the "YOURUSERNAME_YOURDATABASENAME" and then your username is "YOURCPANELUSERNAME_YOURDATABASEUSERNAME"
Go to the top of the page
 
+Quote Post
Dayzed
post Apr 9 2005, 05:07 PM
Post #9


Member [Level 2]
*****

Group: Members
Posts: 78
Joined: 18-January 05
Member No.: 3,318



I see no 'public_http.'

There is 'public_ftp' and 'public_html.' Thats it. :\
Go to the top of the page
 
+Quote Post
<
snlildude87