Re: Inability to Connect django with MySQL database
This looks like your Mysql user can login without password in localhost (are you sure, your user has correct permissions?). Try to create a user with password and allow login from localhost, and change your django settings, also try to connect with your user with mysql client from localhost. El vie., 20 mar. 2020 a las 14:55, Victor () escribió: > What's the database variable in your settings.py file > > On Friday, March 20, 2020 at 2:54:05 PM UTC+1, Ifeanyi Chielo wrote: >> >> Hello, >> I am new to Python django, I have been making efforts to connect a django >> application to mysql without success. Bellow is the information that I got >> PS C:\Users\IFEANYI CHIELO\divine> python manage.py migrate >> Traceback (most recent call last): >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", >> line 216, in ensure_connection >> self.connect() >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", >> line 194, in connect >> self.connection = self.get_new_connection(conn_params) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py", >> line 227, in get_new_connection >> return Database.connect(**conn_params) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\__init__.py", >> line 84, in Connect >> return Connection(*args, **kwargs) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py", >> line 179, in __init__ >> super(Connection, self).__init__(*args, **kwargs2) >> MySQLdb._exceptions.OperationalError: (1045, "Access denied for user >> 'admin'@'localhost' (using password: NO)") >> >> The above exception was the direct cause of the following exception: >> >> Traceback (most recent call last): >> File "manage.py", line 15, in >> execute_from_command_line(sys.argv) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", >> line 381, in execute_from_command_line >> utility.execute() >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", >> line 375, in execute >> self.fetch_command(subcommand).run_from_argv(self.argv) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", >> line 316, in run_from_argv >> self.execute(*args, **cmd_options) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", >> line 350, in execute >> self.check() >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", >> line 379, in check >> include_deployment_checks=include_deployment_checks, >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\commands\migrate.py", >> line 59, in _run_checks >> issues = run_checks(tags=[Tags.database]) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\checks\registry.py", >> line 71, in run_checks >> new_errors = check(app_configs=app_configs) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\checks\database.py", >> line 10, in check_database_backends >> issues.extend(conn.validation.check(**kwargs)) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\validation.py", >> line 9, in check >> issues.extend(self._check_sql_mode(**kwargs)) >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\validation.py", >> line 13, in _check_sql_mode >> with self.connection.cursor() as cursor: >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", >> line 255, in cursor >> return self._cursor() >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", >> line 232, in _cursor >> self.ensure_connection() >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", >> line 216, in ensure_connection >> self.connect() >> File "C:\Users\IFEANYI >> CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.py", >> line 89, in __exit__ >> raise dj_exc_value.with_traceback(traceback) from exc_value >> File "C:\Users\IFEANYI >>
Re: Inability to Connect django with MySQL database
What's the database variable in your settings.py file On Friday, March 20, 2020 at 2:54:05 PM UTC+1, Ifeanyi Chielo wrote: > > Hello, > I am new to Python django, I have been making efforts to connect a django > application to mysql without success. Bellow is the information that I got > PS C:\Users\IFEANYI CHIELO\divine> python manage.py migrate > Traceback (most recent call last): > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", > > line 216, in ensure_connection > self.connect() > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", > > line 194, in connect > self.connection = self.get_new_connection(conn_params) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py", > > line 227, in get_new_connection > return Database.connect(**conn_params) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\__init__.py", > > line 84, in Connect > return Connection(*args, **kwargs) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py", > > line 179, in __init__ > super(Connection, self).__init__(*args, **kwargs2) > MySQLdb._exceptions.OperationalError: (1045, "Access denied for user > 'admin'@'localhost' (using password: NO)") > > The above exception was the direct cause of the following exception: > > Traceback (most recent call last): > File "manage.py", line 15, in > execute_from_command_line(sys.argv) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", > > line 381, in execute_from_command_line > utility.execute() > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", > > line 375, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", > > line 316, in run_from_argv > self.execute(*args, **cmd_options) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", > > line 350, in execute > self.check() > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", > > line 379, in check > include_deployment_checks=include_deployment_checks, > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\commands\migrate.py", > > line 59, in _run_checks > issues = run_checks(tags=[Tags.database]) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\checks\registry.py", > > line 71, in run_checks > new_errors = check(app_configs=app_configs) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\checks\database.py", > > line 10, in check_database_backends > issues.extend(conn.validation.check(**kwargs)) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\validation.py", > > line 9, in check > issues.extend(self._check_sql_mode(**kwargs)) > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\validation.py", > > line 13, in _check_sql_mode > with self.connection.cursor() as cursor: > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", > > line 255, in cursor > return self._cursor() > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", > > line 232, in _cursor > self.ensure_connection() > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", > > line 216, in ensure_connection > self.connect() > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.py", > > line 89, in __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", > > line 216, in ensure_connection > self.connect() > File "C:\Users\IFEANYI > CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", > > line 194, in connect > self.connection = self.get_new_connection(conn_params) > File "C:\Users\IFEANYI >
Inability to Connect django with MySQL database
Hello, I am new to Python django, I have been making efforts to connect a django application to mysql without success. Bellow is the information that I got PS C:\Users\IFEANYI CHIELO\divine> python manage.py migrate Traceback (most recent call last): File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", line 194, in connect self.connection = self.get_new_connection(conn_params) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py", line 227, in get_new_connection return Database.connect(**conn_params) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\__init__.py", line 84, in Connect return Connection(*args, **kwargs) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py", line 179, in __init__ super(Connection, self).__init__(*args, **kwargs2) MySQLdb._exceptions.OperationalError: (1045, "Access denied for user 'admin'@'localhost' (using password: NO)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "manage.py", line 15, in execute_from_command_line(sys.argv) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line utility.execute() File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", line 316, in run_from_argv self.execute(*args, **cmd_options) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", line 350, in execute self.check() File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\base.py", line 379, in check include_deployment_checks=include_deployment_checks, File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\commands\migrate.py", line 59, in _run_checks issues = run_checks(tags=[Tags.database]) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\checks\registry.py", line 71, in run_checks new_errors = check(app_configs=app_configs) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\checks\database.py", line 10, in check_database_backends issues.extend(conn.validation.check(**kwargs)) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\validation.py", line 9, in check issues.extend(self._check_sql_mode(**kwargs)) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\validation.py", line 13, in _check_sql_mode with self.connection.cursor() as cursor: File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor return self._cursor() File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor self.ensure_connection() File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\base\base.py", line 194, in connect self.connection = self.get_new_connection(conn_params) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\backends\mysql\base.py", line 227, in get_new_connection return Database.connect(**conn_params) File "C:\Users\IFEANYI CHIELO\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\__init__.py", line 84, in Connect return Connection(*args, **kwargs) File "C:\Users\IFEANYI