MYSQL

SQL STANDS FOR STRUCTURED QUERY LANGUAGE

MySQL Logo 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.

Refer to the following link for more information about MySQL:

MySQL – The MySQL homepage.
MySQL and PHP tutorial – A good introduction to using the two Open Source technologies together.

To create a MySQL database:

1. Click on the MySQL databases button on the home page.
2. Enter the name of the database in the Db field.
3. Click on the Add Db button. The database will be added to the /var/lib/mysqlfolder.

You need to create at least one database user and grant that user permission to use the new database. Refer to Creating a MySQL user and Grant a user’s permissions to a MySQL database for more information.
Creating a MySQL Database

REMOVING A DATABASE

Removing a database will delete that database from its online location. Be sure that you have saved a copy of the database if you want to keep any of the information in the database. Removing a database will not remove any user’s but it will remove all user’s permissions to that database.

To remove a database:

1. Click on the MySQL databases button on the home page.
2. Click on the Delete button next to the specific database.

CREATING A MYSQL USER

You need to create a MySQL user before that user is able to use the database. This does not automatically allow the user to use a database – you need to grant that user permission to the specific database first. Refer to Grant a user’s permissions to a MySQL database for more information.

To create a MySQL user:

1. Click on the MySQL databases button on the home page.
2. Enter the user’s name in the UserName field and the user’s password in the Password field.
3. Click on the Add User button.
Creating a MySQL User

REMOVING A USER

Removing a user deletes that user – it removes all database permissions that the user has and does not allow that user access to any MySQL databases.

To remove a user:

1. Click on the MySQL databases button on the home page.
2. Click on the Delete button next to the specific user in the Users area.

GRANT A USER’S PERMISSIONS TO A MYSQL DATABASE

Once you have created a user to use a database you need to grant that user permission to use the database. If you have not yet created a user, refer to Creating a MySQL user for more information.

To grant user permissions to a MySQL database:

1. Click on the MySQL databases button on the home page.
2. Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.
3. 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.
Granting a user's permissions to a MySQL database

REMOVING A USER’S PERMISSIONS

A user will no longer be able to access a particular database when you have removed their permissions to that database.

To remove a user’s permissions:

1. Click on the MySQL databases button on the home page.
2. Click on the Delete button next to the specific user underneath the name of the database in the Databases area.
Removing a user's permissions from a MySQL Database

MANAGING MYSQL DATABASES

CPanel includes a web-based MySQL management tool called phpMyAdmin. This tool allows you to manage all aspects of your database structure and data. Refer to the phpMyAdmin documentation link, which is http://yourURL/3rdparty/phpMyAdmin/Documentation.html, if you need to know more about using phpMyAdmin.

To manage MySQL databases using phpMyAdmin:

1. Click on the MySQL databases button on the home page.
2. Click on the phpMyAdmin link at the base of the window. Refer to the phpMyAdmin documentation link, which is http://yourURL/3rdparty/phpMyAdmin/Documentation.html, if you need to know more about using phpMyAdmin.

ADDING HOST ACCESS

You can allow external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site. localhost stands for your own web server.

To add host access:

1. Click on the MySQL databases button on the home page.
2. Enter the domain name or IP number of the host that you wish to add in the Host field.
3. Click on the Add Host button.
Adding host access to a MySQL Database

REMOVING HOST ACCESS

Remove host access for a particular server when you no longer want that server to access your MySQL databases.

To remove host access:

1. Click on the MySQL databases button on the home page.
2. Click on the Delete button next to the web server that you want to remove.

Directory One will provide your company with a MySQL Services in Houston when you call them at 713-465-0051.

Talk to the Houston MySQL experts who are prepared to help your business succeed.