1.2. Using Ambari with MySQL

To set up MySQL for use with Ambari:

On the Ambari Server host, install the connector.
1. Install the connector
  RHEL/CentOS/Oracle Linux
```
yum install mysql-connector-java
```
  SLES
```
zypper install mysql-connector-java
```
2. Confirm that .jar is in the Java share directory.
```
ls /usr/share/java/mysql-connector-java.jar
```
3. Make sure the .jar file has the appropriate permissions - 644.

Create a user for Ambari and grant it permissions.

Using the MySQL database admin utility:

# mysql -u root -p
CREATE USER '$AMBARIUSER'@'%' IDENTIFIED BY '$AMBARIPASSWORD';
GRANT ALL PRIVILEGES ON *.* TO '$AMBARIUSER'@'%'; 
CREATE USER '$AMBARIUSER'@'localhost' IDENTIFIED BY '$AMBARIPASSWORD';
GRANT ALL PRIVILEGES ON *.* TO '$AMBARIUSER'@'localhost';
CREATE USER'$AMBARIUSER'@'$AMBARISERVERFQDN' IDENTIFIED BY '$AMBARIPASSWORD';
GRANT ALL PRIVILEGES ON *.* TO '$AMBARIUSER'@'$AMBARISERVERFQDN';
FLUSH PRIVILEGES;

Where $AMBARIUSER is the Ambari user name, $AMBARIPASSWORD is the Ambari user password and $AMBARISERVERFQDN is the Fully Qualified Domain Name of the Ambari Server host.

Load the Ambari Server database schema.
- You must pre-load the Ambari database schema into your MySQL database using the schema script.
```
mysql -u $AMBARIUSER -p
CREATE DATABASE $AMBARIDATABASE;
USE $AMBARIDATABASE;
SOURCE Ambari-DDL-MySQL-CREATE.sql;
```
- Where $AMBARIUSER is the Ambari user name and $AMBARIDATABASE is the Ambari database name.
  Find the Ambari-DDL-MySQL-CREATE.sql file in the /var/lib/ambari-server/resources/ directory of the Ambari Server host after you have installed Ambari Server.
When setting up the Ambari Server, select Advanced Database Configuration > Option [3] MySQL and enter the credentials you defined in Step 2. for user name, password and database name.

Legal notices