Re: MySQL

Hi Sherm, Thanks for the advice. I am using the standard Perl install, so I will go with fink. Thanks, Mark On Dec 11, 2004, at 12:12 AM, Sherm Pendley wrote: On Dec 9, 2004, at 2:49 PM, Mark Wheeler wrote: 1. First, I'll check the archives on installing DBD::mysql. Then I'll actually install My

Re: MySQL

On Dec 9, 2004, at 2:49 PM, Mark Wheeler wrote: 1. First, I'll check the archives on installing DBD::mysql. Then I'll actually install MySQL using Sherm's link. One question regarding that. Which would be the best to install? There are three versions - Standard, Max, and Debug. I'm presuming Sta

Re: MySQL

On Thu, Dec 09, 2004 at 10:10:04PM +0900, Joel Rees wrote: > Paul DuBois's books on MySQL have been pretty good for me. I got a lot > out of the one called, I think, Perl and MySQL for the Web. I would also recommend his MySQL Cookbook from ORA. Very helpful. dha -- David H. Adler - <[EMAIL PR

Re: MySQL

Hi all, Thanks so much for your input. I think my plan of attack, for now is as follows. 1. First, I'll check the archives on installing DBD::mysql. Then I'll actually install MySQL using Sherm's link. One question regarding that. Which would be the best to install? There are three versions -

Re: MySQL

Sherm Pendley wrote: On Dec 9, 2004, at 2:55 AM, Mark Wheeler wrote: I guess what I'm asking is, can some one share some good links/pointers on installing MySQL. As well, links on USING MySQL with Perl. Check the archives - installing DBD::mysql is the hard part. Indeed! I think I've finally mem

Re: MySQL

On Thu, 9 Dec 2004 22:10:04 +0900, Joel Rees <[EMAIL PROTECTED]> wrote: > Paul DuBois's books on MySQL have been pretty good for me. I got a lot > out of the one called, I think, Perl and MySQL for the Web. > > It's been over a year, but the MySQL lists seemed to be a lot of help: > > http://mar

Re: MySQL

Paul DuBois's books on MySQL have been pretty good for me. I got a lot out of the one called, I think, Perl and MySQL for the Web. It's been over a year, but the MySQL lists seemed to be a lot of help: http://marc.theaimsgroup.com/?l=mysql&r=1&w=2 (These days I seem to be messing around with Pos

Re: MySQL

On Thu, Dec 09, 2004 at 09:35:34AM +0100, Christian Schneider wrote: On Wed, Dec 08, 2004 at 11:55:57PM -0800, Mark Wheeler wrote: Hi, Well, I'm about to take the plunge and begin to learn MySQL. I have Apache and Perl all running great (stock installs), but I'm not sure how to get started with i

Re: MySQL

On Dec 9, 2004, at 2:55 AM, Mark Wheeler wrote: I guess what I'm asking is, can some one share some good links/pointers on installing MySQL. Link: Pointer: Download the installer. Run it. As well, links on USING MySQL with Perl. Check the archives -

Re: MySQL

On Wed, Dec 08, 2004 at 11:55:57PM -0800, Mark Wheeler wrote: > Hi, > > Well, I'm about to take the plunge and begin to learn MySQL. I have > Apache and Perl all running great (stock installs), but I'm not sure > how to get started with installing MySQL. I guess what I'm asking is, > can some o

Re: MySQL and DBI: (not) making connection

At 10:32 PM -0500 11/22/02, Tom McDonough wrote: I have mysql v3.23.53 running on OS X.2 and can access it from terminal but I'm trying to use the DBI (DBI-1.30) and DBD (DBD-mysql-2.1020) to access it through cgi scripts. I've been getting all sorts of 'access denied' errors. Now I've got one t

Re: MySQL data files HERE!

I just wanna chime in here with a quick explanation of what is going on, so that it doesn't seem so arbitrary. In the public beta, the root password was set to be the same as the first user you created. This is bad for a number of reasons, but this is why you could use 'su' with your own passwor

Re: MySQL data files where?

on 6/29/01 10:20 AM, Nelson Goforth at [EMAIL PROTECTED] wrote: > I'm running MySQL on OS X and have just tried writing to an OUTFILE, > but I can't get to it. > > I guessed it was in the directory /usr/local/var but I couldn't 'cd' > to that directory (permission denied), even using the comman

Re: MySQL data files HERE!

Answering my own question... Since I wasn't getting anywhere with 'su' - I thought to try: sudo su And it worked! Just used my 'admin' password (don't have root enabled) and I was in like Flynn. Whoever that was. Thanks for the assistance. I've been using Unix (mostly perl) for a seve

Re: MySQL data files where?

[EMAIL PROTECTED] (Nelson Goforth) wrote: >I tried using 'su' as you suggested. It prompts me for a password >and I used the same one that I created initially to set up my admin >account (I have not enabled root) - which I have used to install >software using 'sudo' - however I get the respons

Re: MySQL data files where?

Thank you. /usr/local/var does indeed exist - perhaps it was created during the MySQL setup (all of the files in it -- using 'sudo ls...' -- are MySQL files). I want to be able to get to this file (and the directory) so that I can create a file directly from MySQL (or read one in from a tab-

Re: mysql - dbi - apache

At 08:07 PM 2001.05.13 +0200, allan wrote: >to be honest ive lost track of all the different users on osX > >there are normal system-login users like me: username=aju >there are an apache user: username=??? Check your httpd.conf file; it defines which user Apache runs as: 12:57:04pm :chris% egr

Re: mysql - dbi - apache

[EMAIL PROTECTED] (allan) wrote: >my guess is that youre right - access denied according to the error_log >but to be honest ive lost track of all the different users on osX > >there are normal system-login users like me: username=aju >there are an apache user: username=??? >there are an mysql use

Re: mysql - dbi - apache

thanks for the reply ken Ken Williams wrote: > My guess is that it's attempting to connect as the user you've got > Apache set up to run under. my guess is that youre right - access denied according to the error_log but to be honest ive lost track of all the different users on osX there are n

Re: mysql - dbi - apache

Hi, There should be a message in the error log telling you what went wrong. If not, you may have to change the connection call to my $dbh = DBI->connect("DBI:mysql:database=lps;host=localhost","", "", {'RaiseError' => 1}) or die $DBI::errstr; That's always a good idea anyway (but perhaps s