Enabling Database Access from External DB Tools

Overview

You want to connect to your database to retrieve data directly using an external tool(such as HeidiSQL or DBeaver) to export or review the data directly for reporting. You have attempted to connect unsuccessfully and received the error, "Access denied for user 'root'@'localhost' (using password: YES)" when attempting login.

Enabling this access will be required for Reviewing the Xinet Database Schema in an external tool.

Prerequisites

Direct Terminal or SSH access to the Xinet Server

Solution

For security reasons, the integrated MySQL database used by Xinet is not configured by default with a user that has the necessary privileges for connections from outside sources. Using the MySQL console, you can create a user with the necessary privileges.

1. Change to the Mysql directory:
   1. UNIX Systems:
      # cd /usr/etc/venture/bin
   2. Windows Systems:
      > cd \Program Files\Xinet\Venture\bin
2. Connect to MySQL console and enter your password when prompted:
   1. UNIX Systems:
      # ./mysql -u root -p
   2. Windows Systems:
      > mysql -u root -p
   3. Note: The default MySQL root password is 'xinetrlz'
3. Create a new MySQL user with the necessary privileges
   1. Run the following command, adjusting the values for your desired user details:
      mysql> GRANT ALL PRIVILEGES ON webnative.* TO <USERNAME>@<IPADDRESS> IDENTIFIED by '<PASSWORD>';
      1. For Example:
         mysql> GRANT ALL PRIVILEGES ON webnative.* TO jsmith@192.168.1.1 IDENTIFIED by 'xinet';
         1. This would create a user called "jsmith" who could connect to a remote host ONLY from the host at 192.168.1.1 using the password 'xinet.'
   2. USERNAME is the name of the new user.
   3. IPADDRESS is the IP address that you will be connecting to the remote server from.
      1. To allow access from anywhere (less secure), use "%" in place of the IP address.
   4. PASSWORD is the password you wish to assign to the user.