Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

Error: Can't connect to MySQL server

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
cazz
Posts: 13
Joined: Sun 24 Sep 2017 12:18 pm
Weather Station: ws-0101
Operating System: Windows 10

Error: Can't connect to MySQL server

Post by cazz »

I was thinking use MySQL on the latest version of Cumulus MX and I have done that one time before but it was sometime ago.
I run MySQL on another server but I have no problem to access the server remote because I use HeidiSQL to manager the MySQL server.
I have create a user and a database for Cumulus MX and I can login with HeidiSQL and create and edit table.

But when I add the info into Cumulus MX I just get
Error: Can't connect to MySQL server on '192.168.x.x' (10061): Authentication failed.
10061 mean it have no permission but it have that when I can create stable and that from HeidiSQL?
freddie
Posts: 2870
Joined: Wed 08 Jun 2011 11:19 am
Weather Station: Davis Vantage Pro 2 + Ecowitt
Operating System: GNU/Linux Ubuntu 24.04 LXC
Location: Alcaston, Shropshire, UK
Contact:

Re: Error: Can't connect to MySQL server

Post by freddie »

By default, user connections to mysql are localhost only. You need to permit connections from other hosts for the user that CumulusMX will be connecting as.
Freddie
Image
cazz
Posts: 13
Joined: Sun 24 Sep 2017 12:18 pm
Weather Station: ws-0101
Operating System: Windows 10

Re: Error: Can't connect to MySQL server

Post by cazz »

mm yes I know
I have bind the address in MySQL to 0.0.0.0 and I can access the MySQL from computer that run Cumulus MX.
Not sure what more I can do.
freddie
Posts: 2870
Joined: Wed 08 Jun 2011 11:19 am
Weather Station: Davis Vantage Pro 2 + Ecowitt
Operating System: GNU/Linux Ubuntu 24.04 LXC
Location: Alcaston, Shropshire, UK
Contact:

Re: Error: Can't connect to MySQL server

Post by freddie »

cazz wrote: Mon 04 Jan 2021 1:17 pmI have bind the address in MySQL to 0.0.0.0 and I can access the MySQL from computer that run Cumulus MX.
Are you accessing MySQL with the same database user that Cumulus MX uses?
Freddie
Image
cazz
Posts: 13
Joined: Sun 24 Sep 2017 12:18 pm
Weather Station: ws-0101
Operating System: Windows 10

Re: Error: Can't connect to MySQL server

Post by cazz »

yes
I have a username cumulus and a database with name cumulus.

I have no problem to access the database with the username and the password with HeidiSQL
/* Delimiter changed to ; */
/* Connecting to 192.168.x.x via MySQL (TCP/IP), username cumulus, using password: Yes ... */
SELECT CONNECTION_ID();
/* Characterset: utf8mb4 */
SHOW /*!50002 GLOBAL */ STATUS;
SELECT NOW();
SHOW VARIABLES;
/* Connected. Thread-ID: 1242 */
SHOW OPEN TABLES FROM cumulus WHERE `in_use`!=0;
USE `cumulus`;
/* Entering session "Unnamed-1" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='cumulus';
SHOW TABLE STATUS FROM `cumulus`;
SHOW FUNCTION STATUS WHERE `Db`='cumulus';
SHOW PROCEDURE STATUS WHERE `Db`='cumulus';
SHOW TRIGGERS FROM `cumulus`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='cumulus';
Post Reply