Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » BIRT report for MYSQL database(Connection to mysql database is not allowed)
BIRT report for MYSQL database [message #933942] Fri, 05 October 2012 13:36 Go to next message
Dejan Vujanic is currently offline Dejan VujanicFriend
Messages: 67
Registered: October 2011

I created BIRT report and it works fine on my lap-top.
MySQL database by default does not allow remote connection to it so my report could not be run on the server.
I also wasn't able to make connection from Eclipse to MySQL database because of that remote connection so I changed /etc/mysql/my.cnf configuration file. (

MYSQL sever is on example on address and my IP address is on example

I just commented line bind address:

port = 3306
socket = /var/run/mysqld/mysqld.sock

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
socket = /var/run/mysqld/mysqld.sock
nice = 0

user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address =

And also did:
GRANT ALL ON *.* TO root@'' IDENTIFIED BY 'my_password';

BIRT report is imported on server But it can be run by anyone.
How can I made this report available for everyone to run it?
Does anyone created reports for MYSQL (this is my first one) and had similar problems because of MYSQL does not allow remote connection?

Thank you

[Updated on: Fri, 05 October 2012 13:44]

Report message to a moderator

Re: BIRT report for MYSQL database [message #934184 is a reply to message #933942] Fri, 05 October 2012 18:36 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Have you looked at these threads?

Previous Topic:how to change this prompt for each supported language - birt.viewer.progressbar.prompt
Next Topic:How to import BIRT report on Sugar CRM?
Goto Forum:

Current Time: Wed Feb 01 13:56:39 GMT 2023

Powered by FUDForum. Page generated in 0.04134 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top