[SMS]

[webtrip]

I am trying to get the sql server working. PHPmyadmin works to edit databases only cannot connect to database server. Test with nmap gave 3306 port closed. So i wonder if mysql is configured ok? Cannot find anywhere an nice howto to follow.

Default username= root (without password)

What is the command to start the mysql server?
And where i can find the log for the mysql server?

Sugestions and help are very welcome?

[gerasimos_h]

"smsconfig st" will give you status of all services...
to start mysql just do
"smsconfig sql start"
or if you like the slackware way
"/etc/rc.d/rc.mysqld start"
the log is at
/var/lib/mysql/{hostname}.err

gerasimos_h

[webtrip]

mysql is started on port 0.
I work with webmin and i am sure i set port 3306 on all connections open.
I think mysql runs only localy now , want to change that to running on my LAN.
Ive tried the next line in my.cnf

bind-address = 192.168.0.111

but this does not work even after restart not.

What am i doing wrong?

[webtrip]

Got it working!!!


I commented for the next line in rc.mysqld

#SKIP="--skip-networking"

without the # the network config don't startup. The sollution is quite easy
afterall. Afterwards