Permission Problem in OS X

2004-01-22 Thread Dietrich Speer
I am having a problem with accessing the mysql database in a new MySQL installation on OS X Panther. This installation came with the original OS, and some configuration was done right after installation. I have previously installed MySQL on Linux and Win and have never encountered this problem. A

DSNless connection from ASP to Linux

2003-07-04 Thread Dietrich Speer
I am trying to to use a DSNless connection from an ASP script( on IIS5) to a MySQL db on Linux. I am trying this: strConnection=_ "driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o ption=NUM" Set adoDataConn = Server.CreateObject("ADODB.C

DSNless connection from ASP to Linux

2003-07-03 Thread Dietrich Speer
I am trying to to use a DSNless connection from an ASP script( on IIS5) to a MySQL db on Linux. I am trying this: strConnection=_ "driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o ption=NUM" Set adoDataConn = Server.CreateObject("ADODB.C

Random ID creation in MySQL /Linux

2003-01-19 Thread DIetrich Speer
Hello: I am trying to find a way to create a random ID for use as a session ID in a MySQL table. In MS SQL I use NewID(). Does anybody know an equivalent to use for MySQL, running on RedHat Linux 8.0? I'd be greatful for any tip. thks! Dietrich -

Newbie - Where do I look for answers?

2003-01-02 Thread DIetrich Speer
I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end f

Front end won't connect

2002-12-09 Thread DIetrich Speer
Question from a Linux and MySql newbie I just installed RedHat 8.0 and MySQL. During installation there was no prompt for any database server properties (hostname, user). Now I downloaded MySQLCC and try to configure the connection to the server. I assume the server is running, because I can star

Re: E-Commerce, db-clustering and MySQL?

2002-12-08 Thread Dietrich Speer
processor machines we should be fine without. > > > >Right now it's all theory, and there don't seem to be a lot of articles on > >the web about this. At least I had no luck finding any. > > > >Does anybody have real life experiences with this kind of a setu

Re: E-Commerce, db-clustering and MySQL? Thanks to all!

2002-12-08 Thread Dietrich Speer
Thanks to everybody who helped me with this! - Original Message - From: "Brian P. Austin" <[EMAIL PROTECTED]> To: "Dietrich Speer" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 9:01 AM Subject: RE: E-Commerce, db

E-Commerce, db-clustering and MySQL?

2002-12-07 Thread Dietrich Speer
les on the web about this. At least I had no luck finding any. Does anybody have real life experiences with this kind of a setup? Does anybody know where to find reports about this? I'd be greatful for any link or hint! Dietrich Speer ---