NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Webmaster Tutorials
Reload this Page MySQL Database Tutorial - Adding a Username to a Database

Webmaster Tutorials Instructional webmaster-related how-to's and tutorials.

Advanced Search


Closed Thread
 
LinkBack Thread Tools
Old 07-22-2005, 12:56 PM THREAD STARTER               #1 (permalink)
Account Suspended
 
Veolus's Avatar
Join Date: Dec 2004
Location: Australia
Posts: 4,309
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"
????: NamePros.com http://www.namepros.com/webmaster-tutorials/108916-mysql-database-tutorial-adding-username-database.html

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
Veolus is offline  
Old 07-22-2005, 05:00 PM   #2 (permalink)
Account Closed
 
abdulmueid's Avatar
Join Date: Jun 2005
Location: Mozambique
Posts: 607
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  
Old 07-23-2005, 01:15 AM THREAD STARTER               #3 (permalink)
Account Suspended
 
Veolus's Avatar
Join Date: Dec 2004
Location: Australia
Posts: 4,309
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  
Old 08-23-2005, 07:12 PM   #4 (permalink)
NamePros Member
Join Date: Aug 2005
Posts: 198
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  
Old 08-24-2005, 01:18 AM THREAD STARTER               #5 (permalink)
Account Suspended
 
Veolus's Avatar
Join Date: Dec 2004
Location: Australia
Posts: 4,309
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  
Old 08-24-2005, 07:00 PM   #6 (permalink)
NamePros Member
Join Date: Aug 2005
Posts: 198
Red Eyes Arena is an unknown quantity at this point
 



^^ I see. What is the newest version?
Red Eyes Arena is offline  
Old 08-26-2005, 01:33 AM   #7 (permalink)
Senior Member
 
bbalegere's Avatar
Join Date: Jul 2005
Location: Bangalore
Posts: 1,271
bbalegere is just really nicebbalegere is just really nicebbalegere is just really nicebbalegere is just really nicebbalegere is just really nice
 



Thanks for the info.
bbalegere is offline  
Old 08-26-2005, 05:24 AM THREAD STARTER               #8 (permalink)
Account Suspended
 
Veolus's Avatar
Join Date: Dec 2004
Location: Australia
Posts: 4,309
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  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


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 02:24 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows deadserious Webmaster Tutorials 35 09-21-2005 10:46 PM
Tutorial: Getting Started With MySQL (The Basics) deadserious Webmaster Tutorials 3 04-18-2004 02:17 PM
help, help, help with phpBB installation seraph Programming 2 10-05-2003 10:05 PM

Liquid Web Smart Servers  
All times are GMT -7. The time now is 01:32 PM.

Managed Web Hosting by Liquid Web
Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger