MySQL + MySQLDB + Django

[sacker]

Hello,

I was having a hard time finding information on this so I am posting this in case other people have the issue also.

The issue was that MySqlDb was trying to use /var/run/mysql/mysqld.sock to connect with. However it seems directadmins defaults it to /tmp/mysql.sock. It took me awhile to figure out how to change this with Django.

My method of getting around the issue is editing my.cnf with

[client]
socket = /tmp/mysql.sock

I am still not sure where directadmin hides the mysql config file.

Also within Django settings for the project you are working with you use.

DATABASE_OPTION = { 'read_default_file': '/path/to/my.cnf', }

If I knew where directadmin stores the my.cnf for mysql per user or global I would use that path and not need to edit /etc/my.cnf.

Hope this helps someone else

Thanks,
Sacker

 

[floyd]

If I knew where directadmin stores the my.cnf for mysql per user or global I would use that path and not need to edit /etc/my.cnf.

DirectAdmin has nothing to do with the my.cnf file. It does not use it, create it, or manage it.