Connect Django to MySql database on VPS

Question

I am trying to run my Django project on a VPS. My Django project uses MySQL. While running it on my local computer I used the following code to connect MySQL to Django

 DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.mysql',
    'NAME': 'db_name',
    'USER': 'root',
    'PASSWORD': 'password',
    'HOST': 'localhost',
    'PORT': 3306}
}

What must be the 'USER','HOST','PORT' here while connecting to MySQL?

Just imagine you're connected to your VPS, what configuration would you use? — GTBebbo, Dec 23 '20 at 11:52

score 0 · Answer 1 · answered Dec 23 '20 at 11:53

If you are running the mysql server on the same machine as the vps then most likely your connection details will remain the same. The only difference being the username and the password.

If you need help installing mysql checkout this tutorial on digital ocean for basic steps to get you pointed in the right direction.

If you are using a cloud sql solution the connection details will be present in the sql control pane for the solution you are using.

Connect Django to MySql database on VPS

1 Answers1