Author |
Message |
gatorback
|
Posted: Mon Sep 06, 2010 9:49 pm |
|
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 |
|
|
manicmike
|
Posted: Mon Sep 06, 2010 10:57 pm |
|
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 |
|
|
gatorback
|
Posted: Mon Sep 06, 2010 11:51 pm |
|
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 |
|
|
welner
|
Posted: Tue Sep 07, 2010 5:07 am |
|
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 |
|
|
gatorback
|
Posted: Tue Sep 07, 2010 1:01 pm |
|
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 |
|
|
welner
|
Posted: Tue Sep 07, 2010 1:12 pm |
|
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 |
|
|
gatorback
|
Posted: Tue Sep 07, 2010 1:48 pm |
|
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 |
|
|
manicmike
|
Posted: Tue Sep 07, 2010 7:42 pm |
|
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 |
|
|