Web Development
PHP
Html / Xhtml
CSS
Javascript / Ajax
Ruby
PERL
Adobe Photoshop
Maybe you should let the Community
know too! Go ahead, get creative and express yourself
know too! Go ahead, get creative and express yourself
The more members and activities we have going on, the more
chances you have of excelling too. So why not
invite your friends!
invite your friends!
How-To Guides
- To setup your first database, you'll need to log into cPanel (www.yourdomain.com:2082)
From there, you'll need to scroll down towards the bottom of the page and locate this section.
After you've clicked on on MySQL Databases, you'll find the Database Administration tools. At the top of the page, you'll see
In the box, you can type in the database name you'll be using.
- For this example, we'll create a database called test. After you've typed test you should see a green check mark to show you that there are no other databases with the same name.
Click Submit
- On the next page, you will see the confirmation message
Where x equals the name of your cPanel login.
Click [Go Back]
- Now you are back at the page you just where before you created the database.
From here, you are going to need to create a user. This user will also be assigned to the database, with that in mind, you'll need to give this user various permissions in order to work in the phpMyAdmin Environment.
- Now, as we said, you should now be back at the page prior to creating your database, scroll towards the bottom and look for this.
This is where you will create a username and a password. When choosing a password, we recomend that you use the Generate Password feature. This will create a very unique and obscure password that will give you a higher level of protection versus on you may pick.
Once you've generated a password, or choose one yourself, click Create User
- On the next page, you will see the confirmation message stating the creation of the user.
Where x equals the password.
Click [Go Back]
- Now, back to the page where you created the database and created the user. Scroll down towards the bottom once more and look for
xxxx is where your cPanel login name should be. Click Add
- On the next page, you'll be given the options as to which permissions to give the user.
Since this is our first database, and we will be the only one's using it, we will assign it ALL PRIVILEGES
SELECT - Can draw results from database.
INSERT - Can insert information into the database.
UPDATE - Can adjust and update information in the database.
DELETE - Can delete information from the datbase.
INDEX - Can create or delete Indexes from the Database.
CREATE TEMPORARY TABLES - Can create temporary tables within the database.
CREAT - Can create tables and information in the database.
ALTER - Can alter or rename tables inside the database.
DROP - Can drop (delete) tables in the database.
LOCK TABLES - Can lock tables, restrict access and input of information.
REFRENCES - Has no purpose as of yet.
CREATE ROUTINE - Can create stored procedures and functions within the database.
Click Make Changes
You should now see
xxxx equals the name of your cPanel login.
Click [Go Back]
And that's it. You've created a Database and Assigned a User to administrate it.
From there, you'll need to scroll down towards the bottom of the page and locate this section.
After you've clicked on on MySQL Databases, you'll find the Database Administration tools. At the top of the page, you'll see
In the box, you can type in the database name you'll be using.
- For this example, we'll create a database called test. After you've typed test you should see a green check mark to show you that there are no other databases with the same name.
Click Submit
- On the next page, you will see the confirmation message
Where x equals the name of your cPanel login.
Click [Go Back]
- Now you are back at the page you just where before you created the database.
From here, you are going to need to create a user. This user will also be assigned to the database, with that in mind, you'll need to give this user various permissions in order to work in the phpMyAdmin Environment.
- Now, as we said, you should now be back at the page prior to creating your database, scroll towards the bottom and look for this.
This is where you will create a username and a password. When choosing a password, we recomend that you use the Generate Password feature. This will create a very unique and obscure password that will give you a higher level of protection versus on you may pick.
Once you've generated a password, or choose one yourself, click Create User
- On the next page, you will see the confirmation message stating the creation of the user.
Where x equals the password.
Click [Go Back]
- Now, back to the page where you created the database and created the user. Scroll down towards the bottom once more and look for
xxxx is where your cPanel login name should be. Click Add
- On the next page, you'll be given the options as to which permissions to give the user.
Since this is our first database, and we will be the only one's using it, we will assign it ALL PRIVILEGES
SELECT - Can draw results from database.
INSERT - Can insert information into the database.
UPDATE - Can adjust and update information in the database.
DELETE - Can delete information from the datbase.
INDEX - Can create or delete Indexes from the Database.
CREATE TEMPORARY TABLES - Can create temporary tables within the database.
CREAT - Can create tables and information in the database.
ALTER - Can alter or rename tables inside the database.
DROP - Can drop (delete) tables in the database.
LOCK TABLES - Can lock tables, restrict access and input of information.
REFRENCES - Has no purpose as of yet.
CREATE ROUTINE - Can create stored procedures and functions within the database.
Click Make Changes
You should now see
xxxx equals the name of your cPanel login.
Click [Go Back]
And that's it. You've created a Database and Assigned a User to administrate it.