How To Crate Mysql Database? - urgent help

free web hosting
Open Discussion > General > Hosted Members Area

How To Crate Mysql Database? - urgent help

alexviii
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:

HOW DO I CREATE SUCH DATABASE??????

Using normals ones I just open access and create one. DO I have to download any program that make them?? or I can't if my computer is a simple computer (not server). In this last case, how do I create a MySQL database in my hosted space???

Guys, is very very urgent......

Notice from truefusion:
Moved from Website Discussion > GENERAL

 

 

 


Reply

CrazyRob
do you want to create your own for to do this? as if not just do it in the cpanel sql database section. butr i can help you with either.

also do you want to create tables and stuff in the database as if you do you either need to kow ssh MySQL or php fluently.

Reply

alexviii
QUOTE(mxweb @ Aug 21 2006, 05:42 PM) *

do you want to create your own for to do this? as if not just do it in the cpanel sql database section. butr i can help you with either.

also do you want to create tables and stuff in the database as if you do you either need to kow ssh MySQL or php fluently.



I just wanted to make my pc a server, in order to have my own domain name in internet with my serverat home. how do I do that? should I install "Windows Server" or I can do it dirctly on Windows XP???

 

 

 


Reply

wedee92
hhh! that's funny I want to know how to use mysql to, is good that one of my friend is helping me biggrin.gif ph34r.gif

Reply

CrazyRob
well let me teel you forst of all hosting at home is very bad idea as you will need loads of software to do it either linux or windows server at least then you need mysql php asp asp.net ud be better hosting with a hosting company.

everything can be to complicated believe me ive tried before and the demands were so high the bills started going up so i just cancelled it.

Reply

farsiscript
Hi dear alexviii
Do you want make your system ( Data center ) ohmy.gif (Database part ?)
its really hard
if think you can not do it that
if you want make one mysql server at your pc with apache and php download wamp5
you can find wamp5 software here www.wampserver.com

Reply

OmArEmAd
QUOTE(alexviii @ Aug 22 2006, 01:41 PM) *
I just wanted to make my pc a server, in order to have my own domain name in internet with my serverat home. how do I do that? should I install "Windows Server" or I can do it dirctly on Windows XP???



I think that this could be in windows XP but it will be easier in windows server...

but to make a home server so its a veryyyyyyyyyyyyyyyyyy very very very very big problem

but at last don't ask me how biggrin.gif

at first u must install every thing you need to build your site but sorry i don't know how to make a domain in ur home

Reply

shadowx
I think you would be mad to try to make your own web server at home for several reasons...

your isp wont be happy and might disconnect you from their service and then you would have no internet
you wont have a very high upload speed which means your users will be waiting a very long time for any page to load even if they have a good internet speed.
you would have to consider security which would be a big issue if you have other computers on the same network especially if youre not well experienced in network security
You would have to maintain the server yourself, which again could be an issue if you dont have experience
you might have issues when setting it up if you havnt got experience

Now if youre still hell bent on setting up your own server check out xampp by googling it. I would reccomend that you get xampp anyway as a development environment so that way you can test your php pages without uploading them and then when its time for them to be on the internet you can upload them.

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.

Similar Topics

Keywords : crate mysql database urgent

  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. 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...
  4. Help Regarding Phpbb2 - URGENT PLEASE ! ! ! ! ! (5)
    Hello Friends, I Need an Urgent help.I had installed a phpbb2 forum onto my website and i was
    having it perfectly alright.But Unfortunately i found that many of the users who have joined are
    because of spam , those spammed users post all pornographic content and so on.The thing which puts
    me down is that inspite of the code verification in the signup page of the forum how come these spam
    enter into my forums ? Moreover now i have ennabled admin approval during registration but still
    even though i dont approve them i see their names in the board and their profiles are av...
  5. 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...? ...
  6. 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...
  7. 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...
  8. 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...
  9. 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....
  10. 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?...
  11. 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...
  12. Problem With My Email : [urgent] - Can't send or receive email. (1)
    Hi, I'm having a serious problem. I had a mail account set up through my Cpanel. My site is
    zoebelkin.co.cc and my mail server is mail.zoebelkin.co.cc!!! The mail account which
    I'm talking about is admin@zoebelkin.co.cc But for a week I was not getting mail. Now
    that's wierd cause I get something around 10 mails daily. I then sent a mail from one of my
    other mail id at other mail host whose address is dave2@bluebottle.com just for testing my server.
    But the message didn't ever reach my mail server. I sent many other mails from some other mai...
  13. 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...
  14. Sub Domain Problem : Urgent - Cannot access my sub domains (10)
    Hi, I am having some serious problems with my sub domains. I registered a site with trap17 named
    http://zoebelkin.co.cc . Then I made 2 sub domains for the site. One is for the forums section
    and the other is for the gallery section. 1> forums.zoebelkin.co.cc 2> gallery.zoebelkin.co.cc
    Whenever I type these in the browser adress bar the browser gives an output that it cannot find the
    web sites. But they are complete and should show something. Also using www. in front of the sub
    domains didn't help. Is www. needed in front of the sub domains. Could you just...
  15. 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 ...
  16. 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 ...
  17. Alert! Notice To Hosting Members! Urgent! - (26)
    For some time I have been noticing too many patterns in problems with hosting accounts and their
    passwords. We have a topic that started here:
    http://www.trap17.com/forums/index.php?showtopic=51508 As I manage to regain the control to these
    accounts I began to notice some odd incidences. Namely, I have been noticing that the last IP to
    enter these hosting accounts had similar origin location. The origination is from Vietnam. And
    account effected are passwords with simple and dictionary related passwords. I will be dealing with
    the culprit. In the mean time, dear host...
  18. Default Email Problem In My Cpanel - I need urgent help (2)
    I previously registered my domain name in trap17 as symcom-ng.uni.cc but, for some reason, I decided
    to change it to micron-web.uni.cc Now, I had this email: odomike@symcom-ng.uni.cc as my default
    email addy while I was using the previous domain name but I decided to change my default to
    odomike@micron-web.uni.cc I don't know why odomike@symcom-ng.uni.cc is still showing in the
    sender's address whenever I send an email to anyone. I sent a test email to my Yahoo! email
    addy and what I saw there is odomike@symcom-ng.uni.cc Please help me. how do I change thi...
  19. 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...
  20. 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 ...
  21. 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
    ...
  22. 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,...
  23. 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?...
  24. 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.....
  25. 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...
  26. 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....
  27. 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...
  28. 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?...
  29. Where Is Include Path?! - help plz urgent (5)
    hi i used this path: (include_path='.:/usr/lib/php:/usr/local/lib/php' as include path!
    but it does not work! please help me! where is the include path of ur free hosting?...
  30. 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" />......



Looking for crate, mysql, database, urgent

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for crate, mysql, database, urgent

*MORE FROM TRAP17.COM*
Mysql
Database Not
Working
Ips
Installer
Database
Details
[resolved]
It wont
accept
localhost...
Mysql
Database
Setup :
Setting Up
Mysql
Database
Guide to use
MySQL
database in
your site
Help
Regarding
Phpbb2
URGENT
PLEASE !
! !
! !
Phpmyadmin
Create new
database: No
Privileges
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
Is It
Possible To
Access The
Mysql
Remotely?
I Need Help
Transferring
Sql
Database?
Problem With
My Email :
[urgent]
Can't
send or
receive
email.
Installing
Apache,
Mysql,
Phpmyadmin
Locally
Solving the
"php_mb
string.dll
missing"
;
Sub Domain
Problem :
Urgent
Cannot
access my
sub domains
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.
Alert!
Notice To
Hosting
Members!
Urgent!
Default
Email
Problem In
My Cpanel I
need 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]
Where Is
Include
Path?!
help plz
urgent
Sites
Disapeard,
Mysql
Errors? Also
Server
Folders
Deleted
advertisement



How To Crate Mysql Database? - urgent help



 

 

 

 

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