Hi,

As i have done configuration of multiple instance of mysql server on single machine (Centos6).Firstly i have installed Mysql on my machine and then similary configure second instance but stuck with some issue.As i am unable to start a second instance of mysql server due to some error.
And i have also checked the ownership and permission of mysql2 directory i.e second mysql instance directory.

Here is my configuration file i.e my2.cnf

[mysqld]
datadir=/var/lib/mysql2
socket=/var/lib/mysql2/mysql2.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
port = 3307
[mysqld_safe]
log-error=/var/log/mysqld2.log
pid-file=/var/run/mysql2/mysqld2.pid

ERROR:
[abc@station ~]# mysqld_safe --defaults-file=/etc/my2.cnf
160326 19:20:04 mysqld_safe Logging to '/var/log/mysqld2.log'.
160326 19:20:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql2
160326 19:20:04 mysqld_safe mysqld from pid file /var/run/mysql2/mysqld2.pid ended

LOGS:

160326 19:04:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql2
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
160326 19:04:08 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
160326 19:04:08 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
160326 19:04:08 InnoDB: Started; log sequence number 0 44233
160326 19:04:08 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql2/mysqld2.pid' (Errcode: 2)
160326 19:04:08 [ERROR] Can't start server: can't create PID file: No such file or directory
160326 19:04:08 mysqld_safe mysqld from pid file /var/run/mysql2/mysqld2.pid ended



Thank you

Read the "Question Guidelines" link in my posting signature. You need to provide details...saying "some issue" and "some error" tells us absolutely nothing...and you don't tell us what version of MySQL or CentOS...you mention 6, but not 6.xxxx???
Please use CODE tags to make things easier to read.
Does the directory structure exist? The file? What ARE the permissions on them? Owner? And are you trying to start things up as root?

The MySQL reference guide has instructions on how to run multiple instances:
http://dev.mysql.com/doc/refman/5.7/...e-servers.html