I've just upgraded my OS from Slackware 14.1 to 14.2. After doing so, my jsp/tomcat programs can no longer connect to mysql. I get the error:
Quote:
Status 0, Communications link failure. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
I am running java 1.8.0_25, tomcat 8.5.11, tomcat-connector for mysql 1.2.40
current mysql version: 15.1 Distrib 10.0.29-MariaDB
previous mysql Ver 15.1 Distrib 5.5.40-MariaDB
my java driver string is "com.mysql.jdbc.Driver", and my connection string/URL is "jdbc:mysql://localhost/members?user=
user&password=
password"
I cannot telnet to port 3306.
I can do queries from the command line, no problem.
I have errors in /var/lib/mysql/
hostname.err (partial):
Code:
170216 9:52:02 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
170216 9:52:02 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
170216 9:52:02 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
170216 9:52:02 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
170216 9:52:02 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
170216 9:52:02 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
170216 9:52:02 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
170216 9:52:02 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
170216 9:52:02 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
170216 9:52:02 [Note] /usr/libexec/mysqld: ready for connections.
I've tried various suggestion I've found search the web, but none work.
Any ideas?