-
TIP: Connecting to mySQL over a network
I racked my brains for the better part of a day trying to figure this one out...and the worst part is it's not documented anywhere that the networking option is off by default (except in the config file where it's turned off).
You should be in a terminal as root.
To enable networking (i.e. listen on port 3306) open up /etc/msql/my.cnf in an editor.
Scroll down to the line that says "skip-networking" (it was line 47 in mine), and comment it by putting a # in front. Save and exit.
stop the server:
/etc/init.d/mysql stop
start it up again:
mysqld &
That's it! Now you can connect from another machine with mysqlcc or whatever else.
Similar Threads
-
By kayl in forum General Support
Replies: 3
Last Post: 04-19-2009, 09:42 PM
-
By Override in forum Networking
Replies: 17
Last Post: 12-12-2005, 08:44 PM
-
By rasheemo in forum Networking
Replies: 1
Last Post: 05-25-2004, 03:51 PM
-
By Anssi in forum Networking
Replies: 2
Last Post: 04-29-2003, 06:38 AM
-
By newbie123 in forum General Support
Replies: 1
Last Post: 12-25-2002, 04:09 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules

Cisco SFP-10G-SR Transceiver
$4.00

Qty 20 New Cisco QSFP-100G-FR-W2 10-3659-01 Module Hologram Brand New 20 Pack
$260.00

Cisco SFP-10G-T-X 10G SFP 30m Transceiver 30-1599-01 w/ Hologram
$200.00

SFP QSFP Transceivers Programmer allows to corning and (re)programming sfp code
$108.09

10Gb SFP+ to RJ45 Module Copper Cat6 Transceiver Compatible w/5Gb/ 2.5Gb/ 1Gb
$31.95

Intel X520-DA2 10Gb 10Gbe 10 Gigabit Network Adapter NIC Dual Port E10G42BTDA
$28.94

HP 669279-001 560SFP+ Ethernet 10Gb 2-Port Network Adapter Card W/SFPx2 -Both
$14.99

SFP TO RJ45 TRANSCEIVER SFP MODULE COPPER SFP OPTICAL PORT TO RJ45 ETHERNET PORT
$7.99

Cisco Acacia DP04QSDD-E25-840 400G QSFP-DD Coherent DCO Transceiver Module
$699.99

Cisco SFP-10G-SR-S Transceiver Module 10-3105-01
$100.00