Installation and Upgrade Guides › Directory Configuration Guide › MySQL Server › How to Set Up a MySQL Server › Assign Root User Privileges

Assign Root User Privileges

You can use the MySQL Command Line Client to create the user directory administrator's username and password. This step is required before you can connect the Policy Server to the user directory.

To create a root user and assign a password

1. Click Start, MySQL, MySQL Server 5.0, MySQL Command Line Client.

   The MySQL Command Line Client opens.

2. Run the following command:

   mysql> GRANT ALL ON Test.* to 'root'@'<m/c_IP>' IDENTIFIED BY '<password>'
   

   • m/c_IP

     Specifies the MySQL server IP address.

   • password

     Specifies the password for the root user.

   A root user is created, and a password is assigned.