!! SOLVED !! Maria DB problem - "MySql is offline" - but it isn't!

[Brodephat]

OK then my thought would be what IP address is MySQL using because it may not be 127.0.0.1

I'm sure you have tried using localhost instead of 127.0.0.1

I would have to  login and look at it.

[Major Armstrong]

Yes, I have tried localhost as well.  And 0.0.0.0.  How can I find out what IP address it may be using?

[FreerunMedia]

Yes, I have tried localhost as well.  And 0.0.0.0.  How can I find out what IP address it may be using?

As far as i know 0.0.0.0 is not a local host. Every local is 127.0.0.1 and that should work.

The best thing to do is export all the settings in the SQL DBase, uninstall everything and reinstall it with a clean install. Than install RadioDJ again and use the database setup tool. If the database is there you can put back all the settings through the DBase tool of RadioDJ.

[Calypso]

As far as i know 0.0.0.0 is not a local host. Every local is 127.0.0.1 and that should work.

0.0.0.0 (/0) = all networks (every networkinterface)

[Major Armstrong]

uninstall everything and reinstall it with a clean install. Than install RadioDJ again and use the database setup tool.

I have done this.  Several times.  The issue is I can't connect to the DB server.

[Major Armstrong]

SOLVED!

After trying just about everything on various MySQL forums, I finally hit the magic number.  I added this line to the my.ini file:

Code Select Expand

bind-address=0.0.0.0

Bingo!

So, in case anyone in the future needs it, here is what the complete my.ini file looks like:

Code Select Expand

[mysqld]
datadir=C:/Program Files/MariaDB 10.0/data
port=3306
bind-address=0.0.0.0
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
innodb_buffer_pool_size=414M
innodb_log_file_size=50M
[client]
port=3306


Thanks to everyone who offered help and suggestions.