Page 1 of 1
Error: Can't connect to MySQL server
Posted: Mon 04 Jan 2021 8:41 am
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?
Re: Error: Can't connect to MySQL server
Posted: Mon 04 Jan 2021 9:31 am
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.
Re: Error: Can't connect to MySQL server
Posted: Mon 04 Jan 2021 1:17 pm
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.
Re: Error: Can't connect to MySQL server
Posted: Mon 04 Jan 2021 4:42 pm
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?
Re: Error: Can't connect to MySQL server
Posted: Mon 04 Jan 2021 5:18 pm
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';