| windstory |
11-14-2015 10:58 PM |
mysql log shows [ERROR] messages
I've installed xampp x64 v5.6.14-0 on Centos 7.1 x64.
When I open webpages, I got "MySQL Connect Error!!!" or 1045 error message.
1. The error parts of the contents of the MYSQL log is here;
Quote:
2015-11-14 17:59:35 2983 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/localhost.localdomain.pid ended
2015-11-14 17:59:38 3573 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
151114 17:59:38 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151114 17:59:38 [Note] InnoDB: The InnoDB memory heap is disabled
151114 17:59:38 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
151114 17:59:38 [Note] InnoDB: Memory barrier is not used
151114 17:59:38 [Note] InnoDB: Compressed tables use zlib 1.2.8
151114 17:59:38 [Note] InnoDB: Using CPU crc32 instructions
151114 17:59:38 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151114 17:59:38 [Note] InnoDB: Completed initialization of buffer pool
151114 17:59:38 [Note] InnoDB: Highest supported file format is Barracuda.
151114 17:59:38 [Note] InnoDB: 128 rollback segment(s) are active.
151114 17:59:38 [Note] InnoDB: Waiting for purge to start
151114 17:59:38 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1625766
151114 17:59:38 [Note] Server socket created on IP: '::'.
151114 17:59:38 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151114 17:59:38 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_ FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAX DB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU E_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZE RO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_ PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY',' NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTI ONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_B ACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
151114 17:59:38 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
151114 17:59:38 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
151114 17:59:38 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '10.0.17-MariaDB' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
|
2. my.cnf is here;
Code:
[client]
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
[mysqld]
user = mysql
port=3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
plugin_dir = /opt/lampp/lib/mysql/plugin/
server-id = 1
innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
innodb_buffer_pool_size = 16M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
!include /opt/lampp/mysql/my.cnf
Any helpful comments would be highly appreciated.
Thnaks in advance. |
