HyperConomy

HyperConomy

78.3k Downloads

MySQL connection failed

jonny42g opened this issue ยท 4 comments

commented

This means you have the wrong username or password in your config.yml for your MySQL database. Either that or the MySQL server is misconfigured.

commented

the pass user port db name is correct and how would the server be miss configured and if i revert to the v0.974.57 there are no problems using the config from v0.975.4
thank you for the help

commented

I've tested this again and MySQL is working properly. Do you have any other applications connecting to the database? And you're saying .974.57 is able to connect to MySQL using the same credentials that no longer work in the new build?

commented

found the solution to my problem in config i had to put ' on both side of username and database name

i sall in error.log
Access denied for user ''@'localhost'
and noticed there is no username there so i added the ' on both sides and then i got database null but username showed up so i was like why not give that ' as well bam no more error and my database works and my old shops are there and can connect to mysql

couldnt tell you why mine needs that maybe the database im connected to i did try 4 other servers with no problem just this one makes me use ' on both sides

sql:
use-mysql: true
log-sql-statements: true
mysql-connection:
username: '12345' <--------
port: 3306
password: mydbpass
host: localhost
database: '12345' <---------

i hope this can be of some help and i no longer have any errors at this time and wanna say thank you for this wonderful plugin