HomeHelpSearchLoginRegisterweb hosting reviews
host rating, hosting awards, host
web hosting forum web hosting review

Welcome, Guest. Please login or register.
Did you miss your activation email?
May 19, 2012, 04:40:30 AM

Login with username, password and session length
Search

News
Welcome to WebHostGossip.com, click here to register!

Top 10 Web Hosting Company





HostMonster



Professional Hosting from Just Host

Easy CGI Web Hosting

GoDaddy.com

Host 6 Domains on 1 Account

PowWeb Hosting - *On Sale * $3.88/month!

Website 120x60 Logo


Stats
797 Posts in 483 Topics by 470 Members
Latest Member: jenelleevans
+  WebHostingGossip.com
|-+  Technical Help
| |-+  MySql
| | |-+  MySQL databases
« previous next »
Pages: [1] Print
Topic: MySQL databases  (Read 587 times)
Web Hosting Gossip
Administrator
Newbie
*****
Posts: 29


View Profile Email
« on: December 13, 2008, 08:14:33 PM »

This section displays your current databases and the users assigned to each one. Below this are the options which control everything to do with your MySQL databases:

Creating a New Database

Simply enter the name of the database you wish to create and click the Add DB button. The DB name will be prefixed with your account username and an underscore so the full DB name will be username_dbname

Creating a User

Simply enter a username and password and click the Add User button. The username will be prefixed with your account username and an underscore so the full DB username will be username_dbusername

You can create one user which you can add to all your databases or create a different user for each database which adds to security.

Add a User to a Database

You must create a user and add them to a database before that database can be used by, for example, a PHP script.

Select the user from the first drop-down box and select the database from the second drop-down menu and click the Add User to Db button.

Access Hosts

If you wish a website on another domain to be able to access and use one of your databases, you can add the domain to allow access to in this section.

Simply enter the domain name (without the www.) and click the Add Host button.

phpMyAdmin

You can use phpMyAdmin to administrate your MySQL databases in a web based environment.
Logged
gandusanthoshkumargs
Jr. Member
**
Posts: 54


View Profile Email
« Reply #1 on: July 29, 2010, 06:14:13 AM »

Hi,

MySQL databases is used as
Simply enter the name of the database you wish to create and click the Add DB button. The DB name will be prefixed with your account username and an underscore so the full DB name will be username_dbname and it has other uses also.

regards,

phe9oxis,

http://www.dynamicdrive.com
Logged
gandusanthoshkumargs
Jr. Member
**
Posts: 54


View Profile Email
« Reply #2 on: July 29, 2010, 06:18:08 AM »

Hi,

MySQL databases it is used in many ways

Add a User to a Database

regards,

phe9oxis,

http://www.dynamicdrive.com
Logged
Pages: [1] Print 
« previous next »
Jump to:  

web hosting reviews










CopyRight 2008 www.Viewty-LG.com
Powered by SMF 1.1.4 | SMF © 2006-2007, Simple Machines LLC
Amber design by Bloc | XHTML | CSS
web hosting forum