LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 06-29-2004, 11:06 AM   #1
codyman
LQ Newbie
 
Registered: Jun 2004
Posts: 12

Rep: Reputation: 0
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
 
Old 06-29-2004, 11:37 AM   #2
Mega Man X
Guru
 
Registered: Apr 2003
Location: ~
Distribution: Ubuntu, FreeBSD, Solaris, DSL
Posts: 5,339

Rep: Reputation: 63
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!
 
Old 07-01-2004, 10:09 AM   #3
codyman
LQ Newbie
 
Registered: Jun 2004
Posts: 12

Original Poster
Rep: Reputation: 0
When I try that all I get is "command not found".
 
Old 07-01-2004, 10:20 AM   #4
chuckt101
LQ Newbie
 
Registered: Jul 2004
Location: WEST SIDE
Distribution: ChuckNIX
Posts: 7

Rep: Reputation: 0
1. the mysql server is started...

2. did you add a user and allow it to connect from 192.168.2.28?
 
Old 07-01-2004, 10:27 AM   #5
shimmer2101
LQ Newbie
 
Registered: Jul 2004
Posts: 10

Rep: Reputation: 0
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)
 
Old 07-01-2004, 10:48 AM   #6
chuckt101
LQ Newbie
 
Registered: Jul 2004
Location: WEST SIDE
Distribution: ChuckNIX
Posts: 7

Rep: Reputation: 0
Quote:
Originally posted by shimmer2101
or check hosts.allow and hosts.deny
maybe even firewall
MySQL is refusing the connection, it has nothing to do with hosts.allow or hosts.deny or firewall.

Quote:
Database error was:
Host '192.168.2.28' is not allowed to connect to this MySQL server

Quote:
Originally posted by shimmer2101

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)
shell> mysql -u root -p mysql
mysql> select User, Host from user where User='<username>'

if i remember correctly
 
Old 07-01-2004, 02:30 PM   #7
slackerboy
Member
 
Registered: Jul 2002
Location: USA
Distribution: Slackware, Red Hat, Ubuntu
Posts: 58

Rep: Reputation: 15

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 !
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
MySQL in Slackware 10 , how to start ? ? ? caovankhanhvn Programming 2 08-13-2004 11:51 AM
mysql doesn't start devit Linux - General 12 05-21-2004 03:24 PM
How do I start mysql willem7238 Fedora 3 05-08-2004 03:28 PM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 06:12 PM


All times are GMT -5. The time now is 11:24 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration