Jul 20, 2008

Mysql Database Help - need help with MySQL databases...skip to page three

Free Web Hosting, No Ads > General > Hosted Members Area
Pages: 1, 2, 3, 4, 5

free web hosting

Mysql Database Help - need help with MySQL databases...skip to page three

Dayzed
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..)

Reply

JaVe
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...

Reply

NilsC
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

Reply

Dayzed
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? >_>

Reply

Dayzed
Also, what is the data base name?

Reply

Argoth
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...

Reply

Dayzed
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?

Reply

Argoth
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"

 

 

 


Reply

Dayzed
I see no 'public_http.'

There is 'public_ftp' and 'public_html.' Thats it. :\

Reply

snlildude87
public_html is the one you should look in

Answer me this...what is the name of the first webpage people will see when they go to yoursite? If it's not index.htm, index.html, or index.php, then rename it to any one of those three, and delete the existing index.html in your public_html folder in your cpanel.

Reply

Latest Entries

Argoth
Hey, I was going to get to be an admin for helping!

didn't know that. So you can give it to the other guy.

Reply

Dayzed
Thanks to everyone who helped! I got someone to rewrite some of my scipts, so pretty much all of them are rewritten. The thing is I forgot my password to my cpanel, since its suddenly gone from my hard drive, so I cant try it.

Argoth, Mike, I'm sorry, but I cannot make both of you admins, I'm really sorry. Would any of you like to not take the position and give it to the other? As I said I'm sorry, but I dont want to have three admins and no members. If one is an admin maybe I can make one a mod....

Reply

Argoth
Lets' get rid of the first 2 errors then we'll fix the next 2.

Post the code around line 47 in the config.inc.php file.

Reply

Dayzed
1. Create new database for the boards. I understand that.
2. Then I use the SQL in the SQL file to create the table for the boards. Thats in the SQL.SQL file correct?
3. Then I go into the config.inc.php and edit the database connection variables to yours. I did do that-- I think. Thats what Argoth was helping me with...

Reply

Mike
Once you upload the files, you have to create a new database for the boards. Then you use the SQL in the SQL file to create all the tables needed for the boards. Then you go into the config.inc.php and edit the database connection variables to the yours. It should look like this:

CODE

$_MYSQL['dbhost'] = 'localhost';
$_MYSQL['dbuser'] = 'CPANELUSERNAME_DBUSER';
$_MYSQL['dbpass'] = 'DBUSERPASS';
$_MYSQL['dbname'] = 'CPANELUSERNAME_DBNAME';

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Pages: 1, 2, 3, 4, 5
Similar Topics

Keywords : mysql database mysql databases skip

  1. Is The Database System Gone Again? - Errors on PHPMyAdmin again (9)
  2. How Do I Find My Mysql Password? [resolved] - Cannot access my MySQL (5)
    After all the recent problems, my account has been restored. I have setup my parked domain agin, and
    that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
    that's all). I had to create a new user for my databases, and created the user with exactly the
    same username and password I had before, but some of my web pages do not let me access the pages I
    have associated with my databases. Where could i find out what my DB password is? (Although I am as
    good as sure I am using the right one). I have tried my old password, the new c...
  3. Remote Access Mysql - (8)
    Is it possible to directly access my local database from my website? For example, if somebody
    submits info on my website, the info they submitted would be transferred to my local database
    directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
    my database to my subdomain is because it would be difficult to keep the website database and my
    local database in sync . . . or is there a way to do that? Thanks for any replies....
  4. Is It Possible To Access The Mysql Remotely? - (10)
    I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
    in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
    remotely. If that's not possible, are we allowed to run Python scripts on the server?...
  5. Phpmyadmin - Create new database: No Privileges (6)
    i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
    install it the error is like this Creating Database Tables No database selected there a mysql
    database is made, but i can not use it for othere stuff... plz note that this is Free script and not
    for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
    but i am not sure if the script not working or it can be the server may be down on mysql...? ...
  6. I Need Help Transferring Sql Database? - (3)
    ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the
    database. I am using phpmyadmin on both sides of the hosts. When i do the import i get this.
    QUOTE SQL query: -- -- Database: `apolopedia` -- CREATE DATABASE `apolopedia`
    DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access
    denied for user 'jaenagle'@'localhost' to database 'apolopedia' I tried to
    give my user all rights, but it gave me this also. QUOTE SQL query: GRANT A...
  7. Installing Apache, Mysql, Phpmyadmin Locally - Solving the "php_mbstring.dll missing" (5)
    Since Trap17's CP provide the individual site's owner with goodies like MySql and
    PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
    on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
    expected that most people considering to make use of a database on their site will want to do most
    of the tedious job of developing and testing on their own local system before sending the wrapped-up
    result on their domain/subdomain. This involves four basic steps (sorry for the compuwi...
  8. Cant Create Any More Databases [resolved] - In myphpadmin (5)
    Hi all, I can't seem to create a new database, I thought we have unlimited databases in mysql
    with our free hosting, If I'm wrong then disregard this. I have only 1 database created on my
    account and I need another as using the same one would be conflicts with my naming convention.
    Anyone have any idea why? # Create new database: Documentation No Privileges ...
  9. Question About The Upgrade And The Mysql Usage ? - question about the upgrade and the mysql usage? (3)
    thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
    Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
    1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
    Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
    Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
    Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ...
  10. Changes In Phpmyadmin - Access to my database from program not working anymore. (0)
    I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
    explaining this correctly). I run a newsletter system on my website and the details of the people
    who subscribed are in a MySQL database. To get those data from the database and to send the
    newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
    perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
    setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ...
  11. How To Crate Mysql Database? - urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ...
  12. Need Help With My Database - I cannot transfer my old site's database (19)
    I Couldn't import my database info via Import from php my admin and i got the .sql file from the
    php my admin of my old hosting and every time i try to import it give me an error that i don't
    have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" /> What shall i do?? I need Help Please...
  13. Question About Adding Message Board To Site - Using mysql? (5)
    Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
    how can I set up a messageboard. Thanks. std split from another topic ...
  14. Installing Phpbb - database problem (0)
    Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
    the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
    is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
    connect to the database Im not sure why this has happened as i have never really used mysql for
    ...
  15. Phpbb2.17 Mysql Problems - Just this week they started (4)
    The forum has been up and running for about a year and a half. It has been through numerous server
    upgrades, etc, including the recent HDD change, but for some reason, just this week it started
    throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
    SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
    be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
    u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,...
  16. Database Connection Problem - phpBB2 installation error (5)
    *edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
    Transfered all of the database files over. On my new forums all of the old posts and everything
    shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
    me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
    says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
    know anyway to fix this?...
  17. Database Errors! - Started after HDD change.. (5)
    Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
    refresh site, they not that often but still i get them. It says "could not connect to database". And
    i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
    database! This is a notice email to let you know that SMF could not connect to the database,
    contact your host if this continues. so i am contacting my host.....
  18. 99 Mysql Databases? - (2)
    I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
    lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
    have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
    just prefix my tables, but I was just wondering why it would say that. If for some reason it was
    letting me get more than one database, and I wasn't supposed to, I don't want to get my
    account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m...
  19. Mysql Access Error[resolved] - (5)
    The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
    never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
    Please kindly look into this....
  20. Mysql Server Problems [resolved] - (3)
    hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
    ERRORS, like that the server is going down so now and often is it due to my cms or is the server
    having some probs ? this is what i just saw from the statistics: QUOTE Service Status
    named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
    (5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
    Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17...
  21. Cpanel And Mysql Problem. [resolved] - (3)
    hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
    to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
    ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
    loads with a blank page. however both worked earlier today. so is there a problem with the server?
    and if there is, will it be fixed?...
  22. Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site (4)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE...
  23. Sites Disapeard, Mysql Errors? Also Server Folders Deleted - (18)
    Hello its 15:40 and I login see if everything runs oke, and I see numerus things deleted my mysql is
    working again. Whats going on? My Webpage couple websites got deleted, and server folder files now
    whats going on? /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> my
    forum also give errors but mysql db stil there /sad.gif" style="vertical-align:middle" emoid=":("
    border="0" alt="sad.gif" />......
  24. The Difference Between Mysql And Postgresql ? - (4)
    I found those two in cPanel and they loofed nearly the same as each other but what is the difference
    ? I tried to go to phpMyAdmin and phpPgAdmin and they are nearly the same too. Do you know that ?
    Please reply , thanks a lot....
  25. Mysql Backup Cronjob - How to? : / (6)
    Well, I want basically a cron job that will run and backup my MySQL database. I've been told
    in the shoutbox that you can do it via cron job. Didn't told me how. Now, I just want help on
    how to do it and what commands I should put in the cPanel. ...
  26. Still Can't Create Databases In Phpmyadmin - Help please. (8)
    Still can't create databases in phpmyadmin, and this has been going for weeks now, and i am
    suposed to have privileges to create databases, am i right? So why can't i still, after weeks,
    can't create databases? Please, i wish to know why this is happening, and if i am the only one
    with this problem....
  27. Does Trap17 keep back-ups of my MySQL Databases? - (6)
    ok, well i screwed up yes i admit it i screwed up big time... anywho, umm i was wondering is
    trap17 kept back-ups of the MySQL Databases??? and if they do would it be possible for me to get a
    copy of the backup for my forums sent to me somehow? because stupid me, i was re-installing my
    forums, and went to make a backup of my MySQL database jsut in case, and selected all and hit make
    backup, and well it only made a backup of only one of the databses, so right now i am without the
    many posts i had ten minutes ago so if you so keep backups thats awsome!! youv...
  28. How Do You Check Mysql Info, And Act According To It's Content? - (6)
    As part of a web-game on my site, I have a php form that requires people to enter their username,
    and information about the characters they want to have in the game. All this information is stored
    into a MySQL table. I want the players to be able to visit a page where every character they have
    registered with their username can be seen. My question is simply, how can I check the values of
    the MySQL data, and act accordingly? What I need to do is check for a Username and a character
    number, and if it finds it, takes the data in that part and acts on it, eg. by showing th...
  29. Database Is Deleted - database is deleted today (6)
    Today ,I access to my website and It can't connect to database,so I came to cpanel and I saw
    that my database is deleted.I have a question here ,why do my database is deleted?...
  30. I Can Not Create Mysql Databases In Control Panel Using Phpmyadmin - Phpmyadmin says i don't have permissions to create databases (3)
    I went to phpmyadmin script a few minutes ago and i could not create a database. Since it says
    there on my control panel that i have unlimited mysql databases, plus i am using only a couple of
    databases, please respond and fix this, please....



Looking for mysql, database, mysql, databases, skip, page

Searching Video's for mysql, database, mysql, databases, skip, page
Is The
Database
System Gone
Again?
Errors on
PHPMyAdmin
again
How Do I
Find My
Mysql
Password?
[resolved]
Cannot
access my
MySQL
Remote
Access Mysql
Is It
Possible To
Access The
Mysql
Remotely?
Phpmyadmin
Create new
database: No
Privileges
I Need Help
Transferring
Sql
Database?
Installing
Apache,
Mysql,
Phpmyadmin
Locally
Solving the
"php_mb
string.dll
missing"
;
Cant Create
Any More
Databases
[resolved]
In
myphpadmin
Question
About The
Upgrade And
The Mysql
Usage ?
question
about the
upgrade and
the mysql
usage?
Changes In
Phpmyadmin
Access to my
database
from program
not working
anymore.
How To Crate
Mysql
Database?
urgent help
Need Help
With My
Database I
cannot
transfer my
old
site's
database
Question
About Adding
Message
Board To
Site Using
mysql?
Installing
Phpbb
database
problem
Phpbb2.17
Mysql
Problems
Just this
week they
started
Database
Connection
Problem
phpBB2
installation
error
Database
Errors!
Started
after HDD
change..
99 Mysql
Databases?
Mysql Access
Error[resolv
ed]
Mysql Server
Problems
[resolved]
Cpanel And
Mysql
Problem.
[resolved]
Mysql
Database
Setup :
Setting Up
Mysql
Database
Guide to use
MySQL
database in
your site
Sites
Disapeard,
Mysql
Errors? Also
Server
Folders
Deleted
The
Difference
Between
Mysql And
Postgresql ?
Mysql Backup
Cronjob How
to? : /
Still
Can't
Create
Databases In
Phpmyadmin
Help please.
Does Trap17
keep
back-ups of
my MySQL
Databases?
How Do You
Check Mysql
Info, And
Act
According To
It's
Content?
Database Is
Deleted
database is
deleted
today
I Can Not
Create Mysql
Databases In
Control
Panel Using
Phpmyadmin
Phpmyadmin
says i
don't
have
permissions
to create
databases
advertisement



Mysql Database Help - need help with MySQL databases...skip to page three



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE