How to use mysql-connector mysql adapter with django??/

Question

I cannot use mysqlclient package in the hosting server because it is a shared hosting server and they would not let me have a root privilige!! so I found about the mysql-connector adapter, I guess it is developed by MySQL but I could not find anyone using it to connect to the database, does someone know how to use it?? please help

Darsh Modi · Accepted Answer · 2020-12-18 13:04:31Z

0

First of all you have to run the command pip install mysqlclient after that change your settings.py file with this code.

DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'DB_NAME', 'USER': 'root', 'PASSWORD': 'root', 'HOST': 'Your host', 'PORT': 3306 } }
I think it should work for you. But would like to inform you that some of the hosting servers mostly support the Postgresql rather than the MySQL DB.

answered Dec 18, 2020 at 13:04

Darsh Modi

2981 silver badge9 bronze badges

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

2 Comments

Omar Redwan Over a year ago

They would not let met have root access so I cannot install mysqlclient

Darsh Modi Over a year ago

No, there is no need to access the root to install the mysqlclient you only need to do is that just run pip install mysqlclient in your terminal from any code editor you use, I personally prefer pycharm for django projects.

Collectives™ on Stack Overflow

How to use mysql-connector mysql adapter with django??/

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related