How To Check if MySQL Installtion

3 posts / 0 new
Last post
VE4HAZ
How To Check if MySQL Installtion

How do I check to see if MySQL server is properly installed? I get a "Database Problem" error asking me to check if MySQL is installed properly.

I have pasted the last 20+ lines of my myqsl.err file as well.

Thanks in advance for any help!

Harm - VE4HAZ

180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
180621 16:23:46 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
180621 16:23:46 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
180621 16:23:46 [Note] Reading of all Master_info entries succeded
180621 16:23:46 [Note] Added new Master_info '' to hash table
180621 16:23:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.34-MariaDB-0ubuntu0.16.04.1' socket: '/home/harm/.config/cqrlog/database/sock' port: 64000 Ubuntu 16.04
180621 16:51:30 [Note] /usr/sbin/mysqld: Normal shutdown
180621 16:51:30 [Note] InnoDB: FTS optimize thread exiting.
180621 16:51:30 [Note] InnoDB: Starting shutdown...
180621 16:51:31 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
180621 16:51:32 [Note] InnoDB: Shutdown completed; log sequence number 1600647
180621 16:51:32 [Note] /usr/sbin/mysqld: Shutdown complete

ok2cqr
ok2cqr's picture
Re: How To Check if MySQL Installtion

Open a terminal and run cqlog with --debug=1 parameter:

cqrlog --debug=1

There will be much more information what happened. I think mysqlclient libraries are not installed but without info about distribution, it's hart to help.

73 Petr

f5row
MySQL57 problem

system Linux Mint 18.3 cinnamon 64-bit
cinnamon 3.6.6
4.13.0-45-generic

All was ok before I update to cqrlog-2.3.0. Now the log shows the qso done before but when I want to log a new qso these messages appear :

"Database upgrade crashed with this error:
TMySQL57Connection : Error executing query: Duplicate column name 'rxfreq'

TMySQL57Connection : Error executing query: Unknown column 'prop_mode' in 'field list'. "

And when I want to close the program there is this message :

"Q : Field not found : "RxFreq".

Press OK to ignore and risk data corruption.
Press Abort to kill the program."

What can I do to do the repair the right way ?
73 from Normandy