Slackware 10 Mysql Won't start
 

When I installed slackware 10, I told it to install mysql. It did install it but now I can't get it started. I use the standard mysqld_safe & to commence it, but when I go to use an app that uses mysql, mythtv to be exact, i get the following error:

Unable to connect to database!
Driver error was [1/1130]:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.2.28' is not allowed to connect to this MySQL server

Unable to open database:
Driver error was:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.2.28' is not allowed to connect to this MySQL server

Any ideas? Thanks

Not sure if this will work for you, but looks like the way to start a few applications has change significantly (at least, with SuSE 9.1 it did). For me, to start mysql, I've to use:

rcmysqld start

Same goes to apache now:

rcapache2ctl start

I hope this will also work for you...

Good luck!

When I try that all I get is "command not found".

1. the mysql server is started...

2. did you add a user and allow it to connect from 192.168.2.28?

or check hosts.allow and hosts.deny
maybe even firewall

and don't remember where but isn't there someplace in the mysql configuration
where you have to say who can connect to it?

i remember setting somewhere that only localhost can connect to my database
(using it for php that's the only place i need to connect from)

MySQL is refusing the connection, it has nothing to do with hosts.allow or hosts.deny or firewall.


shell> mysql -u root -p mysql
mysql> select User, Host from user where User='<username>'

if i remember correctly

:cool:
Have you checked the grant tables for mysql?

Are you trying to connect as root or as another user?
In either case, the privileges have to be defined.
Let's know how it turns out. Good luck !