LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-17-2009, 11:00 AM   #1
zectersys
LQ Newbie
 
Registered: Jan 2009
Location: jakarta
Distribution: mandriva2K9, Ubuntu 9.04, DSL
Posts: 25

Rep: Reputation: 15
Is mysql not supported in mandy 2k9


Hi guys... I just wanna ask if mysql not support by mandy 2k9? I wanna learn PHP/Mysql and I believe that LAMP is the most recommended for that. I've been install Apache and PHP but why mandy doesn't want Mysql to run in their system?

When I activate mysl with MCC suddenly a tool tips appear and it's say that mysql can not run coz it's very unstable under localhost?! If this was true then why mandy include this package in their distribution? And my 2nd question is how did I test my web database in my local machine 1st before it's run on the internet if mysql was not run?

Can U tell me how to force mysql to work in this system?

Last edited by zectersys; 02-17-2009 at 11:10 AM.
 
Old 02-18-2009, 03:50 AM   #2
GlennsPref
Senior Member
 
Registered: Apr 2004
Location: Brisbane, Australia
Posts: 3,366
Blog Entries: 33

Rep: Reputation: 216Reputation: 216Reputation: 216
Hi, mysql works fine on my mandy 2009.0 system.

Have you set up your host files?

/etc/hosts
Code:
127.0.0.1		GamesBox.GlennsPref.net localhost.localdomain localhost GamesBox,
#		generated by drakhosts
/etc/host.allow
Code:
#
# hosts.allow	This file describes the names of the hosts which are
#		allowed to use the local INET services, as decided
#		by the '/usr/sbin/tcpd' server.

ALL:	192.168.0.3,		GateBox.GlennsPref.net, GateBox
ALL:	GamesBox.GlennsPref.net
ALL:	GateBox.GlennsPref.net
ALL:	localhost
/etc/host.deny
Code:
#
# hosts.deny	This file describes the names of the hosts which are
#		*not* allowed to use the local INET services, as decided
#		by the '/usr/sbin/tcpd' server.
#
# The portmap line is redundant, but it is left to remind you that
# the new secure portmap uses hosts.deny and hosts.allow.  In particular
# you should know that NFS uses portmap!
ALL:	ALL
/etc/

And do you have bindutils installed?
mentioned in /etc/host.conf
Code:
order hosts,bind
multi on
You may view your local web-pages in konqueror or firefox.

Hope that helps you, Glenn

Last edited by GlennsPref; 02-18-2009 at 03:55 AM. Reason: add stuff
 
Old 02-22-2009, 04:06 AM   #3
zectersys
LQ Newbie
 
Registered: Jan 2009
Location: jakarta
Distribution: mandriva2K9, Ubuntu 9.04, DSL
Posts: 25

Original Poster
Rep: Reputation: 15
thx bro for your suggestion, But I was thinking Instead using "localhost" as my localhost I'm using a different name like "mylinux" or other name i want beside "localhost"

I run this command to change network name
echo "HOSTNAME=MyLinux" >> /etc/sysconfig/network

And add same name at hosts file
echo "127.0.0.1 MyLinux" >> /etc/hosts

reboot my comp

and after that I run mysqld daemon and install mysql_secure_instalation, that's it I've been running mysql on mandy 2k9!
wew... I've never expect running mysql would be so tricky like this, I've never have it before....

THX FOR EVERY ANSWER YOU GAVE TO ME BRO!!
 
Old 02-22-2009, 07:14 AM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,241

Rep: Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325
You don't append another line, you'll get duplicates. In /etc/hosts, you add your new name to the list of names already on the localhost entry.
 
Old 02-23-2009, 12:47 AM   #5
zectersys
LQ Newbie
 
Registered: Jan 2009
Location: jakarta
Distribution: mandriva2K9, Ubuntu 9.04, DSL
Posts: 25

Original Poster
Rep: Reputation: 15
yes, it's true. I just realize that after Apache complaint about my localhost name, and then apache choose 127.0.0.1 to be localhost name instead "localhost" or "MyLinux". Is there any possibiity that the name will become trouble in another coz i wanna install another server like postfix.
 
Old 02-23-2009, 11:39 PM   #6
GlennsPref
Senior Member
 
Registered: Apr 2004
Location: Brisbane, Australia
Posts: 3,366
Blog Entries: 33

Rep: Reputation: 216Reputation: 216Reputation: 216
You can set the host name by editing this file...

/etc/hosts
Code:
127.0.0.1		GamesBox.GlennsPref.net localhost.localdomain localhost GamesBox,
#		generated by drakhosts
postfix and other programs should recognise the format

Regards, Glenn
 
Old 02-25-2009, 03:38 AM   #7
zectersys
LQ Newbie
 
Registered: Jan 2009
Location: jakarta
Distribution: mandriva2K9, Ubuntu 9.04, DSL
Posts: 25

Original Poster
Rep: Reputation: 15
So basically localhost name could consist more than just 1 name right? But all the server only read IP adress instead of localhost name, am i correct? Wew... such an easy logical task but i always confuse all thiz time coz I don't know how to set it up in windows. Why everything is so easy to configure in linux D###N

Thx for your answer bro!
 
Old 02-25-2009, 03:32 PM   #8
GlennsPref
Senior Member
 
Registered: Apr 2004
Location: Brisbane, Australia
Posts: 3,366
Blog Entries: 33

Rep: Reputation: 216Reputation: 216Reputation: 216
Linux is made for users by users.

M$win is developed by a private company for sale.

Glad you got it working.

using a fqdn (fully qualified host name) must help,

the local dns attaches my fqdn with the ip address for local host (127.0.0.1).

Other network files hold other fragments, held in /etc/sysconfig/network-scripts.

Cheers, Glenn
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Internet Explorer supported website (not supported by FF) itz2000 Linux - General 17 03-24-2006 09:28 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
check if php and mysql are supported by apache? ldp Linux - Software 9 08-08-2004 04:12 PM


All times are GMT -5. The time now is 06:29 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration