4 creating mysql users and schema, Creating mysql users and schema – HP 3PAR System Reporter Software User Manual
Page 56
3.20
Installing the Database Server
3PAR System Reporter User’s Guide
System Reporter 2.8
/etc/init.d/mysqld restart
3.8.2.4 Creating MySQL Users and Schema
If you are using MySQL, after installing and configuring MySQL you must create the MySQL
users and schema as described in this section.
1
Log in to MySQL as root. You may need to do this on the machine on which MySQL is
installed since root login is typically restricted to local logins only.
mysql -u root -p
2
Run the following command at the mysql prompt to create the database (named
inservstats by default):
create database inservstats;
3
Run the following commands to create the two users cliuser and webuser.
create user cliuser identified by ’cliuserpassword’;
create user webuser identified by ’webuserpassword’;
These users have different privilege levels that correspond with optional Apache HTTP Server
privilege levels, as described in
3.9 Installing or Upgrading the System Reporter Tools
■
cliuser is the default user name for the sampler and policy change user. This user can
create and edit database tables and change database sampling policies (see
■
webuser is the default user name for the Web reports user. This user has database read
privileges only.
CAUTION: It is necessary to use a large max_allowed_packet length because,
when sampling a large number of systems or very large systems, the SQL INSERT
command length can be quite large and the max_allowed_packet must be large
enough to hold the entire statement. If the max_allowed_packet is not large
enough, the sampler will get an error and sampling will stop.