Host OS : Debian / BOSS
Guest OS : CentOS
Application running in CentsOS. We tried to replicate the same in Debian/BOSS but wouldn't because some missing packages. so decided to go with Virtual Machine concept.
When we boot the CentOS from Debian/BOSS, MySQL Failed to start.
As we followed my error.log we managed to start the MySQL.
1) Network Adapter settings in your VM settings to be bridged mode
2) Change bind address in
/etc/mysql/my.cnf
to 0.0.0.0
bind-address = 0.0.0.0
3) gone through the log file (img),
MySQL error log running on VM |
got few error which was related to permission denied.
- Error 1)
/usr/libexec/mysqld: File '/var/lib/mysql/log-bin.index'
not found (Errcode: 13)
130930 15:27:22 [ERROR] Aborting
Solution
root@boss[~]# chmod -R 777 /var/lib/mysql/log-bin.index
- Error 2)
innoDB : Operating Systems error number 13 in a file operation. the Error means mysqld doesn't have the access rights to the directory
File name ./ibdata
File operation call : 'open'
Cannot continue operation
Solution
root@boss[~]# chomd -R 777 `locate ibdata`
- Error 3)
[ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
[ERROR] Can't start server : can't create PID file: Persmission denied
Solution
root@boss[~]# chmod -R 777 /var/run/mysqld/mysqld.pid
root@boss[~]# /etc/init.d/mysql start
now MySQL started successfully
1 comment:
helped in some point to resolve the issue.
Post a Comment