[CentOS-es] Cambiar ruta MySQL

[José Roberto Alas]

2017-03-08 11:14 GMT-06:00 José Xitumul <josexn en 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


-- 
Saludos,
cheperobert