RE: MySQL only listens on localhost

2007-10-13 Thread Franz Edler
Thanks to all: > Check for bind-address in your my.cnf file That solved the problem. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL only listens on localhost

2007-10-13 Thread Banyan He
Check your my.cf file a /etc/my.cf. To add the "bind-address = " at the end of the file. Restart your mysql. And grant the access to the user who you want to connect your database from where you can accept. Franz Edler wrote: Hello, Can anyone please give me a hint what I can do that MySQL

Re: MySQL only listens on localhost

2007-10-13 Thread Jim Ginn
Franz: Did you setup user access permissions outside of 127.0.0.1 and is port 3306 open on your firewall/router? Jim Ginn http://www.Tenant.com > Hello, > > Can anyone please give me a hint what I can do that MySQL also listens to > the physical address of the host. > I see that MySQL listen on

Re: Not In join query.

2007-10-13 Thread Baron Schwartz
Hi Chris, Chris W wrote: I have 2 queries to give me a list of names. Q1: SELECT DISTINCT FName, LName FROM user u JOIN userprofile p USING ( UserID ) JOIN trainingstatus t USING ( UserID ) WHERE ProgramID =12 ORDER BY LName, FName Q2 SELECT DISTINCT FName, LName FROM namelist WHERE `Date` Wh

Res: MySQL only listens on localhost

2007-10-13 Thread Wagner Bianchi
After check the my.cnf, how said by friend Patricio, give the GRANT ALL ON *.* TO root@'%'; for thet user do the remote connections. For some doubts, keep on list! Bye! Wagner Bianchi Diretor de Tecnologia - INFODBA Technologies & Consulting [EMAIL PROTECTED] - +55 (31) 3272 - 0226 / 8427 - 8

Re: MySQL only listens on localhost

2007-10-13 Thread Patricio A. Bruna
Check for bind-address in your my.cnf file - "Franz Edler" <[EMAIL PROTECTED]> escribió: > Hello, > > Can anyone please give me a hint what I can do that MySQL also listens > to > the physical address of the host. > I see that MySQL listen only to 127.0.0.1:3306 and therefore every > connecti

MySQL only listens on localhost

2007-10-13 Thread Franz Edler
Hello, Can anyone please give me a hint what I can do that MySQL also listens to the physical address of the host. I see that MySQL listen only to 127.0.0.1:3306 and therefore every connection via the physical interface is reset. What can I do? Regards Franz -- MySQL General Mailing List For

CONCEPTS ABOUT PRIVILEGES!

2007-10-13 Thread Wagner Bianchi
Hi friends, This is the first time i post in this list and send a "hello" 4 all. I'm from Brazil. So, I have a doubt about the moment when u creat a new user. In my high-school course, my teacher is no good with MySQL and he said this: "When u create a new user, that don't have

Re: Query not returning Data

2007-10-13 Thread Brent Baisley
That is a string comparison, so they will never be equal. You don't have to put quotes around field names unless you are using reserved words, which you shouldn't. If you do use "quotes" around field names, you need to use `backticks`. On Oct 10, 2007, at 1:15 PM, Martijn Tonies wrote: