intranet

hi,
well, i've Arch linux, but it doesn't matter.
got apache, mysql, and php5 working perfekt.
i can see localhost and everythink is OK

but i decided to run my very own intranet.


into /etc/httpd/conf/httpd.conf I added:

<VirtualHost *:80>
ServerName petr-comp
ServerAlias petr-comp *.petr-comp
DocumentRoot "/home/petr/WWW"
</VirtualHost>

Code (markup):

from other computers (windows XP, but it doesn't matter) in my home net, when i write my IP or petr-comp to URL of browser, i see my localhost.
works perfect.

but, i want my computer to work just a server, so i have to manage everything from other computers.
sharing files is ok, but firts problem is MySQL

I want to access my MySQL DB from win. I use dev.mysql.com/downloads

it's a great admin..

so i tried to login, by MySQL Administrator
login: root (just MySQL account)
password: my_psw
server: petr-comp (or my IP)
port: 3306 (that is default)

try to log in, but error:-(
tried to ping (by MySQL Administrator and successfully done)

login and passwod is correct, server works, so i see problem in port

in my httpd.conf i found
listen:80

so i tried to change port in MySQL Admin to 80, but nothing changed...


thanx for help

 

let me take a usual wild guess at what the error was - 'access denied' - right?

you have to allow remote connections, i.e. connections from ips other than your localhost to be able to connect.

i'm not sure what the correct/best procedure to correct this is but i know editing a conf file for certain is the only way atm...a quick google search gave me this

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

Code (markup):

but it's probably best to google around to see how other people do it.