Re: Making MySQL insecure on purpose...

2002-10-22 Thread Paul DuBois
Start the server with --skip-grant-tables. Than anyone can connect and do anything. At 20:32 -0700 10/22/02, Jim Hogan wrote: I have set up MySQl before and have done it "the right way" (I think!) My situation today? I am setting up MySQL on a Linux machine with a 1394- attached 80GB drive fo

RE: Making MySQL insecure on purpose...

2002-10-22 Thread Jim Hogan
ROGER! Thanks a lot. After updating with that GRANT I am now looking at the main DB in EpiInfo 2000 via ODBC (EpiInfostats and graphics on the cheap courtesy of CDC if anybody cares) Anyhow, it seems I was being too specific in my user name in the ODBC config (jim@somehost instead of jim) g

RE: Making MySQL insecure on purpose...

2002-10-22 Thread Roger Davis
Sounds like all is set up properly, but, have you give your mysql USERS permissions to connect from from the 192.168.1 network? The Really Insecure way of doing this is... GRANT ALL PRIVILEGES ON *.* TO mysqlusernamehere@"%" IDENTIFIED BY 'mypasswordhere'; FLUSH PRIVILEGES; Hope this helps Rog