[CentOS-es] Cambiar ruta MySQL
José Xitumul
josexn en gmail.com
Mie Mar 8 17:14:31 UTC 2017
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
Más información sobre la lista de distribución CentOS-es