8.2.3.1. Create a MySQL User

The first thing you must have is a user account on the MySQL server that you plan to use for your backing store. The user account information is stored in the configuration file.

The user account must have full privileges for the database named fabric. To create the user and grant the privileges needed, use the following statements:

CREATE USER 'fabric'@'localhost' IDENTIFIED BY 'secret';
GRANT ALL ON fabric.* TO 'fabric'@'localhost';

In the preceding example, substitute a password of your choice (replace 'secret'). Also, if you are going to run MySQL Fabric on a host other than where the backing store resides, substitute the 'localhost' for the host name.

MySQL Fabric uses the same user account, who must have all privileges on all databases, to access all MySQL Servers that it will manage. The user and password are defined in the configuration file as we shall see. To create this user and grant all the necessary privileges, execute the following command on all MySQL servers:

CREATE USER 'fabric'@'localhost' IDENTIFIED BY 'secret';
GRANT ALL ON *.* TO 'fabric'@'localhost';

In the preceding example, substitute a password of your choice (replace 'secret'). Also, if you are going to run MySQL Fabric on a host other than where the managed MySQL servers reside, substitute the 'localhost' for the Fabric's host name.


User Comments
Sign Up Login You must be logged in to post a comment.