[SOLVED] mysql log shows [ERROR] messages

windstory · 11-14-2015, 10:58 PM

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.

berndbausch · 11-14-2015, 11:04 PM

What does Google say about this error?
Did you run mysql_upgrade to create the missing system table mysql.roles_mapping?

windstory · 11-14-2015, 11:42 PM

I'm googleing now, and the result of "mysql_upgrade" is here.

Quote:

[root@localhost ~]# mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

berndbausch · 11-15-2015, 12:11 AM

Quote:

Originally Posted by windstory

I'm googleing now, and the result of "mysql_upgrade" is here.

Permissions not set up correctly?
Or you need to run the upgrade under a different identity?

windstory · 11-15-2015, 12:26 AM

This error occurred.

Quote:

[root@localhost ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

windstory · 11-16-2015, 04:50 AM

Re-installed xampp and solved.