Unable to connect to sql server on Ubuntu after MySQLAlchemy connection
0
votes
0
answers
205
views
**Context:**
I have installed mysql-server on Ubuntu and was able to setup password for root account and also created a few accounts with all privileges. I was able to connect to any user or the root user using the usual
mysql -uroot -p
I enter my password and I connect to the databases.
**Issue:**
I have a python flask application that uses SQLAlchemy to connect to the database using a username that I created, with a password. That user has all privileges. After I ran my application, I am UNABLE to connect to any user account from the terminal but the SQLAlchemy connection works fine via the flask application.
**Fixes tried**
- I tried restarting the mysql service.
- Turned off the flask application.
- I tried restarting the linux host.
I need to fix this issue and be able to connect to the mysql database from terminal as well as from the application (currently only application connects to the database).
Asked by Rookie_Coder2318
(1 rep)
Oct 27, 2022, 06:45 AM