-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2005-11-15 at 20:54 -0800, Scott Leighton wrote:
Try using the ip number of your local machine instead of localhost. I couldn't connect here with localhost, but could by using the machine's ip 192.168.1.2 ( I have a suspicion that my mysql install doesn't listen on localhost, but uses sockets instead, maybe that's why).
Ah! Yes, I get something different now: SQL Status: 28000 Error code: 1045 Access denied for user 'cer'@'nimrodel.valinor' (using password: YES) which is weird. Very weird, that same password works with phpmyadmin. nimrodel:~ # netstat -A inet -l |egrep mysql tcp 0 0 nimrodel.valinor:mysql *:* LISTEN nimrodel:~ # netstat -A inet -n -l |egrep 3306 tcp 0 0 192.168.100.2:3306 0.0.0.0:* LISTEN Ah! User "cer" in mysql is defined for "localhost", not the full name... lets change it. [...] Yes, I can access it using OOo now. Bingo! Rekall doesn't seem to complain with the change, nor phpmyadmin. Weird! Why did it work previously? What changed? Now I have a different problem... I try to create a Table_view (with a single field, for just testing), and it will not save (although it displays correctly): SQL Status: 42000 Error code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW `View1` AS SELECT `Titulo` FROM `Libros` `Libros`' at line 1 I use rekall or OOo because I have no idea at all of sql; now it seems that OOo creates broken SQL! Then I got instead a Query/view - but it seems I can not add data to the database through a query-view; my tables are linked, so I need to indicate the relationships, but if I do then I can not add data... too bad, it is unworkable, I wanted a functionality like "access". I can do it with rekall, though. Arghh! I wonder if there is a manual on using OOo with mysql... - -- Cheers, Carlos Robinson -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFDe+DdtTMYHG2NR9URAg8IAJ9PIDhpV89SrVUUudFpYPN41/mPuACeL1TG gZGjRWfegM1PgV8LGJ2pDf4= =Q5nC -----END PGP SIGNATURE-----