Search code examples
mysqlsqitch

MySQL User Permission Errors using Sqitch on Ubtunu

I am running into what I think is a very easy issue to fix, I am just out of possible ideas.

I have a brand new Ubuntu 14.04 x64 server. I just installed MySQL. Not Apache, php or phpMyAdmin, just plain MySQL.

I have run through mysql_secure_installation and created a password for my root user.

I then put my root password in the /etc/mysql/my.cnf file under the [client] section.

I can run mysql -u root and get to the MySQL console just fine.

However, if I run sqitch deploy I get:
Access denied for user 'root'@'localhost' (using password: NO)

Sqitch is pointing to: 

[target "database name_v1"]
uri = db:mysql://root@/databasename_v1
[engine "mysql"]
target = db:mysql://root@/databasename_v1

EDIT

It turns out the problem was with Sqitch and my configuration. Sqitch is a Perl application and needed the perl module MySQL Config in order to read the my.cnf file and access the database.

Solution

  • It turns out the problem was with Sqitch and my configuration. Sqitch is a Perl application and needed the perl module MySQL::Config in order to read the my.cnf file and access the database.