View previous topic :: View next topic |
Author |
Message |
webtrip Member
Joined: 07 Jun 2014 Posts: 22 Location: Netherlands
|
Posted: Tue Jun 10, 2014 10:04 pm Post subject: Howto start mysql server? NMAP gives sqlport 3306 closed! |
|
|
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? _________________ Richard Trip
Field Service Engineer (IT & Document Sollutions )
Printer/MFP specialist |
|
Back to top |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 10, 2014 11:18 pm Post subject: |
|
|
"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 _________________ Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
Back to top |
|
webtrip Member
Joined: 07 Jun 2014 Posts: 22 Location: Netherlands
|
Posted: Mon Jun 16, 2014 2:27 pm Post subject: |
|
|
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? _________________ Richard Trip
Field Service Engineer (IT & Document Sollutions )
Printer/MFP specialist |
|
Back to top |
|
webtrip Member
Joined: 07 Jun 2014 Posts: 22 Location: Netherlands
|
Posted: Mon Jun 16, 2014 2:39 pm Post subject: |
|
|
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 ![Laughing](images/smiles/icon_lol.gif) _________________ Richard Trip
Field Service Engineer (IT & Document Sollutions )
Printer/MFP specialist |
|
Back to top |
|
|