Autor Tópico: MySQL 5.7 e Ubuntu Server 16.04.2  (Lida 339 vezes)

Offline rhmgh

  • Usuário Ubuntu
  • *
  • Mensagens: 19
    • Ver perfil
MySQL 5.7 e Ubuntu Server 16.04.2
« Online: 03 de Julho de 2017, 13:21 »
Pessoal,

Estou tentando instalar o mysql 5.7 no ubuntu server 16.04.2, com a base em uma partição separada, ou seja, o diretório /var/lib/mysql em um outra partição. Se eu instalo tudo na mesma partição, instala e funciona direitinho, mas ai que eu mudo o caminho da base, volta a gerar os erros.

Alguém já teve essa experiência e poderia me ajudar?

Código: [Selecionar]
root@ubuntu:~# mysqld --initialize
mysqld: Can't create directory '/sites/mysql/' (Errcode: 17 - File exists)
2017-07-03T16:14:08.876855Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-07-03T16:14:08.883416Z 0 [ERROR] Aborting

Código: [Selecionar]
root@ubuntu:~# mysql_install_db
2017-07-03 13:14:36 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2017-07-03 13:14:36 [ERROR]   The data directory needs to be specified.

Código: [Selecionar]
root@ubuntu:~# /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
 failed!
root@ubuntu:~# journalctl -xe
Jul 03 13:15:08 ubuntu systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Jul 03 13:15:08 ubuntu systemd[1]: Stopped MySQL Community Server.
-- Subject: A unidade mysql.service concluiu o desligamento
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service concluiu o desligamento.
Jul 03 13:15:08 ubuntu systemd[1]: Starting MySQL Community Server...
-- Subject: Unidade mysql.service sendo iniciado
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service está sendo iniciada.
Jul 03 13:15:08 ubuntu mysql-systemd-start[1365]: MySQL system database not found in /sites/mysql. Please run mysqld --initialize.
Jul 03 13:15:08 ubuntu systemd[1]: mysql.service: Control process exited, code=exited status=1
Jul 03 13:15:08 ubuntu systemd[1]: Failed to start MySQL Community Server.
-- Subject: A unidade mysql.service falhou
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.
Jul 03 13:15:08 ubuntu systemd[1]: mysql.service: Unit entered failed state.
Jul 03 13:15:08 ubuntu systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 03 13:15:08 ubuntu systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Jul 03 13:15:08 ubuntu systemd[1]: Stopped MySQL Community Server.
-- Subject: A unidade mysql.service concluiu o desligamento
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service concluiu o desligamento.
Jul 03 13:15:08 ubuntu systemd[1]: mysql.service: Start request repeated too quickly.
Jul 03 13:15:08 ubuntu systemd[1]: Failed to start MySQL Community Server.
-- Subject: A unidade mysql.service falhou
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.

Código: [Selecionar]
2017-07-03T15:53:14.845790Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-07-03T15:53:14.845919Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-07-03T15:53:15.321659Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-07-03T15:53:15.329563Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-0ubuntu0.16.04.1) starting as process 2434 ...
2017-07-03T15:53:15.381161Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-07-03T15:53:15.381258Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-07-03T15:53:15.381268Z 0 [Note] InnoDB: Uses event mutexes
2017-07-03T15:53:15.381276Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-07-03T15:53:15.381284Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-07-03T15:53:15.381291Z 0 [Note] InnoDB: Using Linux native AIO
2017-07-03T15:53:15.383264Z 0 [Note] InnoDB: Number of pools: 1
2017-07-03T15:53:15.384245Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-07-03T15:53:15.399310Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-07-03T15:53:15.453456Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-07-03T15:53:15.474248Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-07-03T15:53:15.535027Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-07-03T15:53:15.659145Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-07-03T15:53:15.659270Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-07-03T15:53:15.708608Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-07-03T15:53:15.711006Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-07-03T15:53:15.711068Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-07-03T15:53:15.715413Z 0 [Note] InnoDB: Waiting for purge to start
2017-07-03T15:53:15.765954Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2534985
2017-07-03T15:53:15.766972Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-07-03T15:53:15.768095Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-07-03T15:53:15.932996Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-07-03T15:53:15.933057Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-07-03T15:53:15.933168Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-07-03T15:53:15.933211Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-07-03T15:53:15.966439Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170703 12:53:15
2017-07-03T15:53:16.068796Z 0 [Note] Event Scheduler: Loaded 0 events
2017-07-03T15:53:16.069380Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2017-07-03T15:53:16.069398Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-07-03T15:53:16.069403Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-07-03T15:53:16.284256Z 0 [Note] End of list of non-natively partitioned tables
2017-07-03T15:53:16.933341Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-07-03T15:53:19.823793Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-07-03T15:53:19.823900Z 0 [Note] Shutting down slave threads
2017-07-03T15:53:19.823909Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-07-03T15:53:19.823919Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-07-03T15:53:19.824046Z 0 [Note] Binlog end
2017-07-03T15:53:19.836472Z 0 [Note] Shutting down plugin 'ngram'
2017-07-03T15:53:19.836539Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-07-03T15:53:19.836547Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-07-03T15:53:19.836554Z 0 [Note] Shutting down plugin 'partition'
2017-07-03T15:53:19.836560Z 0 [Note] Shutting down plugin 'MyISAM'
2017-07-03T15:53:19.836572Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-07-03T15:53:19.836578Z 0 [Note] Shutting down plugin 'CSV'
2017-07-03T15:53:19.836584Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-07-03T15:53:19.836640Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-07-03T15:53:19.836648Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-07-03T15:53:19.836657Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-07-03T15:53:19.836663Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-07-03T15:53:19.836668Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-07-03T15:53:19.836673Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-07-03T15:53:19.836677Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-07-03T15:53:19.836682Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-07-03T15:53:19.836687Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-07-03T15:53:19.836691Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-07-03T15:53:19.836696Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-07-03T15:53:19.836701Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-07-03T15:53:19.836705Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-07-03T15:53:19.836710Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-07-03T15:53:19.836720Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-07-03T15:53:19.836726Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-07-03T15:53:19.836731Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-07-03T15:53:19.836736Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-07-03T15:53:19.836741Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-07-03T15:53:19.836747Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-07-03T15:53:19.836752Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-07-03T15:53:19.836757Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-07-03T15:53:19.836762Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-07-03T15:53:19.836767Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-07-03T15:53:19.836812Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-07-03T15:53:19.836819Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-07-03T15:53:19.836824Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-07-03T15:53:19.836829Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-07-03T15:53:19.836837Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-07-03T15:53:19.836845Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-07-03T15:53:19.836850Z 0 [Note] Shutting down plugin 'InnoDB'
2017-07-03T15:53:19.837315Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-07-03T15:53:19.838339Z 0 [Note] InnoDB: Starting shutdown...
2017-07-03T15:53:19.938942Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-07-03T15:53:19.939398Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170703 12:53:19
2017-07-03T15:53:21.666179Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2640448
2017-07-03T15:53:21.668053Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-07-03T15:53:21.668077Z 0 [Note] Shutting down plugin 'MEMORY'
2017-07-03T15:53:21.668086Z 0 [Note] Shutting down plugin 'sha256_password'
2017-07-03T15:53:21.668091Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-07-03T15:53:21.668283Z 0 [Note] Shutting down plugin 'binlog'
2017-07-03T15:53:21.668942Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-07-03T15:53:21.927257Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-07-03T15:53:21.927427Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-07-03T15:53:22.412750Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-07-03T15:53:22.428178Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-0ubuntu0.16.04.1) starting as process 2522 ...
2017-07-03T15:53:22.452819Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-07-03T15:53:22.452889Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-07-03T15:53:22.452898Z 0 [Note] InnoDB: Uses event mutexes
2017-07-03T15:53:22.452905Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-07-03T15:53:22.452934Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-07-03T15:53:22.452944Z 0 [Note] InnoDB: Using Linux native AIO
2017-07-03T15:53:22.454856Z 0 [Note] InnoDB: Number of pools: 1
2017-07-03T15:53:22.455812Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-07-03T15:53:22.468863Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-07-03T15:53:22.513551Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-07-03T15:53:22.532354Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-07-03T15:53:22.558448Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-07-03T15:53:22.610131Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-07-03T15:53:22.610267Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-07-03T15:53:22.657454Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-07-03T15:53:22.659181Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-07-03T15:53:22.659261Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-07-03T15:53:22.661162Z 0 [Note] InnoDB: Waiting for purge to start
2017-07-03T15:53:22.711679Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2640448
2017-07-03T15:53:22.714556Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-07-03T15:53:22.718104Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-07-03T15:53:22.721812Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170703 12:53:22
2017-07-03T15:53:22.748531Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-07-03T15:53:22.748586Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-07-03T15:53:22.748601Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-07-03T15:53:22.748638Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-07-03T15:53:22.760162Z 0 [Note] Event Scheduler: Loaded 0 events
2017-07-03T15:53:22.760612Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2017-07-03T15:53:22.760626Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-07-03T15:53:22.760631Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-07-03T15:53:22.799249Z 0 [Note] End of list of non-natively partitioned tables
2017-07-03T15:53:22.960567Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-07-03T15:53:23.002860Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-07-03T15:53:35.818128Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-07-03T15:54:00.053309Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-07-03T15:54:00.053492Z 0 [Note] Shutting down slave threads
2017-07-03T15:54:00.053500Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-07-03T15:54:00.053520Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-07-03T15:54:00.059412Z 0 [Note] Binlog end
2017-07-03T15:54:00.062794Z 0 [Note] Shutting down plugin 'ngram'
2017-07-03T15:54:00.062831Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-07-03T15:54:00.062839Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-07-03T15:54:00.062853Z 0 [Note] Shutting down plugin 'partition'
2017-07-03T15:54:00.062861Z 0 [Note] Shutting down plugin 'MyISAM'
2017-07-03T15:54:00.062892Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-07-03T15:54:00.062900Z 0 [Note] Shutting down plugin 'CSV'
2017-07-03T15:54:00.062906Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-07-03T15:54:00.062969Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-07-03T15:54:00.062985Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-07-03T15:54:00.062992Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-07-03T15:54:00.062997Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-07-03T15:54:00.063002Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-07-03T15:54:00.063007Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-07-03T15:54:00.063012Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-07-03T15:54:00.063017Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-07-03T15:54:00.063022Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-07-03T15:54:00.063027Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-07-03T15:54:00.063032Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-07-03T15:54:00.063037Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-07-03T15:54:00.063042Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-07-03T15:54:00.063047Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-07-03T15:54:00.063052Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-07-03T15:54:00.063057Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-07-03T15:54:00.063062Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-07-03T15:54:00.063067Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-07-03T15:54:00.063072Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-07-03T15:54:00.063077Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-07-03T15:54:00.063082Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-07-03T15:54:00.063087Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-07-03T15:54:00.063092Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-07-03T15:54:00.063097Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-07-03T15:54:00.063102Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-07-03T15:54:00.063145Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-07-03T15:54:00.063152Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-07-03T15:54:00.063156Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-07-03T15:54:00.063161Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-07-03T15:54:00.063166Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-07-03T15:54:00.063170Z 0 [Note] Shutting down plugin 'InnoDB'
2017-07-03T15:54:00.063374Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-07-03T15:54:00.064518Z 0 [Note] InnoDB: Starting shutdown...
2017-07-03T15:54:00.165466Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-07-03T15:54:00.165940Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170703 12:54:00
2017-07-03T15:54:01.635962Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2640476
2017-07-03T15:54:01.638505Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-07-03T15:54:01.638534Z 0 [Note] Shutting down plugin 'MEMORY'
2017-07-03T15:54:01.638553Z 0 [Note] Shutting down plugin 'sha256_password'
2017-07-03T15:54:01.638560Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-07-03T15:54:01.638802Z 0 [Note] Shutting down plugin 'binlog'
2017-07-03T15:54:01.639611Z 0 [Note] /usr/sbin/mysqld: Shutdown complete


Desde já, agradeço a atenção!

Offline zekkerj

  • Usuário Ubuntu
  • *
  • Mensagens: 18.582
  • Gratidão gera gratidão, lamúria gera lamúria...
    • Ver perfil
Re:MySQL 5.7 e Ubuntu Server 16.04.2
« Resposta #1 Online: 03 de Julho de 2017, 13:54 »
Qual o sistema de arquivos que você está usando nessa partição separada?

Como você está fazendo a montagem? Quem é o proprietário da pasta que é o ponto de montagem?
Pesquise antes de perguntar, sua dúvida pode já ter sido respondida.
Não respondo dúvidas por MP, coloque sua dúvida no fórum onde ela pode ser pesquisada pelos seus colegas!
Não venha ao fórum apenas para perguntar. Se você sabe a resposta de um problema, porque não ajudar seu colega? ;D

Offline rhmgh

  • Usuário Ubuntu
  • *
  • Mensagens: 19
    • Ver perfil
Re:MySQL 5.7 e Ubuntu Server 16.04.2
« Resposta #2 Online: 03 de Julho de 2017, 14:48 »
Qual o sistema de arquivos que você está usando nessa partição separada?
ext4

Como você está fazendo a montagem?
no fstab
UUID=64179307-772b-4cac-8e33-5e22cf664d3b /sites          ext4    defaults        0       0

Quem é o proprietário da pasta que é o ponto de montagem?
o usuário mysql e as permissões está com 755


Offline rhmgh

  • Usuário Ubuntu
  • *
  • Mensagens: 19
    • Ver perfil
Re:MySQL 5.7 e Ubuntu Server 16.04.2
« Resposta #3 Online: 03 de Julho de 2017, 15:44 »
Consegui resolver, obrigado pela disponibilidade.

A solução que eu encontrei foi:

Editar o arquivo:
Código: [Selecionar]
vim /etc/apparmor.d/usr.sbin.mysqld
Na sessão:
# Allow data dir access
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,
  /sites/mysql/ r,                                   --- adicionado por mim
  /sites/mysql/** rwk,                         --- adicionado por mim

Usar o comando:
Código: [Selecionar]
mysqld --initialize
Depois foi só inicializar o mysql (ele iniciou sem erros), ai ele começou a criar os arquivos na outra partição.

Offline zekkerj

  • Usuário Ubuntu
  • *
  • Mensagens: 18.582
  • Gratidão gera gratidão, lamúria gera lamúria...
    • Ver perfil
Re:MySQL 5.7 e Ubuntu Server 16.04.2
« Resposta #4 Online: 03 de Julho de 2017, 17:52 »
Citar
/sites/mysql/
Isso me passou despercebido...
Pesquise antes de perguntar, sua dúvida pode já ter sido respondida.
Não respondo dúvidas por MP, coloque sua dúvida no fórum onde ela pode ser pesquisada pelos seus colegas!
Não venha ao fórum apenas para perguntar. Se você sabe a resposta de um problema, porque não ajudar seu colega? ;D