Help for using Mysql Server with Novacura

Flow Classic
1

Hi Gurus,

I need your help for the below.

I’m planning to install Mysql Server version DB in my laptop and then use Novacura connector to connect the DB.
Will it be possible for server version DB. I saw Novacura has a dedicated connector for MySqlServer

2

Hi,

What is your question Bhaski? What versions of MySql the connector supports? If you can install MySQL on your laptop?

Please rephrase your question and I will do my best to give you an answer. :slight_smile:

Br

3

In theory, you can use the Database connector and use the Database Type of “MySQL Server” to connect to your local install of MySQL if and only if the location of the Novacura Server can reach your laptop. The Database Server should be laptopIP:3306 if you use the defaults when you install it. For the database that you setup, be sure to open up port 3306 on your laptop firewall. Also, the MYSQL_ROOT_HOST will need to change from the default of “localhost” to “%” to enable the ability for “outside” computers to be able to connect. If you don’t want to do this for the root user (which you shouldn’t), you can do this when you create your dedicated Novacura user, which follows the syntax of:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL ON database.* TO 'username'@'localhost';
GRANT ALL ON database.* TO 'username'@'%';
4

Hi Daniel,

Many thanks.It really helps.