Silly question here but does the new user you are trying with exist on the database server and has access to the database you are trying to access? The error message appears to be attempting a connection with the user alices, this fails and then is attempting another connection with the root user. Can you post up the code or is it identical to the one provided in the link?
my code is exactly the same as the one provided in the link, and i'm using the mxj connector as an external library.
The problem is using the username "alice" and the password given in the example works, but if i try other username and password combination it doesn't work.
I'm not sure whether it's because the username and password is preconfigured into the mxj connector .jar file, because I do also have mySQL installed and set up on my computer but never added the user "alice" and it doesn't exist under my list of user.
I tried using "root" and empty password as well, and "root" with the password that I access the installed mySQL with but neither works.
I would look into the class MysqldResource because the function startDatabase appears to be using the username and password to return a connection.
I have found this mentioned in a document:
Starting with Connector/MXJ 5.0.6 you can use the initialize-user property to a connection string. If set to true, the default an- onymous and root users will be removed and the user/password combination from the connection URL will be used to create a new user. For example:
I saw that in the document too, but even though i've tried setting the initialize-user property to true, it still won't take the username and password i'm giving it and still returns the user initialization error...