mysql startup issues

In this note, I will document all startup issues that i had with mysql. Downloaded mysql community edition rpm 5.5.23 server and client packages and installed the using rpm -ivh <package names>

i tried to start using commands with mysqld but there were issues.

login as root and start mysql as below:

service mysql start

it worked.

Some other commands;
1. create user 'pbiuser'@'localhost' identified by 'welcome1';
2. create database 'bankdb';
3. create database bankdb;
4. grant usage on *.* to pbiuser identified by 'welcome1';
5. grant all privileges on bankdb.* to pbiuser@localhost;