Go Back   Internet Business Forums > Webmasters

Reply
 
Thread Tools Display Modes
Old 20-06-2005, 09:47 AM   #1 (permalink)
Business Guru
 
Brian Turner's Avatar
 
Join Date: Dec 2003
Location: Near Inverness, Highlands, Scotland
Posts: 7,671
Default Setting up a database in CPanel

If your hosting account has CPanel for site administration, you can use it for a variety of useful functions.

One particularly useful feature is the ability to create databases directly, which is often necessary for installing database driven software - such as some forums, directories, and blogs.

To set up a database with a username, password, and name, access CPanel with a secure login from:
https://www.your-domain.com:2083

When you're there, you should see an option for "MySQL Databases". Click on that link.

Once in, you'll see various options. Look for a line that says "Db:" then has an empty box following, with the button "Add Db" after. Enter your database noame in here (keep it relatively short) and click the Add Db button.

Then when the page reloads, look for the "Users" section, which includes two boxes - Username and Password. Enter your values here and then click on "Add User".

Now you need to associate the user with the database - there should be two drop down boxes on the page - one for databases and one for users. Line up your preferred user and database, then click "Add user to Db".

NOTE: Your CPanel account username will act as a prefix for your database name and username. Ensure that you write these values correctly in your software config file.

Hope that helps - any more questions, feel free to ask.
__________________
SEO specialist
Brian Turner is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


All times are GMT +1. The time now is 05:08 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.