-
Not connecting across a network to a Knoppix MySQL server
Running Knoppix 3.81 from CD, I've fired up MySQL and loaded a bunch of data via a USB drive. My Perl scripts work fabulously from LOCALHOST. Ping works to/from this computer so the NICs aren't the problem.
Problem:
I can't seem to connect to the MySQL server across my network. From a different machine (also running Knoppix 3.81 from CD), I type
mysql -h 192.168.1.1 -u username -ppassword
and get:
ERROR 2003: Can't connect to MySQL server on '192.168.1.1' (111)
I've moved and copied back /etc/hosts.allow and /etc/hosts.deny and added the following to /etc/hosts.allow and commented out everything in /etc/hosts.deny
mysql : 192.168.1.* : ALLOW
I tried a bunch of things in /etc/hosts.allow and resorted to:
ALL : ALL@ALL : ALLOW
And, yes, I started INETD since I wasn't sure whether or not I needed to.
Suggestions?
-
Problem solved and I'm posting the solution should someone find it helpful:
1) /etc/hosts.allow needs to be told to listen to MYSQL clients. The following three lines does that but change the IP accordingly:
sudo mv /etc/hosts.allow /etc/hosts.allow.bak
sudo cp /etc/hosts.allow.bak /etc/hosts.allow
sudo kwrite /etc/hosts.allow & # Add a line=>mysqld : ALL@192.168.1.* : ALLOW
2) Knoppix defaults to having MYSQLD ignore everything not from LOCALHOST. Comment out the "bind-address = 127.0.0.1" line of /etc/mysq/my.cnf. The following three lines does this.
sudo mv /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
sudo cp /etc/mysql/my.cnf.bak /etc/mysql/my.cnf
sudo kwrite /etc/mysql/my.cnf &
3) Start (or stop and start) MYSQLD to read the new config file
sudo /etc/init.d/mysql start
4) Set MYSQLs root password
mysqladmin -u root password root
5) Connect to MYSQL as root
mysql -u root -proot
6) Delect anonymous users
delete from mysql.user where User="";
delete from mysql.db where User="";
7) Let root log in from anywhere. You probably don't want let ROOT do this but you can use it as a GO-BY for other users.
GRANT ALL ON *.* TO "root"@"%" IDENTIFIED BY "root" WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;
-----
You should be able to go to another computer, and type
mysql -h 192.168.1.1 -u root -proot
and have it connect.
-
Junior Member
registered user
thanks for posting a solution. not many people seem to around here. i ran into this problem trying to set mythtv frontend access to the knoppix backend, but as your posts suggests, the hosts file has something to do with it. i'd assumed the same but wasn't sure how to change it.
commenting out the bind address and giving permissions to access from any host (%) hasn't worked so far so i'm going to try your suggestion as soon as my recording finishes. i'll post back to report whether or not its resolved my problem.
i assumed it may be a problem specific to knoppix as it is a live distro.
-
Junior Member
registered user
i took a look at my file /etc/hosts.allow - it contained the following which prevented connections from external hosts
ALL : ALL@ALL : DENY
commenting it out solved it for me. think this is specific to knoppix.
Similar Threads
-
By knopx4me in forum Customising & Remastering
Replies: 1
Last Post: 11-21-2008, 05:38 PM
-
By Magnus_L in forum Networking
Replies: 4
Last Post: 09-05-2008, 05:05 AM
-
By Aspra in forum Networking
Replies: 5
Last Post: 01-31-2006, 06:36 PM
-
By sange in forum Tips and Tricks
Replies: 0
Last Post: 11-06-2004, 05:56 PM
-
By Anssi in forum Networking
Replies: 2
Last Post: 04-29-2003, 06:38 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
![DELL PowerEdge R430 8SFF 2x E5-2680v4 2.4GHz =28 Cores 32GB H730 4xRJ45 picture](/store/img/g/1hMAAOSw8hVl8bKq/s-l225/DELL-PowerEdge-R430-8SFF-2x-E5-2680v4-2-4GHz-28-Co.jpg)
DELL PowerEdge R430 8SFF 2x E5-2680v4 2.4GHz =28 Cores 32GB H730 4xRJ45
$226.00
![Dell PowerEdge R630 Server 2x E5-2680 V4 = 28 Cores S130 32GB RAM NEW 480GB SSD picture](/store/img/g/vx0AAOSwvwFlExVY/s-l225/Dell-PowerEdge-R630-Server-2x-E5-2680-V4-28-Cores-.jpg)
Dell PowerEdge R630 Server 2x E5-2680 V4 = 28 Cores S130 32GB RAM NEW 480GB SSD
$197.99
![Cisco UCS C240 M4 2U Server w/ 2x E5-2680v4, NO RAM picture](/store/img/g/Je8AAOSwIcdmTgJF/s-l225/Cisco-UCS-C240-M4-2U-Server-w-2x-E5-2680v4-NO-RAM.jpg)
Cisco UCS C240 M4 2U Server w/ 2x E5-2680v4, NO RAM
$49.99
![1U Supermicro Server 10 Bay 2x Intel Xeon 3.3Ghz 8C 128GB RAM 240GB SSD 2x 10GBE picture](/store/img/g/7KoAAOSwephiKTf4/s-l225/1U-Supermicro-Server-10-Bay-2x-Intel-Xeon-3-3Ghz-8.jpg)
1U Supermicro Server 10 Bay 2x Intel Xeon 3.3Ghz 8C 128GB RAM 240GB SSD 2x 10GBE
$259.00
![Dell PowerEdge R630 Server 2x E5-2640v3 2.60Ghz 16-Core 64GB H330 picture](/store/img/g/ZD0AAOSwm41mOZYw/s-l225/Dell-PowerEdge-R630-Server-2x-E5-2640v3-2-60Ghz-16.jpg)
Dell PowerEdge R630 Server 2x E5-2640v3 2.60Ghz 16-Core 64GB H330
$182.65
![Dell Poweredge R630 Server 2x E5-2620 V4 =16 Cores | S130 | 32GB RAM | 2x trays picture](/store/img/g/GAcAAOSw9Q1mGSZW/s-l225/Dell-Poweredge-R630-Server-2x-E5-2620-V4-16-Cores-.jpg)
Dell Poweredge R630 Server 2x E5-2620 V4 =16 Cores | S130 | 32GB RAM | 2x trays
$159.99
![Dell PowerEdge R720xd 26HDD 300gb 2.5-inch E5-2697 X 2CPU 384RAM 7.2 Tb HDD  picture](/store/img/g/yAwAAOSwdyNlgQ8d/s-l225/Dell-PowerEdge-R720xd-26HDD-300gb-2-5-inch-E5-2697.jpg)
Dell PowerEdge R720xd 26HDD 300gb 2.5-inch E5-2697 X 2CPU 384RAM 7.2 Tb HDD 
$180.00
![Dell PowerEdge R620 Server 2x E5-2660 v2 2.2GHz 20 Cores 256GB RAM 1x 480GB SSD picture](/store/img/g/Fk4AAOSwDDplpAyL/s-l225/Dell-PowerEdge-R620-Server-2x-E5-2660-v2-2-2GHz-20.jpg)
Dell PowerEdge R620 Server 2x E5-2660 v2 2.2GHz 20 Cores 256GB RAM 1x 480GB SSD
$139.99
![DELL PowerEdge R730 Server 2x E5-2680v3 2.5GHz =24 Cores 128GB H730 4xRJ45 picture](/store/img/g/O2MAAOSwRtNkh97Y/s-l225/DELL-PowerEdge-R730-Server-2x-E5-2680v3-2-5GHz-24-.jpg)
DELL PowerEdge R730 Server 2x E5-2680v3 2.5GHz =24 Cores 128GB H730 4xRJ45
$345.00
![Dell Poweredge R730xd LFF 14-Bay 2U Server | Choose Your CPU & RAM Config picture](/store/img/g/CdkAAOSwY0BmYMoF/s-l225/Dell-Poweredge-R730xd-LFF-14-Bay-2U-Server-Choose-.jpg)
Dell Poweredge R730xd LFF 14-Bay 2U Server | Choose Your CPU & RAM Config
$489.99