Bug #65604 DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' fo
Submitted: 13 Jun 2012 16:39 Modified: 15 Feb 2013 16:37
Reporter: Michael Jurgens Email Updates:
Status: Unsupported Impact on me:
None 
Category:Connectors: DBD::mysql ( Perl ) Severity:S1 (Critical)
Version:4.020, 4.021 OS:Any (Mac OS X, FC14)
Assigned to: CPU Architecture:Any
Tags: DBD::mwsql denied to user make test

[13 Jun 2012 16:39] Michael Jurgens
Description:
WHen Installing the DBD-mysql-4.021 Module errors stop the bundle from installing during make test stage

How to repeat:
Commands Ran From my Mac OS X directory:   /Users/Dad/PERL/myModules/DBD-mysql-4.021

1) perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
          seems to run fine, had some issues here but with a link creation this was solved:
          cd /usr/lib; sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib .

2) make
          seems to run find

3) make test, this is where the issues occur:

~/PERL/myModules/DBD-mysql-4.021 > make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t .................. ok   
t/10connect.t ............... ok   
t/20createdrop.t ............ ok   
t/25lockunlock.t ............ ok     
t/29warnings.t .............. ok   
t/30insertfetch.t ........... ok     
t/31insertid.t .............. ok     
t/32insert_error.t .......... ok   
t/35limit.t ................. ok       
t/35prepare.t ............... ok     
t/40bindparam.t ............. ok     
t/40bindparam2.t ............ ok     
t/40blobs.t ................. ok     
t/40catalog.t ............... ok     
t/40keyinfo.t ............... ok   
t/40listfields.t ............ ok     
t/40nulls.t ................. ok     
t/40nulls_prepare.t ......... ok     
t/40numrows.t ............... ok     
t/40server_prepare.t ........ ok     
t/40server_prepare_error.t .. ok   
t/40types.t ................. ok    
t/41bindparam.t ............. ok     
t/41blobs_prepare.t ......... ok     
t/42bindparam.t ............. ok     
t/50chopblanks.t ............ ok     
t/50commit.t ................ ok     
t/51bind_type_guessing.t .... ok     
t/52comment.t ............... ok     
t/53comment.t ............... ok     
t/55utf8.t .................. ok     
t/60leaks.t ................. skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types.t ................. ok     
t/70takeimp.t ............... ok     
t/71impdata.t ............... ok     
t/75supported_sql.t ......... ok     
t/76multi_statement.t ....... 1/25 # Testing multicall against SQL_DBMS_VER: 5.5.25
t/76multi_statement.t ....... ok     
t/80procs.t ................. 1/29 DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' for routine 'test.testproc' at t/80procs.t line 47.
DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' for routine 'test.testproc' at t/80procs.t line 47.
# Looks like you planned 29 tests but ran 2.
# Looks like your test exited with 255 just after 2.
t/80procs.t ................. Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 27/29 subtests 
t/85init_command.t .......... ok   
t/86_bug_36972.t ............ ok     

Test Summary Report
-------------------
t/80procs.t               (Wstat: 65280 Tests: 2 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 29 tests but ran 2.
Files=40, Tests=863,  9 wallclock secs ( 0.23 usr  0.13 sys +  2.73 cusr  0.45 csys =  3.54 CPU)
Result: FAIL
Failed 1/40 test programs. 0/863 subtests failed.
make: *** [test_dynamic] Error 255
~/PERL/myModules/DBD-mysql-4.021 >
[14 Jun 2012 6:35] Valeriy Kravchuk
Thank you for the problem report. Verified on 64-bit Fedora Core 14 also.
[19 Dec 2012 22:09] zhen Fu
Hey, Did you figure out what was wrong with your installation?
I am having the same issue here.
[15 Feb 2013 16:37] Sveta Smirnova
Thank you for the report.

We don't work on DBD::mysql bugs anymore. All its bugs should go to CPAN: https://rt.cpan.org/Public/Dist/Display.html?Name=DBD-mysql

I re-submitted your report to https://rt.cpan.org/Public/Bug/Display.html?id=83348
Please subscribe to the new report on CPAN and work with DBD::mysql developers in case if they need additional details.