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

Pages: 1, 2, 3, 4, 5
free web hosting

Read Latest Entries..: (Post #48) by Argoth on Apr 11 2005, 01:57 AM. (Line Breaks Removed)
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.
Read the FIRST post of this Topic. - Express your Opinion! Contribute Knowledge :-).

Open Discussion > General > Hosted Members Area

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.

Pages: 1, 2, 3, 4, 5
Recent Queries:-
  1. mysql backup batabase - 570.66 hr back. (1)
Similar Topics

Keywords : mysql, database, mysql, databases, skip, page

  1. Mysql Database Not Working
    (3)
  2. Ips Installer Database Details [resolved]
    It wont accept localhost... (6)
    CODE Access denied for user 'skyed211_central'@'localhost' to database
    'skyed211_centralgaming' I get this error message when trying to install my IPB. It will
    not accept localhost, nor mysql. Can I get any help please? I've tried many times to get past
    this part, but it's not happening /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" />....
  3. It Went Well For A While
    MySQL problem back in all its glory. (5)
    Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
    website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
    effect. File(include/errors.xml) is not within the allowed path(s):
    (/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
    fopen(include/errors.xml) : failed to open stream: Operation not permitted in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
    incl....
  4. Is The Database System Gone Again? [resolved]
    Errors on PHPMyAdmin again (12)
    I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
    again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
    failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
    Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
    current setting of session.save_path is correct
    (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
    /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca....
  5. 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....
  6. 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.....
  7. Phpmyadmin
    Create new database: No Privileges (7)
    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...? ....
  8. 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....
  9. 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 ....
  10. 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 ....
  11. 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 ....
  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. 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....
  18. 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......
  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. 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" />.......
  23. 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.....
  24. 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. ....
  25. 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.....
  26. 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?....
  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 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: ....
  29. 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....
  30. Mysql Database Setup : Setting Up Mysql Database
    Guide to use MySQL database in your site (6)
    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....

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

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for mysql, database, mysql, databases, skip, page

*MORE FROM TRAP17.COM*
Similar
Mysql Database Not Working
Ips Installer Database Details [resolved] - It wont accept localhost...
It Went Well For A While - MySQL problem back in all its glory.
Is The Database System Gone Again? [resolved] - Errors on PHPMyAdmin again
How Do I Find My Mysql Password? [resolved] - Cannot access my MySQL
Remote Access Mysql
Phpmyadmin - Create new database: No Privileges
I Need Help Transferring Sql Database?
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.
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
99 Mysql Databases?
Database Errors! - Started after HDD change..
Mysql Access Error[resolved]
Mysql Server Problems [resolved]
Cpanel And Mysql Problem. [resolved]
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.
Is It Possible To Access The Mysql Remotely?
Does Trap17 keep back-ups of my MySQL Databases?
How To Crate Mysql Database? - urgent help
Installing Apache, Mysql, Phpmyadmin Locally - Solving the "php_mbstring.dll missing"
Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site
advertisement



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



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
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