This is a good point, my last post was under the assumption that your ISP
did not firewall any ports, since you are on a static IP, that suggests a
server package with no restrictions on hosting. If so, and you are in fact
running the MySQL on the machine directly live on the internet with no
firewalling in occurance, Windows may still be the criminal, or at least the
Windows version of MySQL with it's default my.ini file.
If I've just been ranting uselessly, ignore me :)
-Shane
----- Original Message -----
From: "Primaria Falticeni" <[EMAIL PROTECTED]>
To: "Renato" <[EMAIL PROTECTED]>
Cc: "MySQL LIST" <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 12:42 PM
Subject: Re: Remote access to MySQL
> Yes, indeed. You don't have a firewall.
> But the firewall from the Internet Service Provider's computer prohibits
the
> access of the others users from the Internet to the port of your MySQL
> server. Or you are in a private network which must use IP port forwarding
to
> be reached from the Internet. Talk with your ISP to give all others, from
> the Internet, access to your MySQL port.
> The poor Windows is not guilty for this. It has too much guilty for the
> other problems...
>
> Good Luck,
>
> Iulian
>
> ----- Original Message -----
> From: "Renato" <[EMAIL PROTECTED]>
> To: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, June 17, 2003 9:11 PM
> Subject: RES: Remote access to MySQL
>
>
> > >> I have all privileges to all the databases and tables, with user
> 'root'.
> > >User 'root' likely doesn't have access from the desired IP.
> > >Users are configured by both name and approved hosts. Try this:
> > >GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
> > >Edward Dudlik
> > >Becoming Digital
> > >www.becomingdigital.com
> >
> >
> > I have all grant statements:
> > GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'password';
> > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password';
> > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY
'password';
> > FLUSH PRIVILEGES;
> >
> > Still not working...
> > Do you know if Win98 have some trouble receiving telnet commands?
> >
> > Thanks again.
> >
> > Regards,
> > Renato Uchoa
> > [EMAIL PROTECTED]
> >
> > ----- Original Message -----
> > From: "Renato" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, 15 June, 2003 19:28
> > Subject: Remote access to MySQL
> >
> >
> > I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
> >
> > In the same machine, works web server (Apache2+PHP) and e-mail e ftp
> server.
> >
> > Everything works perfectly accessing from my INTRANET (local network). I
> > obtain access to MySQL without problems.
> >
> > In Internet, all servers works perfect, except MySQL. Always I get error
> of
> > access when use:
> > > mysql - h xx.xx.xx.xx - u root - p
> > ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060)
> >
> > Informations:
> >
> > * I don't have any firewall
> > * I have all privileges to all the databases and tables, with user
'root'.
> > * I have pleny access to the 'server' machine.
> > * Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local
> > network, the reply is positive, what confirms server is on
> > * I work with PHP and I have access to Mysql with PHP programming, never
> > directly.
> > * I use 'mysqld.exe', as MySQL server, without any special configuration
> in
> > my.ini:
> > [WinMySQLAdmin]
> > Server=C:/MYSQL/bin/mysqld.exe
> > [mysqld]
> > basedir=C:/MYSQL
> > datadir=C:/MYSQL/data
> >
> > Summarizing: I can't access to the Mysql from Internet!
> >
> > Some additional suggestions?
> >
> > Regards,
> > Renato Uchoa
> > [EMAIL PROTECTED]
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
