Migrating xampp from debian 7(x86) to Ubuntu 14.04 LTS 64bit

ciroreed · 11-20-2015, 03:32 PM

I guess the solution is compress with tar the whole dir (/opt/lampp), send tar file to the new server, then untar in the same dir and woila!

Im this in my local machine first, which is 64bit too.

problems, xampp version is x86:

soution found: https://shrinathsuccess.wordpress.co...r-your-system/

it works but mysql wont start. I think this is a permission issue.

where i can check mysql logs or .. solve this?

can i provide some info?

ciroreed · 11-20-2015, 04:02 PM

more info: in my local machine there is no 'mysql' user, so mysql service cant start. I think is that..

Code:

root@debian:/opt# cat lampp/var/mysql/debian.err 
2015-11-20 22:46:03 7177 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:46:04 7575 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:46:05 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:46:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:46:05 7936 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 22:46:05 7936 [ERROR] Aborting

2015-11-20 22:46:05 7936 [Note] Binlog end
2015-11-20 22:46:05 7936 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:46:05 7575 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:51:41 8100 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:51:41 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:51:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:51:41 8460 [Note] Plugin 'FEDERATED' is disabled.
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2015-11-20 22:51:41 8460 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-11-20 22:51:41 8460 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-20 22:51:41 8460 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2015-11-20 22:51:41 8460 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-11-20 22:51:41 8460 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-20 22:51:41 8460 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-20 22:51:41 8460 [Note] InnoDB: Completed initialization of buffer pool
2015-11-20 22:51:41 8460 [ERROR] InnoDB: /opt/lampp/var/mysql/ibdata1 can't be opened in read-write mode
2015-11-20 22:51:41 8460 [ERROR] InnoDB: The system tablespace must be writable!
2015-11-20 22:51:41 8460 [ERROR] Plugin 'InnoDB' init function returned error.
2015-11-20 22:51:41 8460 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-11-20 22:51:41 8460 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-11-20 22:51:41 8460 [ERROR] Aborting

2015-11-20 22:51:41 8460 [Note] Binlog end
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'partition'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'ARCHIVE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_METRICS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_TRX'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'BLACKHOLE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'MyISAM'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'MRG_MYISAM'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'CSV'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'MEMORY'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'sha256_password'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'mysql_old_password'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'mysql_native_password'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'binlog'
2015-11-20 22:51:41 8460 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:51:41 8100 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
root@debian:/opt# useradd mysql -g root
useradd: user 'mysql' already exists
root@debian:/opt# usermod mysql -g root
root@debian:/opt# lampp/lampp startmysql
XAMPP: Starting MySQL...ok.
root@debian:/opt# lampp/lampp stopmysql
XAMPP: Stopping MySQL...not running.
root@debian:/opt# cat lampp/var/mysql/debian.err 
2015-11-20 21:53:36 2609 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 21:53:36 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 21:53:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 21:53:36 2975 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 21:53:36 2975 [ERROR] Aborting

2015-11-20 21:53:36 2975 [Note] Binlog end
2015-11-20 21:53:36 2975 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 21:53:36 2609 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 21:55:37 3125 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 21:55:37 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 21:55:37 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 21:55:37 3487 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 21:55:37 3487 [ERROR] Aborting

2015-11-20 21:55:37 3487 [Note] Binlog end
2015-11-20 21:55:37 3487 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 21:55:37 3125 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 21:58:14 3682 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 21:58:14 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 21:58:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 21:58:14 4046 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 21:58:14 4046 [ERROR] Aborting

2015-11-20 21:58:14 4046 [Note] Binlog end
2015-11-20 21:58:14 4046 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 21:58:14 3682 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 21:58:22 4118 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 21:58:22 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 21:58:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 21:58:22 4483 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 21:58:22 4483 [ERROR] Aborting

2015-11-20 21:58:22 4483 [Note] Binlog end
2015-11-20 21:58:22 4483 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 21:58:22 4118 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:01:21 4578 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:01:21 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:01:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:01:21 4942 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 22:01:21 4942 [ERROR] Aborting

2015-11-20 22:01:21 4942 [Note] Binlog end
2015-11-20 22:01:21 4942 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:01:21 4578 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:15:47 5389 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:15:47 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:15:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:15:47 5749 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 22:15:47 5749 [ERROR] Aborting

2015-11-20 22:15:47 5749 [Note] Binlog end
2015-11-20 22:15:47 5749 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:15:47 5389 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:15:51 5823 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:15:51 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:15:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:15:51 6187 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 22:15:51 6187 [ERROR] Aborting

2015-11-20 22:15:51 6187 [Note] Binlog end
2015-11-20 22:15:51 6187 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:15:51 5823 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:45:58 6779 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:45:59 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:45:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:45:59 7139 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 22:45:59 7139 [ERROR] Aborting

2015-11-20 22:45:59 7139 [Note] Binlog end
2015-11-20 22:45:59 7139 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:45:59 6779 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:46:03 7177 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:46:03 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:46:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:46:03 7537 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 22:46:03 7537 [ERROR] Aborting

2015-11-20 22:46:03 7537 [Note] Binlog end
2015-11-20 22:46:03 7537 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:46:03 7177 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:46:04 7575 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:46:05 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:46:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:46:05 7936 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

2015-11-20 22:46:05 7936 [ERROR] Aborting

2015-11-20 22:46:05 7936 [Note] Binlog end
2015-11-20 22:46:05 7936 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:46:05 7575 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:51:41 8100 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:51:41 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:51:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:51:41 8460 [Note] Plugin 'FEDERATED' is disabled.
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2015-11-20 22:51:41 8460 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-11-20 22:51:41 8460 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-20 22:51:41 8460 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2015-11-20 22:51:41 8460 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-11-20 22:51:41 8460 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-20 22:51:41 8460 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-20 22:51:41 8460 [Note] InnoDB: Completed initialization of buffer pool
2015-11-20 22:51:41 8460 [ERROR] InnoDB: /opt/lampp/var/mysql/ibdata1 can't be opened in read-write mode
2015-11-20 22:51:41 8460 [ERROR] InnoDB: The system tablespace must be writable!
2015-11-20 22:51:41 8460 [ERROR] Plugin 'InnoDB' init function returned error.
2015-11-20 22:51:41 8460 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-11-20 22:51:41 8460 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-11-20 22:51:41 8460 [ERROR] Aborting

2015-11-20 22:51:41 8460 [Note] Binlog end
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'partition'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'ARCHIVE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_METRICS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_CMP'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'INNODB_TRX'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'BLACKHOLE'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'MyISAM'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'MRG_MYISAM'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'CSV'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'MEMORY'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'sha256_password'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'mysql_old_password'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'mysql_native_password'
2015-11-20 22:51:41 8460 [Note] Shutting down plugin 'binlog'
2015-11-20 22:51:41 8460 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:51:41 8100 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended
2015-11-20 22:53:34 8537 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2015-11-20 22:53:34 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-20 22:53:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-20 22:53:34 8898 [Note] Plugin 'FEDERATED' is disabled.
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2015-11-20 22:53:34 8898 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-11-20 22:53:34 8898 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-20 22:53:34 8898 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2015-11-20 22:53:34 8898 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-11-20 22:53:34 8898 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-20 22:53:34 8898 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-20 22:53:34 8898 [Note] InnoDB: Completed initialization of buffer pool
2015-11-20 22:53:34 8898 [ERROR] InnoDB: /opt/lampp/var/mysql/ibdata1 can't be opened in read-write mode
2015-11-20 22:53:34 8898 [ERROR] InnoDB: The system tablespace must be writable!
2015-11-20 22:53:34 8898 [ERROR] Plugin 'InnoDB' init function returned error.
2015-11-20 22:53:34 8898 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-11-20 22:53:34 8898 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-11-20 22:53:34 8898 [ERROR] Aborting

2015-11-20 22:53:34 8898 [Note] Binlog end
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'partition'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'ARCHIVE'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_METRICS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_CMP'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'INNODB_TRX'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'BLACKHOLE'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'MyISAM'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'MRG_MYISAM'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'CSV'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'MEMORY'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'sha256_password'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'mysql_old_password'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'mysql_native_password'
2015-11-20 22:53:34 8898 [Note] Shutting down plugin 'binlog'
2015-11-20 22:53:34 8898 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2015-11-20 22:53:34 8537 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian.pid ended

Habitual · 11-20-2015, 04:14 PM

How was mysql-server installed?

ciroreed · 11-21-2015, 03:17 AM

mysql was not installed since lampp does not need it.

ciroreed · 11-21-2015, 04:18 AM

I think this is solved. I'll try to post the steps to perform it. I was right when i said this problem remains in file permissions.

As you can see in the previous log mysql try to start but it cannot read needed directories.

in the previous instalation, the directory structure was created by xampp script which, i guess, create an user "mysql" and assign the correct permissions. So the only thing to do is create this user and then, assign the ownership and permissions to the correct directories.

So.. first we extract the tar.gz file in /opt dir

then we create mysql user.

mysql must own these directories:

sudo chown -R mysql lampp/mysql/
sudo chown -R mysql lampp/var/mysql/

Now mysql service is running

ciroreed · 11-21-2015, 04:19 AM

note that this is tested in my local machine which is not an Ubuntu. I have debian 8 64bits