Forums » Help »
Can't access MySQL with Redmine 3.2
Added by Ron Wurzberger over 8 years ago
I installed Redmine 3.2.0-2 on CentOS 6.6 using the bitnami-redmine-3.2.0-2-linux-x64-installer.run file using all defaults to questions. It installed and uses mysql, but I can't seem to access it myself. I tried to list the values of all the mysql variables so I could debug the problem and got the following...
- mysqladmin variables
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Using "ps -A | grep -i mysql" I see a process called 'mysqld.bin' and the mysql.sock file is in the default bitnami-redmine path /opt/redmine-3.2.0-2/mysql/tmp/mysql.sock.
I am unable to backup my Redmine database or access it outside of Redmine. In such a case, how do I backup and restore my Redmine database? No MySQL related command line commands can make a connection.
I figured out what I need to do. By using the single file installer, a standalone instance of Bitnami-Redmine was created. The default path is /opt/redmine-3.2.0-2/ and the mysql stuff is installed in a subfolder called 'mysql'. The MySQL command line tools I needed to use are located in /opt/redmine-3.2.0-2/mysql/bin. They are the same as the normal MySQL command line tools, but running them from that folder allows you to access the database in the standalone Redmine instance.