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';
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.