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:

  1. restart ec2 instance.
  2. type sudo service httpd restart. (i don't know why should these 2 steps.)
  3. type sudo chown -r mysql:mysql /var/lib/mysql. - before typing command, check user= option in /etc/my.cnf. if there no user= option, user "mysql". (visit https://stackoverflow.com/a/21435052/1570534)
  4. change innodb_buffer_pool_size option inside /etc/my.cnf 128 (can different) 500m. if don't have innodb_buffer_pool_size option in /etc/my.cnf, add innodb_buffer_pool_size=500m in [mysqld] section.

i hope helps you!


Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

javascript - Get parameter of GET request -