Re: [FC3] MySQL TCP/IP Config
From: Alexander Dalloz (ad+lists_at_uni-x.org)
Date: 02/10/05
- Previous message: Richard E Miles: "Re: Display goes bad, seemingly randomly, during install of FC3"
- In reply to: Qyvind_Lode?=: "[FC3] MySQL TCP/IP Config"
- Next in thread: Qyvind_Lode?=: "Re: [FC3] MySQL TCP/IP Config"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: For users of Fedora Core releases <fedora-list@redhat.com> Date: Thu, 10 Feb 2005 21:04:48 +0100
Am Do, den 10.02.2005 schrieb Øyvind Lode um 17:47:
> Can someone please tell me what I need to do in my /etc/my.cnf or can I
> just forward tcp 3306 to the server and it will work?
>
> -Øyvind
By default the Fedora Core setup of MySQL allows both UNIX socket
connections on the host itself as well TCP socket connections through
port 3306, either locally (localhost) or remotely (servername:3306).
I do not understand what you think you need to forward. Did you or your
users read the phpMyAdmin setup documentation? The main configuration
file contains:
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or
IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port -
leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the
socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to
MySQL server ('tcp' or 'socket')
which I feel is pretty self explanatory. If the MySQL server runs on the
same host as the Apache with phpMyAdmin it is sufficient to use
localhost and socket. If the MySQL server is a different host you will
have to use the server's hostname or IP and tcp for the connect_type
setting. You can leave the port setting off if you didn't change the
default port 3306 to something different.
Btw. the MySQL documentation contains the information to bind the server
to a specific port:
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Option_files.html
Alexander
-- Alexander Dalloz | Enger, Germany | new address - new key: 0xB366A773 legal statement: http://www.uni-x.org/legal.html Fedora GNU/Linux Core 2 (Tettnang) on Athlon kernel 2.6.10-1.9_FC2smp Serendipity 20:54:01 up 13 days, 22:24, load average: 0.12, 0.54, 0.59
-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
- application/pgp-signature attachment: Dies ist ein digital signierter Nachrichtenteil
- Previous message: Richard E Miles: "Re: Display goes bad, seemingly randomly, during install of FC3"
- In reply to: Qyvind_Lode?=: "[FC3] MySQL TCP/IP Config"
- Next in thread: Qyvind_Lode?=: "Re: [FC3] MySQL TCP/IP Config"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
