Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Distribution: Debian, RH9, FC 6, and ...uh... um... microsoft
Posts: 2
Rep:
Fedora Core 6 MySQL port
I installed Mysql 5.0x on my Fedora Core 6 box.
I can connect to mysql in the terminal okay but I want to connect across my lan like I can to another box.
The other box is a Debian/MySQL box and I can connect from my webserver on a port other than the default mysql port (3306).
I am not sure if SElinux or some unique config is required in Fedora to do this.
When I try to puTTY to the FC 6 box I get a "failure to connect"
Putty can't connect on port 3306 for MySQL, it's an ssh client, you need to use mysql to connect.
If you want to connect to your MySQL host from another connection, you most likely need to add the host and user to the MySQL database to allow such connection.
mysql> grant all privileges on *.* to user@<hostname-or-ip> identified by 'password';
Distribution: Debian, RH9, FC 6, and ...uh... um... microsoft
Posts: 2
Original Poster
Rep:
Ooops! I am sorry about the puTTY usage I was wrong.
I use puTTY a lot but not for MySQL connections.
I use SQLyog mostly for administrative/maintenance purposes.
Maybe I should state my goal here...
I want to duplicate (replicate?) my Debian database box so in case of a hardware failure I can keep my company up and running.
My Debian box has MySQL running on a different port than 3306. My PHP connections work fine with that. I want to "mirror" the Debian box or at least set-up a cron to copy the database at prescribed intervals.
First I have to get the FC 6 box to have exactly the same databases as the Debian Box
NOTE: I am self-taught and have to figure everything out as I go.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.