Home > Documentation > MySQL

Configuring MySQL for Intelligent Converters

This article explains how to configure MySQL and add user with necessary privileges for working with Intelligent Converters software.

Step 1. Enable remote access to MySQL.

If you have cPanel on server navigate to Databases section of the home screen, click Remote MySQL and enter domain name or IP address in Host text box.

If there is SSH access to MySQL server, login as root user and follow these steps:

edit my.cnf file so it contains bind-address=YOUR-SERVER-IP line in [mysqld] section
save and close my.cnf file
restart MySQL via mysql restart on Debian / Ubuntu Linux or mysqld restart on RHEL / CentOS / Fedora Linux
grant access to remote IP address:

$ mysql -u root -p mysql
mysql> GRANT ALL ON database_name.* TO user_name@'ip_address' IDENTIFIED BY 'password';

To test that remote coeection is allowed, type the following command from remote machine:

$ mysql -u user_name -h ip_address -p

Step 2. Grant necessary privileges to MySQL user.

On the phpMyAdmin default page click on the Privileges link and then:

Click on Add a new User link
Assign login and password
Set Database for User to None
Do not select anything in global privileges unchecked
Press the Go button

New user must appear in the User overview. Click on the edit icon next to the User's account. Under Database-specific privileges chose the database to work with Intelligent Converters software. Assign all privileges for that database to the user and press the Go button.

Have questions? Contact us