Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
Howto start mysql server? NMAP gives sqlport 3306 closed!
View previous topic :: View next topic  
Author Message
webtrip
Member


Joined: 07 Jun 2014
Posts: 22
Location: Netherlands

PostPosted: Tue Jun 10, 2014 10:04 pm    Post subject: Howto start mysql server? NMAP gives sqlport 3306 closed! Reply with quote

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
View user's profile Send private message Send e-mail
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Tue Jun 10, 2014 11:18 pm    Post subject: Reply with quote

"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
View user's profile Send private message Visit poster's website
webtrip
Member


Joined: 07 Jun 2014
Posts: 22
Location: Netherlands

PostPosted: Mon Jun 16, 2014 2:27 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
webtrip
Member


Joined: 07 Jun 2014
Posts: 22
Location: Netherlands

PostPosted: Mon Jun 16, 2014 2:39 pm    Post subject: Reply with quote

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

_________________
Richard Trip
Field Service Engineer (IT & Document Sollutions )
Printer/MFP specialist
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional