unable to connect to MySQL database

Need help? - Post here and we will find a solution for you.
Locked
KB3TOX
Novice Class
Posts: 5
Joined: 24 Apr 2019, 21:21

unable to connect to MySQL database

Post 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
Thank you for you time
73
KB3TOX (Ed)
User avatar
G4POP
Log4OM Alpha Team
Posts: 10803
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: unable to connect to MySQL database

Post by G4POP »

Did you install MySql and it's toolkit as in the user guide

Why do you need a mySql database?
73 Terry G4POP
KB3TOX
Novice Class
Posts: 5
Joined: 24 Apr 2019, 21:21

Re: unable to connect to MySQL database

Post 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???
Thank you for you time
73
KB3TOX (Ed)
User avatar
G4POP
Log4OM Alpha Team
Posts: 10803
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: unable to connect to MySQL database

Post 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
73 Terry G4POP
KB3TOX
Novice Class
Posts: 5
Joined: 24 Apr 2019, 21:21

Re: unable to connect to MySQL database

Post 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.
Thank you for you time
73
KB3TOX (Ed)
User avatar
G4POP
Log4OM Alpha Team
Posts: 10803
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: unable to connect to MySQL database

Post by G4POP »

Did you install log4om to run as an administrator ?
73 Terry G4POP
KB3TOX
Novice Class
Posts: 5
Joined: 24 Apr 2019, 21:21

Re: unable to connect to MySQL database

Post by KB3TOX »

Terry

Yes, it runs as admin
Thank you for you time
73
KB3TOX (Ed)
User avatar
G4POP
Log4OM Alpha Team
Posts: 10803
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: unable to connect to MySQL database

Post by G4POP »

Try setting the MySql.exe to run as an administrator
73 Terry G4POP
KB3TOX
Novice Class
Posts: 5
Joined: 24 Apr 2019, 21:21

Re: unable to connect to MySQL database

Post 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
Thank you for you time
73
KB3TOX (Ed)
User avatar
G4POP
Log4OM Alpha Team
Posts: 10803
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: unable to connect to MySQL database

Post by G4POP »

Ok Ed I am pleased it's sorted but we need to check viability of V8 so thanks for flagging the issue
73 Terry G4POP
Locked