LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Is mysql not supported in mandy 2k9 (https://www.linuxquestions.org/questions/linux-newbie-8/is-mysql-not-supported-in-mandy-2k9-705375/)

zectersys 02-17-2009 10:00 AM

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?

GlennsPref 02-18-2009 02:50 AM

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

zectersys 02-22-2009 03:06 AM

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!!

chrism01 02-22-2009 06:14 AM

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.

zectersys 02-22-2009 11:47 PM

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.

GlennsPref 02-23-2009 10:39 PM

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

zectersys 02-25-2009 02:38 AM

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!

GlennsPref 02-25-2009 02:32 PM

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


All times are GMT -5. The time now is 02:04 AM.