From:       To:      
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:

  1. edit my.cnf file so it contains bind-address=YOUR-SERVER-IP line in [mysqld] section
  2. save and close my.cnf file
  3. restart MySQL via mysql restart on Debian / Ubuntu Linux or mysqld restart on RHEL / CentOS / Fedora Linux
  4. 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:

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 more questions? Contact us

See also

Useful MySQL Queries
Tuning MySQL Performance
How to Backup and Restore MySQL Database