Missing database "disk"

Fabio Palladino

unread,

Apr 24, 2021, 8:31:23 AM4/24/21

to proxysql

Hi,

I don't know why but the database disk has disappeared and doing show tables I see the tables of the db stats.

admin (main)>show tables;

+--------------------------------------+

| tables |

+--------------------------------------+

| global_variables |

| stats_memory_metrics |

| stats_mysql_commands_counters |

| stats_mysql_connection_pool |

| stats_mysql_connection_pool_reset |

| stats_mysql_errors |

| stats_mysql_errors_reset |

| stats_mysql_free_connections |

| stats_mysql_global |

| stats_mysql_gtid_executed |

| stats_mysql_prepared_statements_info |

| stats_mysql_processlist |

| stats_mysql_query_digest |

| stats_mysql_query_digest_reset |

| stats_mysql_query_rules |

| stats_mysql_users |

| stats_proxysql_servers_checksums |

| stats_proxysql_servers_metrics |

| stats_proxysql_servers_status |

+--------------------------------------+

19 rows in set (0.00 sec)

admin (main)>show databases;

+-----+---------------+-------------------------------------+

| seq | name | file |

+-----+---------------+-------------------------------------+

| 0 | main | |

| 2 | monitor | |

| 3 | stats_history | /var/lib/proxysql/proxysql_stats.db |

+-----+---------------+-------------------------------------+

3 rows in set (0.00 sec)

Can someone help me?

Thanks in advance

René Cannaò

unread,

Apr 24, 2021, 9:28:24 AM4/24/21

to Fabio Palladino, proxysql

You are using a user with stats credentials instead of a user with admin credentials

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/c4ca834a-dd41-4f9c-a055-2b6917a3de81n%40googlegroups.com.

Fabio Palladino

unread,

Apr 24, 2021, 10:26:22 AM4/24/21

to René Cannaò, proxysql

I solved thanks

Reply all

Reply to author

Forward