mySQL on Red Hat 7.2

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
def1014
Forum Newbie
Posts: 2
Joined: Mon Apr 22, 2002 2:55 pm

mySQL on Red Hat 7.2

Post by def1014 »

I have mySQL installed on a box running Red Hat 7.2. The database is running fine, the only problem is that it is not accepting connections to 3006. I have done a web search for this on the net and have found some sites saying that I need to remove a skip-networking option on safe_mysqld. Looked there and in my.cnf, skip networking in is neither of those. Any help would be appreciated.
User avatar
fatal
Forum Contributor
Posts: 118
Joined: Sat Apr 20, 2002 10:47 am
Location: East Coast

Post by fatal »

maybe you can try checking ports again. Also check you httpd.confg file for that line.
User avatar
EvilWalrus
Site Admin
Posts: 209
Joined: Thu Apr 18, 2002 3:21 pm
Location: Springmont, PA USA

Post by EvilWalrus »

mysql runs (default) on 3306, not 3006...
User avatar
sam
Forum Contributor
Posts: 217
Joined: Thu Apr 18, 2002 11:11 pm
Location: Northern California
Contact:

Post by sam »

If you making a connection from a remote computer be sure to grant a user with remote IP privledges.

Cheers Sam
User avatar
def1014
Forum Newbie
Posts: 2
Joined: Mon Apr 22, 2002 2:55 pm

Post by def1014 »

I can't get anything when I telnet to 3306. It was a typo by the way. I can login to mysql from the machine just fine. There are many PHP pages currently using the db also. The real problem I'm having is that users would like to use mySQLfront from their windows desktops to modify the database. I basically need to figure out how to enable them to log on through port 3306. Thanks.
timmy
Forum Newbie
Posts: 15
Joined: Fri Apr 19, 2002 9:45 am
Location: Calgary, AB

Post by timmy »

did you modify your permissions table to properly allow remote users to connect to the db? there's a good article on melonfire.com on access permissions with MySQL. That's most likely where your problwm lies.

http://www.melonfire.com/community/col ... php?id=62

good luck!
Post Reply