MySQL disabled

CollieJim · 02-05-2012, 01:24 AM

I'm trying to get MySQL started on a Buffalo LinkStation Pro for my digiKam database. The box came with MySQL installed, but not automatically started.

When I try to start it, I get

Code:

 * Starting MySQL server ... MySQL disabled

The system appears to be a Debian derivative.

Code:

root@Nas:~# uname -a
Linux Nas 2.6.31.8 #2 Fri Aug 5 14:28:08 JST 2011 armv5tel unknown

What am I missing?

Thanks
Jim

resetreset · 02-05-2012, 11:32 AM

Is anything else listening on that port?

CollieJim · 02-06-2012, 03:06 AM

I don't know.
However I did find 2 variables that had been set to keep MySQL from running.
Currently it is started but rejecting access from another machine. It's on 192.168.0.101 and 192.168.0.103 wants access.

Eppo · 02-06-2012, 03:40 PM

log in as root and do this:
CREATE USER 'jeffrey'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'%';
my guess is that you need to create an account that can log in over the network. that is what the % is for when you create a new user.
you might want to do a google for MYSQL GRANT so you can grant this user access to what it needs.