from windows to MySql Linux

Stig Johansen

Delphi Developer

Wed, 26 Jan 2005 14:29:46 GMT

from windows to MySql Linux

Hi.

Quote

"Joost" <j...@pandora.be> wrote in message news:3d53c32e_1@dnews...
> Hi,

> Having done some testing on windows everything works fine.
> After installing a brand new RedHat 7.3 with mysql 3.23.49 included the
> server works fine local.

> When connecting to the server from a windows pc i can't connect
> ERROR 1130: Host 'joost.mshome.net' is not allowed to connect to this
MySQL
> server

You might check your overall security settings on your Linux box.

On my SuSE, no one has acces by deafult, not even LAN users.

Med venlig hilsen/Best regards
Stig Johansen
Stig.Johan...@udvikling.it.dk
(remove dot dk)

Joos

Delphi Developer

Thu, 27 Jan 2005 18:06:32 GMT

Re:from windows to MySql Linux

Hi,

finaly found it...

mysql> grant all privileges on *.* to someusr@"%" identified by 'passwrd';
replacing by grant all privileges on *.* to ODBC@"%" identified by
'passwrd';
works fine,
strange, using %,% did not work...

tenksalot,
jst.

"Stig Johansen" <stig.johan...@udvikling.it> schreef in bericht
news:3d54b197_1@dnews...

Quote

> Hi.

> "Joost" <j...@pandora.be> wrote in message news:3d53c32e_1@dnews...
> > Hi,

> > Having done some testing on windows everything works fine.
> > After installing a brand new RedHat 7.3 with mysql 3.23.49 included the
> > server works fine local.

> > When connecting to the server from a windows pc i can't connect
> > ERROR 1130: Host 'joost.mshome.net' is not allowed to connect to this
> MySQL
> > server

> You might check your overall security settings on your Linux box.

> On my SuSE, no one has acces by deafult, not even LAN users.

> --

> Med venlig hilsen/Best regards
> Stig Johansen
> Stig.Johan...@udvikling.it.dk
> (remove dot dk)

Other Threads

1. Mysql Server in Linux with aplication runing in Windows

2. MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

3. Cannot connect to MySQL Server in Linux?

4. How to access mySQL on Linux from D5 app

5. MySQL vs. IB 4.0 running on Linux comparison

6. Linux MySQL data connection via ODBC From Delphi 3

7. Interbase or MySQL on SMP Linux box ?

8. connect to remote Mysql DB on Linux

9. Linux DB Express Library for MySQL 4.1

10. dbExpress WILL NOT connect to a remote mysql (linux) server