Configuring the mysql database – HP 3PAR StoreServ 7000 Storage User Manual

Page 38

Advertising
background image

6.

Make sure that Configure MySQL Server now is checked and then click Finish.

The MySQL Server Instance ConfigurationWizard appears.

NOTE:

When installing on a Red Hat Linux server where the MySQL server is running locally

on the same server, you must complete one of the following procedures:

Create a symbolic link using the following command:

ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock

Or, make the following change in the /etc/my.cnf file:

socket=/var/run/mysqld/mysqld.sock

and then restart the MySQL server.

Without one of these modifications, the sampleloop logs the following error:

2010-03-09 12:54:01: Could not connect to database: mysqlconnect/db

server: Can't connect to local MySQL server through

socket'/var/run/mysqld/mysqld.sock' (2)

Configuring the MySQL Database

Use the MySQL Server Instance ConfigurationWizard to configure the MySQL database as follows:
1.

In the MySQL Server Instance ConfigurationWizard, click Next to begin configuring the
database.

2.

Select Detailed Configuration and then click Next.

3.

Select Server Machine then click Next.

4.

Select Multifunctional Database then click Next.

5.

When prompted to select a drive for the warehousing data file, accept the default drive
and directory and click Next.

6.

Choose Decision Support (DSS)/OLAP and click Next.

7.

Confirm that Enable TCP/IP Networking is selected and that the Port Number is 3306 and
then click Next.

8.

Confirm that Standard Character Set is selected and then click Next.

9.

Confirm the following and then click Next:

Install As Windows Service is selected

the default Service Name is MySQL

the Launch the MySQL Server automatically checkbox is checked

10. Confirm that Modify Security Settings is selected, enter a root password, and then retype the

password to confirm.

CAUTION:

Be sure to record the password for later reference.

11. Make sure that Create An Anonymous Account is not selected and then click Next.
12. Click Execute.
13. When prompted, click Finish.

CAUTION:

System Reporter only supports and creates MyISAM tables. Conversion of these

tables to use any other type of storage engine is not supported.

38

Installation, Configuration, Update, and Removal

Advertising