| This section shall guide you with the setting up of your MySQL database. SupportSuite requires a MySQL database to store its data. There are two ways in which you are create and setup your database to work with SupportSuite:
|
|
|
|
|
|
|
| Note: Setting up of MySQL database on web control panels like PLESK, CPanel, Ensim etc. are not covered in this manual. For information related to any control panels, please refer to their respective manuals. Setting up of database on such control panels can be more easier than the steps mentioned here in.
|
|
|
|
| Using phpMyAdmin Interface: phpMyAdmin is an open source web tool written in PHP intended to handle the administration of MySQL. You may find more information and download phpMyAdmin from http://www.phpmyadmin.net. This section shall explains the following:
|
|
|
| a)
| Creating a new database using phpMyAdmin
|
| b)
| Adding a database user using phpMyAdmin
|
|
|
|
| a) Creating a new database using phpMyAdmin: Login to phpMyAdmin using root access rights to create a new database (‘kayako_suite‘ as referred to in this manual). Once logged in, you shall find your MySQL options. One of the option suggest ‘Create new database‘ with a textbox and a ‘Create‘ button just below it. Add your preferred database name and click on Create.
|
|
|
|
|
|
|
| Once clicked on Create, phpMyAdmin shall create a new database for you.
|
|
|
|
|
|
|
| Congratulations! You now have successfully created a new database which we shall use for SupportSuite.
|
|
|
| b) Adding a database user using phpMyAdmin: If you wish to use the same login and password for SupportSuite, using which you initially connected to phpMyAdmin then you may skip this part, although we suggest you do not use root access information for your database.
|
|
|
Assuming you are yet logged into phpMyAdmin, click on the Home icon on the left bar to return to the index page – 
|
| Just under the MySQL options, you shall find an option titled ‘Privileges‘, click on it. Once clicked, it shall lead to the ‘User Overview‘ page wherein you shall find an option to ‘Add a new user‘.
|
|
|
|
|
|
|
| Click on the link and it shall lead you to a page wherein you can add your preferred database user. For Login Information:
|
|
|
| - Username: Choose the option ‘Use text field‘ and enter your preferred database login.
|
| - Host: You can choose ‘Any host‘ or ‘local‘. Usually it is localhost for most servers. Contact your Server Host or refer to the MySQL Documentation for more information.
|
| - Password: Choose as ‘Use text field‘ and enter your desired password in the text box besides it.
|
| - Re-type: Re-enter the same password which you entered in the text box for Password.
|
|
|
|
|
|
|
|
| Once done, leave the Global privileges blank and click on the ‘Go‘ button to add the desired user. Once clicked, MySQL shall confirm the creation of a new database user – ‘You have added a new user‘. We now need to assign ALL PRIVILEGES to this new user in the database we earlier created. To do this, please look for the ‘Database-specific privileges‘ which can be found on the very same page. In this section, select the database name, of the database we earlier created, from the drop down list right next to ‘Add privileges on the following database‘. Once selected, it shall lead to you ‘Edit Privileges‘ section for this specific user. Select ALL the options to grant ALL PRIVILEGES to this user on the database we created.
|
|
|
|
|
|
|
| Once done, click on Go to update database user privileges. Congratulations! You have successfully added a new user using phpMyAdmin.
|
|
|
| Using MySQL Command Line Interface: Login to your MySQL Command Line Interface using root access to create a new database and add a new database user.
|
|
|
| a) Login to MySQL: First, you need to login to the MySQL interface, once you login you should have something like the following output
|
|
|
> mysql -u ro
ot -p
Enter Password: [Enter your root password here]
|
|
|
| b) Create a new database and database user: Assuming the database name is ‘kayako_suite‘, user is ‘kayako_user‘, the host is ‘localhost‘ and the password is ‘support‘, enter the following commands:
|
|
|
mysql> create database kayako_suite;
Query OK, 1 row affected (0.02 sec)
|
|
|
mysql> GRANT ALL PRIVILEGES ON kayako_suite.* TO kayako_user@”%” IDENTIFIED BY ‘support’ WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
|
|
|
mysql> exit
Bye
>
|
|
|
| Congratulations! By executing the above mentioned commands, you have successfully created a new database, a new database user and granted the new user ALL PRIVILEGES to the created database.
|
|
|
|
