MySQL Create User

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.

Does User Exist?

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.

Drop 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 the User

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';
Easily Import XML into MySQL.
Free 15-day Trial.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.