[SOLVED] django mariadb connection error : 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

shams · 07-13-2021, 11:42 PM

When i run the django server it runs succesfully:

Code:

# python manage.py runserver 192.168.1.100:8083
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
July 14, 2021 - 09:01:40
Django version 3.2.5, using settings 'CSCdropdown.settings'
Starting development server at http://192.168.1.100:8083/
Quit the server with CONTROL-C.

now when open the http://192.168.1.100:8083/ in firefox get the error:

Code:

ProgrammingError at /
1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Request Method:	GET
Request URL:	http://192.168.1.100:8083/
Django Version:	3.2.5
Exception Type:	ProgrammingError
Exception Value:	
1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Exception Location:	/usr/lib/python3.9/site-packages/mysql/connector/connection.py, line 276, in _auth_switch_request
Python Executable:	/usr/bin/python

This is settings.py for mariadb database connection:

Code:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'test',
        'USER': 'root',
        'PASSWORD': '12345',
        'HOST': 'localhost',
        'PORT': '8083',
    }
}

I also gave the 'root'@'localhost' gran access to all mariadb databases.

bathory · 07-14-2021, 12:44 AM

Quote:

This is settings.py for mariadb database connection:
Code:

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'test',
'USER': 'root',
'PASSWORD': '12345',
'HOST': 'localhost',
'PORT': '8083',
}
}

I'm not familiar with django, but I guess in the above config file, the PORT should be the mysql/mariadb port, that is 3306 (by default)

shams · 07-14-2021, 01:05 AM

when i use the port 3306 get the error:

Code:

# python manage.py runserver 192.168.1.100:3306
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
July 14, 2021 - 10:34:02
Django version 3.2.5, using settings 'CSCdropdown.settings'
Starting development server at http://192.168.1.100:3306/
Quit the server with CONTROL-C.
Error: That port is already in use.

bathory · 07-14-2021, 01:24 AM

Quote:

Originally Posted by shams

when i use the port 3306 get the error:

Code:

# python manage.py runserver 192.168.1.100:3306
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
July 14, 2021 - 10:34:02
Django version 3.2.5, using settings 'CSCdropdown.settings'
Starting development server at http://192.168.1.100:3306/
Quit the server with CONTROL-C.
Error: That port is already in use.

The port 3306 is the mysql port, used to connect to the database server!
If your project is running on port 8083 as in your OP, you should use:

Code:

python manage.py runserver 192.168.1.100:8083