RE: I am trying to connect to a MySql Database across the network
"Bronto" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Well, I guess you used "grant all privileges on 'justin' to 'justin'@'localhost' identified by 'password'" when you've setup the permissions. It should have been something like: "grant all privileges on 'justin' to 'justin'@'192.168.0.10' identified by 'password'" where 192.168.1.10 is your workstation IP If you want to access the database from all the workstations on your LAN, use: "grant all privileges on 'justin' to 'justin'@'192.168.0.%' identified by 'password'" Hope it helps, Bronto -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.3/699 - Release Date: 23-02-2007 13:26