Assume you want to access remote database on your Django application
Suppose
Your system IP is : 192.10.10.111 (or) localhost
Your friends system IP is : 192.10.10.222
Run your Django application with local database:
DATABASES = {
'default': {
'HOST': '192.10.10.111 ', #(or) localhost
'ENGINE': 'django.db.backends.mysql',
'NAME': '111_test_db' ,
'USER': '111_user',
'PASSWORD': 'XXX'
}
}
Run your Django application with remote database:
DATABASES = {
'default': {
'HOST': '192.10.10.222',
'ENGINE': 'django.db.backends.mysql',
'NAME': '222_test_db',
'USER':'222_user',
'PASSWORD':'YYY'
}
}
When accessing remote database for yout django application, you need Grant Permissions on Remote Database for initiating HOST user
E.g., In the remote database '222_test_db' (Login)
grant all privileges on *.* to 111_user@192.10.10.111 identified by 'XXX' with grant option;
The above command gives/grants enough permissions to the 111_user to access 222_test_db, else "Permission Denied" error is shown.
Reload Apache:
service httpd restart
Suppose
Your system IP is : 192.10.10.111 (or) localhost
Your friends system IP is : 192.10.10.222
Run your Django application with local database:
DATABASES = {
'default': {
'HOST': '192.10.10.111 ', #(or) localhost
'ENGINE': 'django.db.backends.mysql',
'NAME': '111_test_db' ,
'USER': '111_user',
'PASSWORD': 'XXX'
}
}
Run your Django application with remote database:
DATABASES = {
'default': {
'HOST': '192.10.10.222',
'ENGINE': 'django.db.backends.mysql',
'NAME': '222_test_db',
'USER':'222_user',
'PASSWORD':'YYY'
}
}
When accessing remote database for yout django application, you need Grant Permissions on Remote Database for initiating HOST user
E.g., In the remote database '222_test_db' (Login)
grant all privileges on *.* to 111_user@192.10.10.111 identified by 'XXX' with grant option;
The above command gives/grants enough permissions to the 111_user to access 222_test_db, else "Permission Denied" error is shown.
Reload Apache:
service httpd restart
No comments:
Post a Comment