Software DB Demo.rev & MySQL

[Sarah]

One more idea Howard. As you say, it may be firewall setting, but it 
could also be a MySQL permission setting. As I understand it, when you 
set up permissions (using GRANT), you have to give a domain, IP address 
or range where that person will be logging in from. I wonder could that 
be the problem.

Sarah

On Monday, July 7, 2003, at 09:24  am, howard freeman wrote:

> Hi Sarah nad list
> Thanks for the stacks - I picked them up and tried them with no luck: 
> I get a Rev error of (60) saying Rev can't connect to the MySQL 
> server. However, MySQL is happily serving tot he web just fine. I used 
> the MySQL root password and the user password, with the same result. 
> It is possible that the port that MySQL works through, 3306, is 
> blocked by the firewall, so I'll just have to get it opened and see if 
> things work better.
>
> If it's the firewall that's stopping things then I'll report back. One 
> other point (this addressed to Rev authors) is that finding out about 
> the use of the MySQL commands would have been a lot easier if they had 
> been documented as a group rather than individually.
>
> Howard
>
> At 5:51 pm -0400 6/7/03, use-revolution-request at lists.runrev.com wrote:
>> Message: 18
>> Date: Mon, 07 Jul 2003 08:29:03 +1000
>> From: Sarah <sarahr at genesearch.com.au>
>> Subject: Re: Software DB Demo.rev & MySQL
>> To: use-revolution at lists.runrev.com
>> Reply-To: use-revolution at lists.runrev.com
>>
>> Hi Howard,
>>
>> localhost is what you use if the MySQL server is running on your own
>> computer. If it is on a remote computer, then you need to know the IP
>> address. You shouldn't need to use sockets directly. Rev handles all
>> that stuff for you in the database routines.
>>
>> Have a look at the 2 MySQL stacks available on my web site. I have 
>> used
>> them to connect to local and remote servers without any problems.
>>
>> Cheers,
>> Sarah
>> sarahr at genesearch.com.au
>> http://www.troz.net/Rev/
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>
>