Page 1 of 1
unable to connect to MySQL database
Posted: 24 Apr 2019, 21:38
by KB3TOX
I am running Log4OM ver 1.36.0.0 and MySQL ver 8.0
When I attempt to create a MySQL database ....... using \settings\database Fill in the information in the "yellow" block, select the 7 check boxes, this will create a database.
But when I attempt to "Check connection" I get the error "No database found"
thanks
kb3tox
Re: unable to connect to MySQL database
Posted: 24 Apr 2019, 21:47
by G4POP
Did you install MySql and it's toolkit as in the user guide
Why do you need a mySql database?
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 11:40
by KB3TOX
*****Why do you need a mySql database?
I will be using Log4OM in a network of more than one "client" providing inputs to the database.
*****Did you install MySql and it's toolkit as in the user guide
I installed "the toolkit" ( not 100% sure what you mean). The user guide is NOT written for MySQL 8.0
This raises the question, can I use MySQL 8.0 or do I have to use the older versions 5.x???
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 12:33
by G4POP
Yes you can use later versions of MySql
I asked why because many users don't have any reason to, but you clearly do
When I get chance I will update the user guide but fully involved in V2 just now.
You need to fully instal mySql before configuring Log4om to connect to it
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 13:11
by KB3TOX
Terry
When I installed MySQL I selected the "server" installation. I did not believe the "developer" configuration was necessary.
I have logged into MySQL via the command prompt as "root" and it does show the "log4om" database. My gut felling is this is a MySQL permissions problem.
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 14:09
by G4POP
Did you install log4om to run as an administrator ?
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 15:47
by KB3TOX
Terry
Yes, it runs as admin
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 16:41
by G4POP
Try setting the MySql.exe to run as an administrator
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 17:04
by KB3TOX
Terry
As a test I removed ver 8.0 and installed ver 5.7.26 of MySQL ……… Full version
Had NO PROBLEM creating , testing and using the log4om database
Re: unable to connect to MySQL database
Posted: 25 Apr 2019, 17:10
by G4POP
Ok Ed I am pleased it's sorted but we need to check viability of V8 so thanks for flagging the issue