View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 8 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: MySQL through port 3306
PostPosted: Mon Sep 06, 2010 9:49 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
I am attempting to access MySQL through port 3306. I am attempting to construct an ERD using ODBC and Embarcadero.

I installed the MYSQL 5.1 ODBC driver on my Win2K VM and trying to setup the ODBC connector for Embarcadero. No joy.

I have tried 'knocking' on port 3306 with SSH and telnet to ascertain if the port is open, however, I see no evidence that it is open (does not mean port is closed: my tests may be invalid).

I verified that the user/pw from the command line:



QUESTIONS:
Is there a better test to determine if MySQL is responsive on port 3306?
Is there something that I need to do to 'open' the MySQL port?

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
PostPosted: Mon Sep 06, 2010 10:57 pm 
Offline
Joined: Sun Aug 28, 2005 7:07 pm
Posts: 821
Location: Melbourne, Australia
gatorback wrote:
Is there something that I need to do to 'open' the MySQL port?


This is uber-newbie Question #1 but have you uncommented "skip networking" in the mysql.conf and restarted the daemon?"

Mike

_________________
*********************
LinHES 7.4
Australian Dragon
*********************


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 06, 2010 11:51 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
I did not: I could not find mysql.conf (tried using find and which as root). Webmin indicates that skip_networking is ON. It would seem that this puts me on the path to resolving the problem. Unfortunately, Webmin does not allow me to change this value.

I tried to Google the location of mysql.conf: an article indicated that my.conf is under /etc/mysql, however I could not find such a directory. Any suggestions as to the file name and location? Thanks!

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 07, 2010 5:07 am 
Offline
Joined: Sat Jan 06, 2007 7:08 pm
Posts: 125
perhaps it is called my.cnf in /etc:

/usr/share/mysql/mysql.server

has:

else
# Try to find basedir in /etc/my.cnf
conf=/etc/my.cnf

_________________
DH87MC i7-4770 16GB ram Xonar Essence ST geforce 710 LinHes 8.6


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 07, 2010 1:01 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
I commented out skip-networking in /etc/my.cnf, then restarted mysql. Verified, via Webmin, that

Quote:
skip_networking=off


Tried to access database with ODBC MySQL driver and was denied. I verified that the logon/pw is good through the command line.

Is there anything that I have missed? I am not sure what the next question should be.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 07, 2010 1:12 pm 
Offline
Joined: Sat Jan 06, 2007 7:08 pm
Posts: 125
it is unclear if your various attempts to access the database are from your mythtv back end or other boxes.

as described in this posting:

http://mysettopbox.tv/phpBB2/viewtopic. ... networking

have you granted access to the db user from hosts other than 127.0.0.1 or your front end?

_________________
DH87MC i7-4770 16GB ram Xonar Essence ST geforce 710 LinHes 8.6


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 07, 2010 1:48 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
@welner: I am attempting to access MySQL from a Win2K box. I did not grant the DB user access from other boxes. The link in your last post indicates that the mythtv DB account is setup to work this way. Thanks for getting me over the hump.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 07, 2010 7:42 pm 
Offline
Joined: Sun Aug 28, 2005 7:07 pm
Posts: 821
Location: Melbourne, Australia
gatorback wrote:
I commented out skip-networking in /etc/my.cnf, then restarted mysql. Verified, via Webmin, that

Quote:
skip_networking=off


Tried to access database with ODBC MySQL driver and was denied. I verified that the logon/pw is good through the command line.

Is there anything that I have missed? I am not sure what the next question should be.


OK, MySQL only has access for user mythtv for localhost. You will need to have an account that is accessible outside of it. I believe there is a script for this, but you can do it manually like this (working from memory, so may not be 100% accurate):
1. in an xterm on localhost, type
Code:
echo UPDATE user set Host="%" where User="mysql"|mysql -u root mysql

2. Restart mysql
Actually, I can't recall how to do this on arch. Think it's something like:
Code:
sv mysql restart


3. Log in from anywhere.

Anyone can now access your database using standard, known credentials, provided they can get to port 3306, but you don't have to worry too much if your router/switch has blocked this port from outside.

Mike

_________________
*********************
LinHES 7.4
Australian Dragon
*********************


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 24 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu