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

[Major Armstrong]

Put in a fresh install of XP and an SSD on my RDJ machine and having all kinds of issues getting it back up and running.  Been systematically solving problems for 2 days, and this one has me stumped.

Task mgr is showing mysql service RUNNING... but when I try to run RDJ db setup (yes, as administrator), it shows red message "My SQL is offline". I installed Maria exactly per the tutorials on DJ Gary baldy's site.  I even uninstalled it and reinstalled it again, just in case.  Can't connect using Heidi SQL app, either.   Credentials entered are correct.  Oh, yes, and I can ping 127.0.0.1 fine.

I should note I'm installing v 10.1 something of Maria... the latest version doesn't work on my machine and says something like, "This is only for Vista and higher (I have XP PRO... did Maria pull support for it, too?!).

Computer is Dell Optiplex 755 duo core with 4GB of RAM, a dedicated OS drive (with over 100 GB free).  XP Pro 32-bit.

Thank you for any suggestions.

[FreerunMedia]

Put in a fresh install of XP and an SSD on my RDJ machine and having all kinds of issues getting it back up and running.  Been systematically solving problems for 2 days, and this one has me stumped.

Task mgr is showing mysql service RUNNING... but when I try to run RDJ db setup (yes, as administrator), it shows red message "My SQL is offline". I installed Maria exactly per the tutorials on DJ Gary baldy's site.  I even uninstalled it and reinstalled it again, just in case.  Can't connect using Heidi SQL app, either.   Credentials entered are correct.  Oh, yes, and I can ping 127.0.0.1 fine.

I should note I'm installing v 10.1 something of Maria... the latest version doesn't work on my machine and says something like, "This is only for Vista and higher (I have XP PRO... did Maria pull support for it, too?!).

Computer is Dell Optiplex 755 duo core with 4GB of RAM, a dedicated OS drive (with over 100 GB free).  XP Pro 32-bit.

Thank you for any suggestions.

The only thing i can sugest is password. If the password isn't correct or the same, it won't show up as "" Online".

[ghm72]

(I have XP PRO... did Maria pull support for it, too?!).

Most software companies have pulled support for XP.

They're only coding software for newer operating systems.

Given the recent cyber attack I'd suggest you upgrade to a newer OS even a second hand PC with Windows 7 would do.

[FreerunMedia]

DJ Garybaldy is right and if you have or can find a C2D, socket 775 processor, it will work too. The Dell can handle up to QC processor so just install Windows 7 and you'll be safe for a little time.

[Major Armstrong]

The password is okay, but thanks.  The problem is the task manager shows the mysqld service is running, but the setup app in RDJ says it's not.

Thanks for your responses.  I understand the desire to upgrade OS and I will.  I'd like to put a whole new machine on it, but this is a hobby and I don't have that luxury at present.  The bugger is it was working fine before, so just putting Win 7 on this machine will not cure the ills.  It is something in the configuration upstream.  I'm using the same version of Maria I had before and the same version of RDJ.  I installed XP from the same Microsoft-purchased CD I used before, too.

I uninstalled Maria and tried an old version of the original MySQL and it ran into the same roadblock... only it doesn't even start the service.  It says cannot start on ".." - which, if that's supposed to be my localhost machine, shouldn't it say 'Cannot start on 127.0.0.1'?  That is probably a huge clue - but I'm not saavy enough to know what to look at.  (I CAN ping 127.0.0.1).

[ghm72]

Is the Windows Firewall allowing connections on port 3306?

[Major Armstrong]

Yes, sir, it is.  Even turning the firewall off doesn't help.

As a temporary measure, I've installed another automation that doesn't use a database until I can get another computer (or get this issue resolved).  I've searched the Dell tech support forums, installed every driver they have, but no difference.  I can't imagine what changed!  I'm stumped.

[Vanlen]

The problem is the task manager shows the mysqld service is running, but the setup app in RDJ says it's not.

I'm no expert either with databases, but just on a whim...did you uninstall mysql and install MariaDB and was the mysql completely uninstalled as a service? I had something similar a few years back and it was because an older mysql that I uninstalled but didn't STOP the service first and put in MariaDB.  Once I stopped the services and deleted mysql and mariaDB and rebooted I was back in Business after re-installing MariaDB.    Doubt this is your issue, but it might lead to something.

[neutralhills]

Have you checked the my.ini file found in the c:\program files\MariaDB\ directory? Here's what mine looks like:

Code Select Expand

[mysqld]
datadir=C:/Program Files/MariaDB 10.1/data
port=3306
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
innodb_buffer_pool_size=1008M
innodb_log_file_size=50M
character-set-server=utf8
[client]
port=3306

Port 3306 is set correctly in there?

[Major Armstrong]

Here is mine...

Code Select Expand

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

[Major Armstrong]

In the Maria db DATA folder, there is a ".err" file... mine says:

Code Select Expand

170522  0:57:31 [Note] Server socket created on IP: '::'.
170522  0:57:31 [Note] Event Scheduler: Loaded 0 events
170522  0:57:31 [Note] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: ready for connections.
Version: '10.0.12-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution

^ I keep seeing that "Server socket created on IP: '::'  "  Shouldn't that be "127.0.0.1?" Can someone please check their err file and let me know what it says?

Here's what I keep getting (I can't connect using Heidi, either):


[attachment deleted by admin]

[Calypso]

In the Maria db DATA folder, there is a ".err" file... mine says:

Code Select Expand

170522  0:57:31 [Note] Server socket created on IP: '::'.

^ I keep seeing that "Server socket created on IP: '::'  "  Shouldn't that be "127.0.0.1?" Can someone please check their err file and let me know what it says?

:: is the IPv6 equivalent of 0.0.0.0 (so all interfaces)

[Brodephat]

I may be wrong but it looks like you might have some old MySQL files lying around that were not removed before re-installing MariaDB.

When uninstalling MySQL,  you must physically remove left over files and folders.  Then you should make sure it is no longer running before installing it again.

[Major Armstrong]

Thank you, Calypso.  That's a relief.

Brodephat... you may be on to something.  I did use the Windows Transfer Files and Settings Wizard when I moved from the old HDD to the new one... and I'm sure I didn't use the same password on the Maria install as last time (since I couldn't remember it).

Where should I look for these other files (beyond the MariaDB folder itself)?

Thanks again, everyone, for your help!   

[Major Armstrong]

I found old files in the App Data directory on C:, which I deleted.  I stopped mysqld service, uninstalled, and then reinstalled Maria... same problem persists.

In searching the forums for the error code that I get when trying to connect with Heidi:
SQL Error (2003) in statement #0: Can't connect to MySQL server on '127.0.0.1' (10061)

I have MORE INFO...

Presumably, I CAN connect in the CMD prompt, using:  mysqld.exe -hlocalhost -uroot -p[mypwd]

Code Select Expand

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.0.12-MariaDB mariadb.org binary distribution

Then I entered the command to view the server status:

Code Select Expand

mysqld.exe Ver 15.1 Distrib 10.0.12-MariaDB, for Win32 (x86)

Connection id:  2
Current database:
Current user:  root@localhost
SSL:  Not in use
Using delimiter:  ;
Server:  MariaDB
Server version:  10.0.12-MariaDB mariadb.org binary distribution
Protocol version:  10
Connection:  localhost via TCP/IP
Server characterset:  latin1
Db characterset:  latin1
Client characterset:  cp850
Conn. characterset:  cp850
TCP port:  3306
Uptime:  35 min 59 sec

Threads: 1 Questions: 6 Slow queries: 0 Opens: 0 Flush tables: 1
Open tables: 63 Queries per second avg: 0.002

While this is SOME progress, I hope this might send up a clue for someone as I am still stumped.