[advanced search]
Results from the most recent live auction are here.
28 members in the live chat room. Join Chat!
Register Rules & FAQ NP$ Store Active Threads Mark Forums Read
Go Back   NamePros.Com > Design and Development > Webmaster Tutorials
User Name
Password

Old 07-22-2005, 11:56 AM   · #1
Veolus
Account Suspended
 
Veolus's Avatar
 
Name: Neil
Location: Australia
Trader Rating: (69)
Join Date: Dec 2004
Posts: 4,313
NP$: 4.00 (Donate)
Veolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud of
Lightbulb MySQL Database Tutorial - Adding a Username to a Database

The host should be left as localhost

In regards to the creation of the database, username and password, please read below:
1 - Login to cPanel
2 - Navigate to the MySQL Database section in cPanel
3 - Type in the name of the database in the textbox that correspends to "Db:"
4 - Click "Add Db" to create the database
5 - Look where it says "Users" (It should be right under the database creation section)
6 - Type in your desired username in the textbox that correspends to "UserName:"
7 - Type in your desired password in the textbox that corresponds to "Password:"
8 - Click "Add User" to create the username

Now that you have your database and username created, you will have to add the username to the database, please read below:

1 - Look in the top where it has a button saying "Add User to Db"
2 - In the left dropbox corresponding to "User:" you must select the username you created in the first few steps mentioned above
3 - In the right dropbox corresponding to "Db:" you must select the database you created in the first few steps which were also mentioned above
4 - Once you have selected the username and database, you will have to click the button saying "Add User to Db"

Now that you have everything done, it is time to install the script

Host - localhost
Database Name - "cPanelUsername"_DatabaseName
Username - "cPanelUsername"_Username
Password - Password

I hope that briefly explains how to create a database and username and add a specific username to a specific database

NOTE: This tutorial is for learning purposes only If you plan to distribute this tutorial or add this tutorial to your website, please let me know before you do so


Please register or log-in into NamePros to hide ads
Veolus is offline   Reply With Quote
Old 07-22-2005, 04:00 PM   · #2
abdulmueid
NamePros Regular
 
abdulmueid's Avatar
 
Name: Abdul Mueid
Location: Mozambique
Trader Rating: (5)
Join Date: Jun 2005
Posts: 608
NP$: 1.85 (Donate)
abdulmueid has a spectacular aura aboutabdulmueid has a spectacular aura about
This should help alot of those who are struggling to learn basic mySQL DB usage in the most basic control panel called the cPanel.
abdulmueid is offline   Reply With Quote
Old 07-23-2005, 12:15 AM   · #3
Veolus
Account Suspended
 
Veolus's Avatar
 
Name: Neil
Location: Australia
Trader Rating: (69)
Join Date: Dec 2004
Posts: 4,313
NP$: 4.00 (Donate)
Veolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud of
Yep, I wrote it for one of my friends but i just thought i should share it with you guys
Veolus is offline   Reply With Quote
Old 08-23-2005, 06:12 PM   · #4
Red Eyes Arena
NamePros Regular
 
Trader Rating: (2)
Join Date: Aug 2005
Posts: 199
NP$: 50.00 (Donate)
Red Eyes Arena is an unknown quantity at this point
is cPanel like the same for every hosting site that uses it?
Red Eyes Arena is offline   Reply With Quote
Old 08-24-2005, 12:18 AM   · #5
Veolus
Account Suspended
 
Veolus's Avatar
 
Name: Neil
Location: Australia
Trader Rating: (69)
Join Date: Dec 2004
Posts: 4,313
NP$: 4.00 (Donate)
Veolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud of
Depends on the version of cPanel that's in use
Veolus is offline   Reply With Quote
Old 08-24-2005, 06:00 PM   · #6
Red Eyes Arena
NamePros Regular
 
Trader Rating: (2)
Join Date: Aug 2005
Posts: 199
NP$: 50.00 (Donate)
Red Eyes Arena is an unknown quantity at this point
^^ I see. What is the newest version?
Red Eyes Arena is offline   Reply With Quote
Old 08-26-2005, 12:33 AM   · #7
bbalegere
Senior Member
 
bbalegere's Avatar
 
Name: Bharat Balegere
Location: Bangalore
Trader Rating: (15)
Join Date: Jul 2005
Posts: 1,147
NP$: 16.60 (Donate)
bbalegere is just really nicebbalegere is just really nicebbalegere is just really nicebbalegere is just really nice
Thanks for the info.
bbalegere is offline   Reply With Quote
Old 08-26-2005, 04:24 AM   · #8
Veolus
Account Suspended
 
Veolus's Avatar
 
Name: Neil
Location: Australia
Trader Rating: (69)
Join Date: Dec 2004
Posts: 4,313
NP$: 4.00 (Donate)
Veolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud ofVeolus has much to be proud of
Not a problem
Veolus is offline   Reply With Quote
Closed Thread

NamePros is a revenue sharing forum.

Thread Tools

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows deadserious Webmaster Tutorials 96 05-27-2007 01:24 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows deadserious Webmaster Tutorials 35 09-21-2005 09:46 PM
Tutorial: Getting Started With MySQL (The Basics) deadserious Webmaster Tutorials 3 04-18-2004 01:17 PM
help, help, help with phpBB installation seraph Programming 2 10-05-2003 09:05 PM

Site Sponsors
Get Your Site Linked at LinkedKeywords.com Build your NameBrand http://www.internetinvestments.com/
Advertise your business at NamePros
All times are GMT -7. The time now is 03:24 PM.


Powered by: vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0