The main idea of the blog is to share solutions for problems I faced before

Thursday, 13 February 2014

Weblogic Admin Server issues :

1) Problem 1: Today we got the below error while starting the Web logic Admin server.

We have deleted cache (tmp and logs) for the admin and managed servers.After that when we trying start the admin server we have faced following exception in log file.

<Feb 13, 2014 7:56:55 PM IST> <Notice> <Log Management> <BEA-170019> <The server log file /u02/Middleware/user_projects/domains/EPMSystem/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.>
Feb 13, 2014 7:57:00 PM oracle.security.jps.internal.credstore.ssp.CsfWalletManager openWallet
WARNING: Opening of wallet based credential store failed. Reason java.io.IOException
<Feb 13, 2014 7:57:00 PM IST> <Error> <Security> <BEA-090892> <The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException>
<Feb 13, 2014 7:57:00 PM IST> <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1402)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1022)
at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
at weblogic.security.SecurityService.start(SecurityService.java:141)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
Truncated. see log file for complete stacktrace
Caused By: oracle.security.jps.JpsRuntimeException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:170)
at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:383)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
Truncated. see log file for complete stacktrace
Caused By: oracle.security.jps.JpsException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
at oracle.security.jps.internal.policystore.PolicyUtil.getDefaultPDPService(PolicyUtil.java:2984)
at oracle.security.jps.internal.policystore.PolicyUtil.getPDPService(PolicyUtil.java:3228)
at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:167)
at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:383)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
Truncated. see log file for complete stacktrace
Caused By: oracle.security.jps.service.credstore.CredStoreException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
at oracle.security.jps.internal.credstore.ssp.CsfWalletManager.openWallet(CsfWalletManager.java:184)
at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.doInit(SspCredentialStore.java:359)
at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:176)
at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:160)
at oracle.security.jps.internal.credstore.ssp.SspCredentialStoreProvider.getInstance(SspCredentialStoreProvider.java:118)
Truncated. see log file for complete stacktrace
>
<Feb 13, 2014 7:57:00 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<Feb 13, 2014 7:57:00 PM IST> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>
<Feb 13, 2014 7:57:00 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

wallet based credential store failed. Reason java.io.IOException
tail: admin.log: file truncated
java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06)
Oracle JRockit(R) (build R28.2.5-50-153520-1.6.0_37-20121220-0843-linux-x86_64, compiled mode)

What we did :

1) firstly, we thought problem with credentials (boot.properties and ldap files). Deleted ldap file and have opened boot.properties file and deleted date line and modified username and password with same values. (before modification they were in encoding).

when we start same problem exists.

2) secondly, we have searched in Google with a key word wallet based credential store failed. Reason java.io.Io Exception.

and found some solutions.

Help full solution:

Here is the fix: We navigated to <Middleware_Home>/user_projects/domains/<Your Domain>/config/fmwconfig/ folder and observed that cwallet.sso is corrupted and file size is 0(zero) kb . Here we renamed this file(cwallet.sso_bkp) and successfully started Adminserver .

Friday, 13 December 2013

Hyperion EPM 11.1.2.3 Issues and solutions

Error while creating planning application through work space :

Hi,

I am getting the following error when i am trying to create the classic planning application through work space.

Invalid or could not find module configuration.

Required application module Hyperion Planning. App Wizard is not configured. Please contact your administrator.

Communication Error.
http://localhost:28080/Hyperion Planning/conf/HspJSConfig.xml?LOCALE_LANGUAGE=en

Please suggest me how to resolve this error. Also please share the order in which services to start.

What I did : Because it said no application module configured at that time two things came into my mind

1) Restarting all the services may help us.

2) do some manual planning application configuration and copy to that planning apps location restart all services.

Solution for this :

If you are going through work space and using Apache plugin (HTTP realted), you should access work space on port 19000.
http://<workspace machine>:19000/workspace/index.jsp

Ref : https://forums.oracle.com/thread/841482

2) After adding a machine name to the EAS console. we got an issue when we try to add Essbase server.

It is giving network configuration failed. could not connect to localhost:1423

What I did: As shown in some blogs i thought restarting of OPMN will give the solution.

Then I did it. It works for me.

3) Work space – Dimension library issue:

Today when we are trying to open Dimension library and Application library through workspace

We came across below issue:

Right Hostname could not be parsed.

Epm.web.dimensionlibrary exception.

Solution: When I am looking into the services status running or stopped, everything is running except EPMA process manager.

I restarted it and logout ,login workspace.

Now we are able to open dimension library. J

Sunday, 8 December 2013

Oracle Hyperion Enterprise Performance Management (EPM) System Component overview

This post is brief overview of Oracle Hyperion Enterprise Performance Management (EPM) System Products which consists of

1) Hyperion Foundation Services

1.1) EPM Shared Services - provides EPM System Products identity management, user provisioning, and task flow management.
1.2) EPM workspace – thin client interface to work with EPM content.
1.3) Performance Management Architect – enables creation and deployment of financial applications from central location.
1.4) Calculate Manager – module used by Planning, Essbase, and Financial Management users can use to design, validate and administer business rules.
1.5) Smart view for Office – microsoft office add-in for Hyperion System Products.

2) Essbase

2.1) Essbase – is business analysis software to develop custom analytics and enterprise performance management applications.
2.2) Essbase Administration Service – administration tool to manage Essbase deployed on application server.
2.3) Business Rules – installed and configured as part of Administration Services, is used to create, execute and manage business rules.
2.4) Integration Services – tool to create OLAP models, outlines and Essbase Database.
2.5 ) Provider Services – is middle tier data source provider for essbase, planning, and so on
2.6) Essbase Studio – consolidates cube-construction activities in one interface.

3) Hyperion Reporting and Analysis

3.1) Hyperion Interactive Reporting – intuitive user-directed query and analysis capabilities.
3.2) Hyperion Financial Reporting – book-quality financial and management reports that comply with regulations and external requirements.
3.3) Hyperion SQR production Reporting – high-volume, formatted reports coming form different sources
3.4) Hyperion Web Analysis – provides online analytical processing (OLAP) analysis.

4) Hyperion Financial Performance Management Application

4.1) Planning – is a centralized planning, budgeting, and forecasting solution that integrates financial and operational planning processes.
4.2) Financial Management – is financial systems software application that provides global collection reporting and analysis in single solution.
4.3) Financial Close Management – to define, execute, and report on interdependent activities of financial close period.
4.4) Performance Scorecard – is a balanced scorecard collaborative certified application to articulate strategy and goals, communicate them across enterprise and monitor KPI.
4.5) Hyperion Strategic Finance – is financial modelling application to identify and understand full financial impact of alternative corporate strategies.
4.6) Profitability and Cost Management – is an analytic application for managing cost and revenue allocation to compute profitability for business segment.
4.7) Disclosure Management – used to assemble a reporting package for submission to a regulatory agency.

5) Data Management

5.1) Hyperion Financial Data Quality Management (FDM) – helps finance users develop standardised financial data management processes.
5.2) ERP Integrator – Module of FDM, to integrate metadata and data from ERP source system to Hyperion EPM target application.
5.3) Hyperion Data Relationship Manager (DRM) - enables to build consistency within master data assets despite changes within the underlying transactional and analytical systems.

Oracle Hyperion Database Administrator

Oracle Hyperion EPM Installation and Administration : Part1

Oracle Hyperion Enterprise Performance Management (EPM) as name suggests is enterprise performance management software that provides planning, budgeting and forecasting solution.

Hyperion was acquired by Oracle in 2007 and consists of following components

Hyperion Foundation Services
Hyperion Essbase
Hyperion Reporting and Analysis
Oracle Hyperion Data Management
Hyperion Financial Performance Management Application that consists of

Hyperion Financial Close Management
Hyperion Financial Disclosure Management
Hyperion Financial Management – Fusion Edition
Hyperion Strategic Management – Fusion Edition
Hyperion Performance Scorecard – Fusion Edition
Hyperion Profitability and Cost Management – Fusion Edition

This post covers high level steps to install Oracle Hyperion EPM 11.1.1.2.1

Download Oracle Hyperion EPM Software from eDelivery (select product Oracle Enterprise Performance Management System)
Install Database for Hyperion (Database character set must be with UTF-8 encoding (AL32UTF8, UTF8, UTFE)
Install Java Development Kit (JDK or JRockit) 1.6 or higher
Install Hyperion EPM System Components using installTool.sh/bat (This will install WebLogic Server, Oracle HTTP Server, and EPM System)
Configure Hyperion EPM System Components using configTool.sh/bat ( This will create Weblogic Domain, configure OHS Server, System Component for EPM i.e. EPM ORACLE_INSTANCE and configure EPM applications)
Start Hyperion EPM System Components using EPM_ORACLE_INSTANCE /bin/start.sh
Validate/Access Hyperion EPM System Components

Monday, 28 October 2013

ExternalTables_OracleDirectory

Hi Folks,

I have a task to create an oracle directory and assign access privileges to the users. And create an external table; load the data through .CSV file.

So that I have a created a directory in oracle and assigned access privileges to the users as below:

General

Related Data Dictionary Objects

dir$	all_directories	ku$_directory_t
	dba_directories	ku$_directory_view

System Privileges

GRANT create any directory TO <user_name>;
GRANT drop any directory TO <user_name>;

GRANT create any directory TO uwclass;
GRANT drop any directory TO uwclass;

Create Directory

Create A Directory

CREATE OR REPLACE DIRECTORY <directory_name> AS '<operating_system_path>';

conn / as sysdba

desc dba_directories

set linesize 121
col owner format a15
col directory_name format a20
col directory_path format a70

SELECT *
FROM dba_directories;

CREATE OR REPLACE DIRECTORY ctemp AS 'c: emp';

SELECT *
FROM dba_directories;

Granting Privileges To A Directory

Grant Read On A Directory

GRANT READ ON DIRECTORY <directory_name> TO <schema_name>

col grantor format a20
col grantee format a20
col table_schema format a20
col table_name format a20
col privilege format a10

SELECT grantor, grantee, table_schema, table_name, privilege
FROM all_tab_privs
WHERE table_name = 'CTEMP';

GRANT READ ON DIRECTORY ctemp TO uwclass;

SELECT grantor, grantee, table_schema, table_name, privilege
FROM all_tab_privs
WHERE table_name = 'CTEMP';

Grant Write On A Directory

GRANT WRITE ON DIRECTORY <directory_name> TO <schema_name>

GRANT WRITE ON DIRECTORY ctemp TO uwclass;

SELECT grantor, grantee, table_schema, table_name, privilege
FROM all_tab_privs
WHERE table_name = 'CTEMP';

Revoke Read On A Directory

REVOKE READ ON DIRECTORY <directory_name> FROM <schema_name>

REVOKE READ ON DIRECTORY ctemp FROM uwclass;

Revoke Write On A Directory

REVOKE WRITE ON DIRECTORY <directory_name> FROM <schema_name>

REVOKE WRITE ON DIRECTORY ctemp FROM uwclass;

Drop Directory

Drop A Directory

DROP DIRECTORY <directory_name>;

SELECT *
FROM dba_directories;

DROP DIRECTORY ctemp;

SELECT *
FROM dba_directories;

Creating an External Table:

Create a directory object pointing to the location of the files.

CREATE OR REPLACE DIRECTORY test2 AS 'D:/test2';

EXAMPLE:

create table forecastforOct2013

(YYYYMM number(20),

YYYYMMDD number(20),

DAY_NUMBER varchar2(25),

ship_day number(20),

channel varchar2(25),

reporting_group varchar2(26),

item_type varchar2(25),

forecast_qty_lbs varchar2(26),

forecast_amt varchar2(25)

)

organization external

(

type oracle_loader

default directory test2

access parameters

(

records delimited by newline

badfile 'forecastforOct2013.bad'

discardfile 'forecastforOct2013.dsc'

logfile 'forecastforOct2013.log'

fields terminated by ','
optionally enclosed by '"'

missing field values are null

)

location ('forecastforOct2013.csv')

)
reject limit unlimited ;

1. Before executing this script we have created a directory called “test2” under D:/ folder and assigned read, wrote permissions to the oracle user .
2. Place the file (here: forecastforOct2013) in test2 directory.
3. Make sure that you have all the access permissions to the test2 directory and forecast... Files.

Monday, 5 August 2013

OC4J Configuration issue - Unable to openDBCONSOLE

[oracle@localhost ~]$ emctl status dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_localhost.localhost.com_fmw not found.
[oracle@localhost ~]$ emctl start dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_localhost.localhost.com_fmw not found.
This is due to a misconfiguration of dbconsole during database setup. The fastest solution is usually to recreate repository and configuration.
First, deconfigure dbconsole:
[oracle@localhost ~]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Aug 5, 2013 7:54:35 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: fmw
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 5, 2013 7:54:54 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/fmw/emca_2013_08_05_19_54_34.log.
Aug 5, 2013 7:54:55 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Aug 5, 2013 7:54:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 5, 2013 7:57:04 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 5, 2013 7:57:04 PM

Now, let's configure it again
[oracle@localhost ~]$ emca -config dbcontrol db -repos create
STARTED EMCA at Aug 5, 2013 7:58:22 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: fmw
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ localhost.localhost.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ fmw
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 5, 2013 7:58:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/fmw/emca_2013_08_05_19_58_21.log.
Aug 5, 2013 7:58:54 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 5, 2013 8:05:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 5, 2013 8:06:02 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 5, 2013 8:07:14 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 5, 2013 8:07:17 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 5, 2013 8:07:17 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 5, 2013 8:08:07 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 5, 2013 8:08:07 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 5, 2013 8:08:53 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 5, 2013 8:08:53 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 5, 2013 8:10:16 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 5, 2013 8:10:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://localhost.localhost.com:5500/em <<<<<<<<<<<
Aug 5, 2013 8:10:28 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/localhost.localhost.com_fmw/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager Configuration completed successfully
FINISHED EMCA at Aug 5, 2013 8:10:28 PM

[oracle@localhost ~]$

Wednesday, 5 June 2013

How To Install MySQL in Linux

Most of the Linux flavors comes with MySQL. If you want use MySQL, my recommendation is that you download the latest and stable version of MySQL and install it yourself. Later you can upgrade it to the latest version when it becomes available. In this post, I will discuss how I installed MySQL on Red hat or Oracle Linux platform.

1. Download the latest stable release of MySQL :

Download MySQL from mysql.com. Please download the community edition of MySQL for your appropriate Linux platform. I downloaded the “Red Hat Enterprise Linux 5 RPM (x86_64bit)”. Make sure to download MySQL Server, Client and “Headers and libraries” from the download page.

MySQL-client-5.5.32-1.rhel5.x86_64.rpm
MySQL-devel-5.5.32-1.rhel5.x86_64.rpm
MySQL-server-5.5.32-1.rhel5.x86_64.rpm

2. Remove the existing default MySQL that came with the Linux distribution.

Do not perform this on an system where the MySQL database is getting used by some application.

[local-host]# rpm -qa | grep -i mysql
mysql-5.0.22-2.1.0.1
mysqlclient10-3.23.58-4.RHEL5.4

[local-host]# rpm -e mysql --nodeps

No Mysql is running on the host.

3. Install the downloaded MySQL package

Install the MySQL Server and Client packages as shown below.

[local-host]# rpm -ivh MySQL-server-5.5.32-1.rhel5.x86_64.rpm MySQL-client-5.5.32-1.rhel5.x86_64.rpm



## if it will not work shows any message like below : use force option to install MYSQL-server :



# rpm -ivh --force  MySQL-server-5.6.16-1.el6.x86_64.rpm


file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.52-1.el6_0.1.x86_64
        file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.52-1.el6_0.1.x86_64
        file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.52-1.el6_0.1.x86_64
Preparing...   ########################################### [100%]
1:MySQL-client ########################################### [ 50%]
2:MySQL-server ########################################### [100%]
This will also display the following output and start the MySQL daemon automatically.
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h medica2 password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/

Starting MySQL.[  OK  ]
Giving mysqld 2 seconds to start
** If it is not get started automatically find below how to start 


Install the “Header and Libraries” that are part of the MySQL-devel packages.


[local-host]# rpm -ivh MySQL-devel-5.5.32-0.rhel5.x86_64.rpm
Preparing...   ########################################### [100%]
1:MySQL-devel  ########################################### [100%]

4.  Perform post-install security activities on MySQL.
At a bare minimum you should set a password for the root user as shown below:

[local-user]# /usr/bin/mysqladmin -u root password 'My2Secure$Password'
The best option is to run the mysql_secure_installation script that 
will take care of all the typical security related items on the MySQL as
 shown below. On a high level this does the following items:
Change the root password
Remove the anonymous user
Disallow root login from remote machines
Remove the default sample test database



5.  Verify the MySQL installation:
You can check the MySQL installed version by performing mysql -V as shown below:

[local-host]# mysql -V
mysql  Ver 14.14 Distrib 5.1.25-rc, for redhat-linux-gnu (i686) using readline 5.1
Connect to the MySQL database using the root user and make sure the connection is successfull.

[local-host]# mysql -u root -p  /** if it is not connect start service first **/
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.25-rc-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

Follows the steps below to stop and start MySQL
[local-host]# service mysql status
MySQL running (12588)                                      [  OK  ]
[local-host]# service mysql stop
Shutting down MySQL.                                       [  OK  ]
[local-host]# service mysql start
Starting MySQL.                                            [  OK  ]
Issues I faced: 
1) When you are not able to connect MySQL, start the mysql service first.
  #service mysql start.
2) When you are not able to connect from the remote host give the permission as     below.
   [local-host]# mysql -u root -p
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root@'%' IDENTIFIED BY 'PASSWORD' WITH    GRANT OPTION;
If you want to give a permission to connect Mysql to a perticular remote machine give that IP instead of '%'.
Here '%' represents all Remote Hosts.