Trouble Installing DBD::mysql

Question

I'm attempting to install DBD::mysql, and it's failing because it cannot log into the SQL server. I have put a my.cnf in /root for the duration of the installation. I can't log in specifying mysql without '-p'. However, I can do this with a non-root account that has a my.cnf in place. I'm assuming the my.cnf would let the CPAN tests log in, which is the cause of the installation failure.

I don't want to force install this module, and I am not quite sure how to get this to install properly.

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

See DBD::mysql::INSTALL:

Environment Variables

For ease of use, you can set environment variables for DBD::mysql installation. You can set any or all of the options, and export them by putting them in your .bashrc or the like:

The relevant ones are:

export DBD_MYSQL_TESTDB=test
export DBD_MYSQL_TESTHOST=localhost
export DBD_MYSQL_TESTPASSWORD=s3kr1+
export DBD_MYSQL_TESTPORT=3306
export DBD_MYSQL_TESTUSER=me

Of course, customize the values for your situation.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 9, 2014 at 15:48

Sinan Ünür

118k15 gold badges201 silver badges347 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trouble Installing DBD::mysql

1 Answer 1

Environment Variables

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Environment Variables

Comments

Your Answer

Sign up or log in

Post as a guest

Related