Home > Workload Solutions > Oracle > Guides > Design Guide — MySQL InnoDB Cluster on Dell EMC PowerStore T > Installation and configuration
Host name |
IP address |
MySQL port |
Prod1 |
10.230.X.X |
3306 |
Prod2 |
10.230.X.X |
3306 |
Prod3 |
10.230.X.X |
3306 |
Note: Choose a unique password for your cluster.
mysql> SET sql_log_bin = OFF;
mysql> CREATE USER 'prod_clu'@'10.230.x.x' IDENTIFIED BY 'XXXX';
mysql> GRANT SELECT, RELOAD, SHUTDOWN, PROCESS, FILE, SUPER, REPLICATION SLAVE, REPLICATION CLIENT, CREATE USER ON *.* TO 'radmin'@'10.230.X.X' WITH GRANT OPTION;
mysql> GRANT INSERT, UPDATE, DELETE ON `mysql`.* TO 'radmin'@'10.230.X.X' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON `mysql_innodb_cluster_metadata`.* TO 'radmin'@'10.230.X.X' WITH GRANT OPTION;
mysql> SET sql_log_bin = ON;