Jul 20, 2008

Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site

Free Web Hosting, No Ads > General > Hosted Members Area

free web hosting

Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site

OpaQue
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 [MySQL Database] 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 ACCESSED BY ANYONE. AND ONLY THE USERS WHICH YOU SPECIFY CAN ACCESS IT.
SO AFTER YOU CREATE A DATABASE, YOUR NEXT STEP SHOULD BE TO CREATE A USER AND ADD HIM TO THAT DATABASE ( BY GIVING PERMISSIONS )

ADD USER TO DATABASE : THIS WILL ALLOW YOU TO ADD OR PERMIT YOUR CREATED USER TO A PARTICULAR DATABASE.

PHPMYADMIN : A graphical Tool for managing your Created Database

====== STEPS FOR ACCESSING THE DATABASE ======

Create a DATABASE. The names are automatically prefixed by the name of your user account. You will have to access the database hence forth by using that prefixed name. It is done for security reasons. Suppose you create a database "register" then and your username is "abc", then the database created would be "abc_register".

NEXT, Create a USER. ( This user is not your Cpanel username. It is a diffrent one for accessing your database. You are supposed to create this account)

The usernames are also automatically prefixed. So creating a user "tom", creates a user like "abc_tom" where abc is your Cpanel username, you must also specify a password. This will be used for accessing the database using this particular user. Suppose you give the password "timmy". [ PASSWORDS ARE NOT PREFIXED!!! ]

Then you are supposed to give permissions to this USER to access the database.
Go to the respective option and select the USER and the DATABASE and click ADD USER. Most of the times, you will give "ALL" permissions to that user.

Now, when using PHP SCRIPTs, when it prompts for DATABASE Settings, these will be your settings (for above procedure )

[ DATABASE SERVER is the location and it will always be LOCALHOST ]

1 > DATABASE SERVER : localhost
2> Database Name : abc_register
3> Database User : abc_tom
4> Database Password : timmy

SETTINGS LIKE DATABASE PORT are all DEFAULT. So Leave those fields BLANK. The REST all the settings can be anything ( your choice ).

+=========== DATABASE ERRORS ===================
+
+ ONLY THE FOLLOWING ERRORS SHOW THAT THE PROBLEM IS FROM THE SERVER! + THE REST ALL ERRORS ARE DUE TO YOUR OWN MISCONFIGURATION.
+
+============================================

Too many Connection : This means that server is being killed by many people accessing it and you will have to wait before the load decreases. This message is usually because of someone else abusing the server. The Servers are very powerful and it is only the ABUSE by some members, the entire service is affected.

Warning: MySQL Connection Failed: Can't connect
to local MySQL server through socket '/var/lib/mysql/mysql.sock
THIS IS also caused when someone abuses the server. This error has to be handled by our TECHS.

+=============================================
+ DATABASE LOST, DELETED, REMOVED!!
+=============================================

PLEASE KEEP THIS INFORMATION AT THE BACK OF YOUR HEAD.
WE DO **NOT** DELETE ANY DATA.

The Cpanel Will not SHOW your DATABASE if :-
1> The SQL server has been shutdown.
2> SQL server is undergoing upgrades or any other maintananace tasks
3> The SQL server is halted or freezed due to any other reason or abuse.

THIS DOES NOT MEAN that your DATA is GONE. As soon as the Database Server is bought up online, Your database will appear again. Dont take foolish steps or get alarmed by this. Stay cool and calm.

+=============================================
+ WHAT ARE THE REASONS FOR ERRORs!
+=============================================

The main reasons are Noobs who try to execute Faulty scripts. Or Rivals who try to execute Dangerous scripts on purpose.

We have given you a commitment for Quality. It is because of this, We cannot :-
1> Put restrictions on PHP, Perl...
2> We cannot activate safe modes
3> We cannot impose shorter timeouts
4> We cannot Block access to critical controls.
5> We cannot limit your per user CPU usage.
and many more...

If we do this, you will no doubt enjoy a better service, but then there will be no diffrence between the rest and us. You as a talented member chose us because we give you the opportunity to show it and give you all the necesary tools you require.

The Server RESOURCES ARE SHARED! So it is better we use and share it peacefully.
Any member, who affects the server or cause HARM is immediately TERMINATED!

+=============================================

Regards,
OpaQue

 

 

 


Reply

Xedos
Nice one QpaQue. This should solve alot of querys, then again, all the new members will still do the same. Coming in, not reading the pinned topics. I hate those people! I'm gunna start reducing reputation points for asking questions answered in pinned topics.

Anyway: this has also solved some of my querys I have been meaning to ask you. Thanks for this short document.

Reply

owbussey
Is it true that you can have as many mysql databases on this site?

Reply

serverph
QUOTE(owbussey @ Oct 9 2006, 06:27 AM) *

Is it true that you can have as many mysql databases on this site?


how many do you need? biggrin.gif since you are already hosted with trap17, check your cpanel for the number of mysql databases allowed for your account. smile.gif it it says "unlimited", then that basically answers your question. biggrin.gif

Reply

matak
Since this is a topic about MySQL i just might this question here.

I have installed joomla and wordpress and phpb and drupal...

Can I make some script or something so that every user that registers on joomla is also registered on other CMS-s--

Well it's way OT, but since lot's of users might check this topic i guessed it's better to ask here than to write new topic..

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:

Recent Queries:-
  1. setup a mysql on godaddy - 34.19 hr back. (1)
  2. setting up joomla and mysql keeps saying wrong password - 42.58 hr back. (1)
Similar Topics

Keywords : mysql, database, setup, setting, mysql, database, guide, mysql, database, site

  1. Can't Login To Any Software On My Site
    anyone know how to fix? (3)
  2. I Need Help With Setting Up My Site, Made Using Java
    any help would be appreciated (5)
    I just got web hosting approved and I want to host the site I created using Struts framework.
    I'm a complete newb when it comes to web hosting, so I need a little help. Is there a tutorial
    that covers this subject? I apologize in advance if this question was already answered, but
    I've been unable to find the answer anywhere. One thing I have to note is that I need to know
    absolute address of the uploaded files in order for my application to work. Is this even allowed?
    Any help with hosting of Java applications will be appreciated.....
  3. Is The Database System Gone Again?
    Errors on PHPMyAdmin again (10)
    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....
  4. No Site Access
    (4)
    It was working the day before yesterday and then it started giving me error messages about not being
    able to access the site. I can't access cpanel either. Neither page ever loads. I don't
    have this problem with any other internet pages, just my site stuff on Trap17. My site's at
    www.jzambrano.trap17.com btw. This is one of the few times I'll need it up for sure so I'd
    appreciate if the issue can get fixed in the near future. ....
  5. Can't Access My Site An Cpanel
    already did some sugested things (4)
    I still can't get to my website and cpanel, Tings I did: requested xisto to unblock my ip
    cleaned my cache/cookies Did this with both IE and FF When I am @ my dads house he can acces my
    website. So I guess it is still an ip problem. I did read some posts but couldn't find a
    solution. Thx in advance,....
  6. Can't Access My Site....weird Issue
    (5)
    Okay, so last night everything worked fine. I loaded up cpanel, fixed issues with the site after the
    database move, etc. Today I'm unable to load up the site. It just keeps giving me ping
    timeouts. With what I'm being told by others it is only me having this issue with my site, and
    yet there have been 0 changes to my pc between it working and not. I have tried multiple times
    during the day with no luck. Along with this, if I load my website using a proxy service then I do
    not have any issues. The only time it will not allow me to access it is if I am "using" my....
  7. 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....
  8. 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.....
  9. 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...? ....
  10. Reset My Site Pelase
    read for more info (6)
    Can you just reset my cpanel / website FTP and all to how it was when I got it new please? Don't
    change any passwords, just make it so it's like brand new again. thanks --why? because I have
    some files in public_HTML that I am trying to delete even after I give it 777 it says permission
    denied so please reset /smile.gif" style="vertical-align:middle" emoid=":)" border="0"
    alt="smile.gif" />....
  11. Site Help [resolved]
    Showing good on one site but but here on trap17 (6)
    Okay here is the problem. My site www.echo-of-thunder.trap17.com is not showing any graphics,
    Background header logo nothing. Uploaded them all. now here is the kicker to this. it all shows just
    like it it is supposed to show up on my old host What am I doing wrong here.....
  12. 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....
  13. My Site Fails To Load
    My site always times out, and fails to load (16)
    Hey all... Whe I try to access my site, it always times out, when I try to ping, it does the
    same... DNS records are accessible, and I get all my emails for the domain (todorowww.net)... I am
    hosted on Gamma server, and I can access it, and get that cPanel page... But, when I try my site, it
    won't load... Is there some problem with the server or something? FTP doesn't work either...
    This is the case for a few days now, at first I thought it was just a temporary error, but it
    appears not to be... I have avout 20 credits left, so that shouldn't be the issue.......
  14. I Bought A Domain Name Through Godaddy And I Need To Know How To Point It At My Trap17 Site Help Plz.
    (2)
    I would like to point my .com at my forums on here but am unsure how to do it. BTW my site is
    http://racuria.trap17.com/forums ....
  15. Where Does That Noise Come From?
    My Trap 17 web site beeps (6)
    I am posting this here rather than in the 'Web design' topic as it seems to be something
    which happens exclusively to my Trap 17 web site. When i have my web site open, which you can find
    here , every so often (quite regular actually) a short and high pitched beep is sounded. At first I
    thought it had something to do with my sound card or my PC, but recently I discovered it only
    happens when I have my site open. It does not matter which page of the site I have open, or whether
    the page has multimedia embedded in it, I get it regardless of the page I am on. Has....
  16. Site Down After Server Transfer
    (3)
    Hello, I am wandering why my site is down after server transfer. I cannot access control panel
    also. Few days ago I was able to ping the site however now I cannot do that either. My domain name
    is: zedsi.com however my main traffic is comming from my blog: blog.zedsi.com Any suggestions why
    it is still down would be appreciated. On the other hand I have checked on
    www.xisto.com/network-status and gamma is online. Thanks in advance. Best Regards, Hitmanblood....
  17. Site Back Online, But....
    Works on anyone's machine but mine. (20)
    I got a reply from Xisto today that my site was up and running again. Yet, when I surf to it, it
    will not load, also, my email client keeps telling me the POP3 server (the one related to my domain)
    timed out. My Cpanel will not open neither. On my son's laptop (on the same network, hence same
    IP address) the site loads immediately. Has anyone got any idea what the problem my end could be?
    Thanks.....
  18. Server Issues? Web Site Down? Cpanel Access?
    Server Migration issues to report. (48)
    I tried downloading my email from website this morning and Thunderbird said it couldn't access
    it the server. Then I tried loading my website - to no avail. Does anyone have any idea what's
    going on? Is anyone else experiencing this? Seems like this is the second time this spring this has
    happened. Is an upgrade going on, or something? Thanks in advance for your help! ....
  19. Wordpress Backup For A Server Move
    backing up a Wordpress site (2)
    i have question: how can we backup wordpress from fantastico...is it possible to backup and move
    it to new host if you want?....
  20. My Site Is Down... Again [resolved]
    (4)
    My site and forum have been down for the last 4 hours. It appears to be the php scripts only that do
    not work, as every other part of my site is working okay. But my site is a php powered CMS and
    forum. This down time has actually been happening a lot. Its particularly frustrating when trying
    to add content on the site(joomla), and the page times out and everything gets lost and I have to
    start over again. It is hard to have a community when the site is never working. When is my site
    going to come right? And why all the down time? I noticed that in server status the ....
  21. Thinking About New Site, But...
    How? (5)
    Alright, here's the deal: I'm thinking about creating a new site called
    www.USACompanies.com (or at least the name I'm going with right now) to provide Americans with
    info about how many employees of companies are Americans, what percentage of total employees of
    companies are Americans, what the average salaries of workers are, what CEO's are paid, what
    benefits companies give workers, etc. Basically an informational site allowing Americans to support
    companies that are good for America. Anyway, here's the dilemma: I'm not sure whether to
    set ....
  22. Some Pages On My Site Won't Even Load..
    (6)
    Ever since today, my site has been working just fine. I'm maintaining the amount of points I
    need, and the server status has been and still is fine. However, a while ago I tried to access my
    site and it wasn't loading. When I loaded the root URL, it worked fine though. I went to the
    file manager and noticed that the file I was trying to previously access was .php, and the index
    file at my root URL was .html. I deleted the index.html file and made a index.php file, then tried
    loading it again. Safari gave me the following message: QUOTE Safari can’t ope....
  23. Setup Forum
    ????? (2)
    How do we set up a forum with SMF? When I press extract, it downloads the file. This is messed up.....
  24. Setting Up Ftp Accounts
    (4)
    I would like to setup an FTP account for users of my website, but I'm not too sure how to do it.
    I'm using Joomla for a website, and the members who register can submit Articles in certain
    sections. I would like most of the images in these articles stored locally(also to get some
    functions, they need certain extensions on the file name, which a free host cannot do). So I would
    like there to be an FTP account that members can access and upload images too, but not delete any of
    them. Thanks.....
  25. How To Publish My Site Through Expression Web
    i don't know how anyone could help me (4)
    i'm using expression web and i like to publish my site directly here problem is i don't know
    how can anyone help me....
  26. I Cannot Access My Site. [resolved]
    Am I blocked by Firewall? (13)
    Hi, is there a server problem? All of a sudden I cannot get through to
    http://www.vlaanderen-flanders.org.uk anymore, nor can I FTP. Could someone check this out,
    please?....
  27. 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?....
  28. 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....
  29. 403 Forbidden Error When Accessing My Site
    (10)
    umm this is a problem that i have been looking in other topics to try to fix but i can't seem to
    find a answer to what i lookin for. I got my site workin again the other day ok and so i went on to
    see it (so i can make more changes) and when i got there i got this QUOTE Forbidden You
    don't have permission to access / on this server. Additionally, a 403 Forbidden error was
    encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.33 Server at
    www.clansga.trap17.com Port 80 now i looked at everything and i can't seem to find t....
  30. Help!!
    Help me on my site.... (8)
    Sorry, I may seem like a total geek, but where should I upload my index page, and what should it be
    named, and are page names case-sensitive? Thank you very much.....

    1. Looking for mysql, database, setup, setting, mysql, database, guide, mysql, database, site

Searching Video's for mysql, database, setup, setting, mysql, database, guide, mysql, database, site
Similar
Can't
Login To Any
Software On
My Site -
anyone know
how to fix?
I Need Help
With Setting
Up My Site,
Made Using
Java - any
help would
be
appreciated
Is The
Database
System Gone
Again? -
Errors on
PHPMyAdmin
again
No Site
Access
Can't
Access My
Site An
Cpanel -
already did
some
sugested
things
Can't
Access My
Site....weir
d Issue
How Do I
Find My
Mysql
Password?
[resolved] -
Cannot
access my
MySQL
Remote
Access Mysql
Phpmyadmin -
Create new
database: No
Privileges
Reset My
Site Pelase
- read for
more info
Site Help
[resolved] -
Showing good
on one site
but but here
on trap17
I Need Help
Transferring
Sql
Database?
My Site
Fails To
Load - My
site always
times out,
and fails to
load
I Bought A
Domain Name
Through
Godaddy And
I Need To
Know How To
Point It At
My Trap17
Site Help
Plz.
Where Does
That Noise
Come From? -
My Trap 17
web site
beeps
Site Down
After Server
Transfer
Site Back
Online,
But.... -
Works on
anyone's
machine but
mine.
Server
Issues? Web
Site Down?
Cpanel
Access? -
Server
Migration
issues to
report.
Wordpress
Backup For A
Server Move
- backing up
a Wordpress
site
My Site Is
Down...
Again
[resolved]
Thinking
About New
Site, But...
- How?
Some Pages
On My Site
Won't
Even Load..
Setup Forum
- ?????
Setting Up
Ftp Accounts
How To
Publish My
Site Through
Expression
Web - i
don't
know how
anyone could
help me
I Cannot
Access My
Site.
[resolved] -
Am I blocked
by Firewall?
Is It
Possible To
Access The
Mysql
Remotely?
Installing
Apache,
Mysql,
Phpmyadmin
Locally -
Solving the
"php_mb
string.dll
missing"
;
403
Forbidden
Error When
Accessing My
Site
Help!
3; - Help me
on my
site....
advertisement



Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site



 

 

 

 

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