module install

am 14.12.2003 05:14:10 von Kermit Tensmeyer

how do I set up the grant privledges for the test dbs?
When I install any mysql related module,( DBD::mysql ) make test runs a
test that connects to the database using default parameters.

Normally MySql allows any anoymous user to connect to the test database
with a null password. But the root user (the primary user to install Perl
modules) is never anonymous, and it's password should not be left null.

Is there a way to execute an explict 'grant all' on test to
'root@localhost' identified with a null password?

----
kermit tensmeyer

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Success with DBD::mysql Install

am 15.12.2003 14:48:49 von brantzdr

Greetings:

I have installed DBD::mysql on RHEL AS 3 with no problems.

I re-installed the OS without the web server and mysql.

Ran up2date for RedHat, then installed perl 5.8.2. - rebooted.
Installed Apache2 web server and Mysql 4.0 from binary.
Installed DBI and DBD::mysql with no problems all tests passed.
Installed PHP 4.3.4 with axps and mysql.

Everything seems to be working I even got webalizer to work - very cool.

Thanks for all your help.

Douglas

--
Douglas R. Brantz
Computer Consultant
College of Fine & Applied Arts
Appalachian State University
Boone, NC 28608

828-262-6549 (phone)
828-262-6312 (fax)

-----Original Message-----
From: news [mailto:news@sea.gmane.org] On Behalf Of Kermit Tensmeyer
Sent: Saturday, December 13, 2003 11:14 PM
To: msql-mysql-modules@lists.mysql.com
Subject: module install

how do I set up the grant privledges for the test dbs?
When I install any mysql related module,( DBD::mysql ) make test runs a
test that connects to the database using default parameters.

Normally MySql allows any anoymous user to connect to the test database
with a null password. But the root user (the primary user to install
Perl
modules) is never anonymous, and it's password should not be left null.

Is there a way to execute an explict 'grant all' on test to
'root@localhost' identified with a null password?

----
kermit tensmeyer

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=brantzdr@appstate.edu

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Success with DBD::mysql Install

am 15.12.2003 14:48:49 von brantzdr

Data type conver in mysql

am 15.12.2003 15:27:16 von lshen

Hi! Dose anyone know how to conver (Oct 11 2003 12:30:11:000AM) into
datetime in MYSQL?

Thanks

Brian
----- Original Message -----
From: "brantzdr"
To:
Sent: Monday, December 15, 2003 8:48 AM
Subject: Success with DBD::mysql Install

> Greetings:
>
> I have installed DBD::mysql on RHEL AS 3 with no problems.
>
> I re-installed the OS without the web server and mysql.
>
> Ran up2date for RedHat, then installed perl 5.8.2. - rebooted.
> Installed Apache2 web server and Mysql 4.0 from binary.
> Installed DBI and DBD::mysql with no problems all tests passed.
> Installed PHP 4.3.4 with axps and mysql.
>
> Everything seems to be working I even got webalizer to work - very cool.
>
> Thanks for all your help.
>
> Douglas
>
> --
> Douglas R. Brantz
> Computer Consultant
> College of Fine & Applied Arts
> Appalachian State University
> Boone, NC 28608
>
> 828-262-6549 (phone)
> 828-262-6312 (fax)
>
>
>
> -----Original Message-----
> From: news [mailto:news@sea.gmane.org] On Behalf Of Kermit Tensmeyer
> Sent: Saturday, December 13, 2003 11:14 PM
> To: msql-mysql-modules@lists.mysql.com
> Subject: module install
>
>
> how do I set up the grant privledges for the test dbs?
> When I install any mysql related module,( DBD::mysql ) make test runs a
> test that connects to the database using default parameters.
>
> Normally MySql allows any anoymous user to connect to the test database
> with a null password. But the root user (the primary user to install
> Perl
> modules) is never anonymous, and it's password should not be left null.
>
>
> Is there a way to execute an explict 'grant all' on test to
> 'root@localhost' identified with a null password?
>
>
> ----
> kermit tensmeyer
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
> http://lists.mysql.com/perl?unsub=brantzdr@appstate.edu
>
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=lshen@pop900.gsfc.nasa.gov
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Data type conver in mysql

am 15.12.2003 15:27:16 von lshen

Re: Data type conver in mysql

am 16.12.2003 01:35:42 von Rudy Lippan

On Mon, 15 Dec 2003, lshen wrote:

> Hi! Dose anyone know how to conver (Oct 11 2003 12:30:11:000AM) into
> datetime in MYSQL?
>

You could look at perl modules like Time:Piece or maybe use Date::Calc
to play with the date, or look at the the mysql function docs to see if
there is a built-in that does what you are looking for.

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Data type conver in mysql

am 16.12.2003 01:35:42 von Rudy Lippan