Asegurate que el camino /data/mysql/ tiene el mismo SELinux contexto que /var/lib/mysql

chcon -R --reference /var/lib/mysql /data/mysql/ Nota: el comando anterior lo saque de la memoria, quizas "reference" no es la opcion correcta, revisa el manual del comando "chcon"

curoger

From: José Xitumul josexn@gmail.com To: CentOS-es@centos.org Sent: Wednesday, March 8, 2017 12:52 PM Subject: [CentOS-es] Cambiar ruta MySQL

Buen dia compañeros con un favor, estoy configurando mysql en otra partición pero me da el siguiente error la partición se llama /data

170308 11:11:43 mysqld_safe Logging to '/var/log/mysqld.log'. 170308 11:11:43 mysqld_safe Starting mysqld daemon with databases from /data/mysql/ 2017-03-08 11:11:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-08 11:11:43 0 [Warning] Can't create test file /data/mysql/MySQL.lower-test 2017-03-08 11:11:43 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 12768 ... 2017-03-08 11:11:43 12768 [Warning] Can't create test file /data/mysql/MySQL.lower-test 2017-03-08 11:11:43 12768 [Warning] Can't create test file /data/mysql/MySQL.lower-test 2017-03-08 11:11:43 12768 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2017-03-08 11:11:43 12768 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2017-03-08 11:11:43 12768 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied) 2017-03-08 11:11:43 12768 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

ya le di permisos con el usuario mysql drwxr-xr-x. 5 mysql root 144 mar  8 09:38 mysql

Pero no me funciona, si alguien pudiera ayudarme se lo agradezco, gracias de antemano _______________________________________________ CentOS-es mailing list CentOS-es@centos.org https://lists.centos.org/mailman/listinfo/centos-es

2017-03-08 11:14 GMT-06:00 José Xitumul josexn@gmail.com:

Buen dia compañeros con un favor, estoy configurando mysql en otra partición pero me da el siguiente error la partición se llama /data

170308 11:11:43 mysqld_safe Logging to '/var/log/mysqld.log'. 170308 11:11:43 mysqld_safe Starting mysqld daemon with databases from /data/mysql/ 2017-03-08 11:11:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-08 11:11:43 0 [Warning] Can't create test file /data/mysql/MySQL.lower-test 2017-03-08 11:11:43 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 12768 ... 2017-03-08 11:11:43 12768 [Warning] Can't create test file /data/mysql/MySQL.lower-test 2017-03-08 11:11:43 12768 [Warning] Can't create test file /data/mysql/MySQL.lower-test 2017-03-08 11:11:43 12768 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2017-03-08 11:11:43 12768 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2017-03-08 11:11:43 12768 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied) 2017-03-08 11:11:43 12768 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

Aca esta el error, esto te puede servir https://bbs.archlinux.org/viewtopic.php?id=137365