After I deploy my report to hosting server, it can't access mysql 5.1.24
SQL error #1: Access denied for user 'scott'@'localhost' (using password: YES)
;
java.sql.SQLException: Access denied for user 'scott'@'localhost' (using password: YES)
Data source in my report:
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="6">
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://127.0.0.1:3306/mytest</property>
<property name="odaUser">scott</property>
<property name="odaPassword" >xxxxx</property>
</oda-data-source>
</data-sources>
In mysql on hosting server I can connet to mytest as scott:
mysql mytest -u scott -pxxxx -h 127.0.0.1 -P 3306
DB was created by following script:
create database mytest default character set utf8 collate utf8_general_ci;
grant all on mytest.* to 'scott'@'%' identified by 'xxxx';
grant all on mytest.* to 'scott'@'localhost' identified by 'xxxx';
Boris
