| |
|
|
| |
Database Management
==>
Creating My SQL Database or Postgres SQL |
|
| |
|
|
| |
Creating My SQL Database
? |
|
| |
|
|
| |
SQL stands
for Structured Query Language. SQL is an international
standard in querying and retrieving information from
databases. MySQL is essentially an SQL server - it responds
to requests for information that are written in SQL. You can
communicate with MySQL using a wide variety of programming
languages (PHP being one of the most common). MySQL is Open
Source software and free for use.
|
|
| |
|
|
| |
[1] |
Go to
www.yourdomain.com/cpanel [ example :www.techfreedomonline.com/cpanel] |
|
| |
|
|
|
| |
[2] |
You will be prompted for user name & password |
|
| |
|
|
|
| |
[3] |
Supply the
user name and password provided by Tech Freedom Online |
|
| |
|
|
|
| |
[4]
|
Click on
MySQL or Postgres SQL Databases menu |
|
| |
|
|
|
| |
[5]
|
Enter the
name of the database in the Db field. |
|
| |
|
|
|
| |
[6]
|
Click on the
Add Db button. The database will be added to the /var/lib/mysql
folder. |
|
| |
|
|
|
| |
|
Creating
a Database User |
|
| |
|
|
|
| |
[7]
|
Enter the
user's name in the Username field and the user's password in
the Password field. |
|
| |
|
|
|
| |
[8]
|
Click on the
Add User button |
|
| |
|
|
|
| |
|
Binding
User to Database |
|
| |
|
|
|
| |
|
Choose the
specific user from the User drop-down list and the specific
database to grant permissions to from the Db drop-down list.
Click on the Add User to Db button. The user now has
permission to use that database and sample connection
strings are shown in the MySQL window
|
|
| |
|
|
|
| |
 |
Database names will be prefixed with the
cPanel user name . For example : democp_data. where democp
is your cPanel user name and data is your database name
entered in the text box.
|
|
| |
|
|
|
| |
 |
Avoid using lengthy database names. |
|
| |
|
|
|
| |
 |
Make sure you create a user and bind the user
to the database. |
|
| |
|
|
|
| |
 |
You might not be able to access your database
if your connectivity is slower.
If your user name or password is wrong, you will not be able
to access your database.
If your account is suspended due to excess bandwidth usage
or server usage, your access will be suspended. |
|