Hi all - I'm tearing what's left of my hair out here.
I have a wampserver set up and can happily connect to a database when using the following in the config.properties file of jRDC (Mariadb 10.3.12 and java version 1.8.0_191)
and with
[CODE}#AdditionalJar: mariadb-java-client-2.4.0
[/CODE]
in main. As expected I get the correct response when runing localhost:17178/test in a browser and my b4a project can load tables perfectly.
I added a user with all priveleges
User - MyUserName, Host - % , Password - MyPassword, ALL PRIVILEGES, Grant -Yes
Changing nothing but
I get 'Error fetching connection' when trying the test.
In the jRDC log window I see 'java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'MyUserName@%'@'localhost' (using password: YES)'
Have I missed something in the jRDC settings that I need to tweak or is this purely something to do with how my database user is set up (I suspect it is but have no idea what I'm doing wrong)? Any help would be very much appreciated.
I have a wampserver set up and can happily connect to a database when using the following in the config.properties file of jRDC (Mariadb 10.3.12 and java version 1.8.0_191)
B4X:
DriverClass=org.mariadb.jdbc.Driver
JdbcUrl=jdbc:mariadb://localhost/STARDB?characterEncoding=utf8
User=root
Password=
and with
[CODE}#AdditionalJar: mariadb-java-client-2.4.0
[/CODE]
in main. As expected I get the correct response when runing localhost:17178/test in a browser and my b4a project can load tables perfectly.
I added a user with all priveleges
User - MyUserName, Host - % , Password - MyPassword, ALL PRIVILEGES, Grant -Yes
Changing nothing but
B4X:
User=MyUserName
Password=MyPassword
I get 'Error fetching connection' when trying the test.
In the jRDC log window I see 'java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'MyUserName@%'@'localhost' (using password: YES)'
Have I missed something in the jRDC settings that I need to tweak or is this purely something to do with how my database user is set up (I suspect it is but have no idea what I'm doing wrong)? Any help would be very much appreciated.
Last edited: