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
unable to connect to MySQL database
unable to connect to MySQL database
Thank you for you time
73
KB3TOX (Ed)
73
KB3TOX (Ed)
- 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
Did you install MySql and it's toolkit as in the user guide
Why do you need a mySql database?
Why do you need a mySql database?
73 Terry G4POP
Re: unable to connect to MySQL database
*****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???
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)
73
KB3TOX (Ed)
- 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
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
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
Re: unable to connect to MySQL database
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.
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)
73
KB3TOX (Ed)
- 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
Did you install log4om to run as an administrator ?
73 Terry G4POP
Re: unable to connect to MySQL database
Terry
Yes, it runs as admin
Yes, it runs as admin
Thank you for you time
73
KB3TOX (Ed)
73
KB3TOX (Ed)
- 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
Try setting the MySql.exe to run as an administrator
73 Terry G4POP
Re: unable to connect to MySQL database
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
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)
73
KB3TOX (Ed)
- 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
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