This article explains how to configure MySQL and add user with necessary privileges for working with Intelligent Converters software.
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:
bind-address=YOUR-SERVER-IPline in [mysqld] section
mysql restarton Debian / Ubuntu Linux or
mysqld restarton RHEL / CentOS / Fedora Linux
$ 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
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