Before using ExultMySQL to import XML into MySQL, you need to create a user who can login to MySQL and import the XML. Here is how you can do it.

You need root access to be able to create a user.

Before creating a user, you need to check if a user with that name already exists. Else you will have an error while creating the user. You can check if a user exists with the following SQL. For example, assume you are checking if a user called joeschmoe exists in the database:

use mysql;
select count(*) from user where user = 'joeschmoe';

The above query returns 0 if the user does not exist. If so, you can proceed with creating the user.

If the user already exists and you want to drop the user, use the following SQL:

drop user 'joeschmoe'@'localhost';

Note that you must specify the hostname (or IP) when referring to the user. In the above example, the user referred to is joeschmoe on the localhost. To drop a remote user logging in from a machine called remotehost, use the following:

drop user 'joeschmoe'@'remotehost';

Create a user called joeschmoe on the localhost with a (clear-text) password of secretpassword and give access to a database called testdatabase:

create user 'joeschmoe'@'localhost' identified by 'secretpassword';
grant all on testdatabase.* to 'joeschmoe'@'localhost';

To allow access from a different host called remotehost (hostname or IP address), use the following:

create user 'joeschmoe'@'remotehost' identified by 'secretpassword';
grant all on testdatabase.* to 'joeschmoe'@'remotehost';