mysql on amazon linux - MySQL Daemon failed to start -
i tried restarting ec2 instance , sudo service httpd restart
.
but still message:
[ec2-user@ip-* ~]$ sudo service mysqld start mysql daemon failed start. starting mysqld: [failed]
also message:
[ec2-user@ip-* ~]$ mysqld 160127 7:01:48 [note] mysqld (mysqld 5.5.46) starting process 2745 ... 160127 7:01:48 [warning] can't create test file /var/lib/mysql/ip-*.lower-test 160127 7:01:48 [warning] can't create test file /var/lib/mysql/ip-*.lower-test 160127 7:01:48 [note] plugin 'federated' disabled. mysqld: can't find file: './mysql/plugin.frm' (errno: 13) 160127 7:01:48 [error] can't open mysql.plugin table. please run mysql_upgrade create it. 160127 7:01:48 innodb: innodb memory heap disabled 160127 7:01:48 innodb: mutexes , rw_locks use gcc atomic builtins 160127 7:01:48 innodb: compressed tables use zlib 1.2.8 160127 7:01:48 innodb: using linux native aio 160127 7:01:48 innodb: initializing buffer pool, size = 128.0m 160127 7:01:48 innodb: completed initialization of buffer pool 160127 7:01:48 innodb: operating system error number 13 in file operation. innodb: error means mysqld not have access rights innodb: directory. innodb: file name ./ibdata1 innodb: file operation call: 'open'. innodb: cannot continue operation.
i don't know should do..
cheers!
edit
(+ i'm using amazon rds.)
now, tried sudo chown -r mysql:mysql /var/lib/mysql
too.
but
[ec2-user@ip-* ~]$ mysql_upgrade looking 'mysql' as: mysql looking 'mysqlcheck' as: mysqlcheck fatal error: upgrade failed [ec2-user@ip-* ~]$ ls -lh /var/lib/mysql/ 합계 29m -rw-rw---- 1 mysql mysql 5.0m 1월 27 06:52 ib_logfile0 -rw-rw---- 1 mysql mysql 5.0m 1월 27 06:12 ib_logfile1 -rw-rw---- 1 mysql mysql 18m 1월 27 06:52 ibdata1 drwx------ 2 mysql mysql 4.0k 1월 20 07:03 mysql drwx------ 2 mysql mysql 4.0k 1월 20 07:03 performance_schema drwx------ 2 mysql mysql 4.0k 1월 20 07:03 test
i answer myself question other people in same problem.
i resolved problem these steps:
- restart ec2 instance.
- type
sudo service httpd restart
. (i don't know why should these 2 steps.) - type
sudo chown -r mysql:mysql /var/lib/mysql
. - before typing command, checkuser=
option in/etc/my.cnf
. if there nouser=
option,user
"mysql". (visit https://stackoverflow.com/a/21435052/1570534) - change
innodb_buffer_pool_size
option inside/etc/my.cnf
128 (can different)
500m
. if don't haveinnodb_buffer_pool_size
option in/etc/my.cnf
, addinnodb_buffer_pool_size=500m
in [mysqld] section.
i hope helps you!
Comments
Post a Comment