I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like
sql_alchemy_conn=mysql+mysqldb://my_user:[email protected]/my_db but I get an error saying access denied for user [email protected]. I can connect perfectly to the database via command line MySQL -u my_user -p -h 10.55.1.95 -P 3306 my_db. How do I solve this connection string issue? I have the my_user setup to allow all hosts %

I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like
sql_alchemy_conn=mysql+mysqldb://my_user:[email protected]/my_db but I get an error saying access denied for user [email protected]. I can connect perfectly to the database via command line MySQL -u my_user -p -h 10.55.1.95 -P 3306 my_db. How do I solve this connection string issue? I have the my_user setup to allow all hosts %

I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like
sql_alchemy_conn=mysql+mysqldb://my_user:[email protected]/my_db but I get an error saying access denied for user [email protected]. I can connect perfectly to the database via command line MySQL -u my_user -p -h 10.55.1.95 -P 3306 my_db. How do I solve this connection string issue? I have the my_user setup to allow all hosts %

I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like
sql_alchemy_conn=mysql+mysqldb://my_user:[email protected]/my_db but I get an error saying access denied for user [email protected]. I can connect perfectly to the database via command line MySQL -u my_user -p -h 10.55.1.95 -P 3306 my_db. How do I solve this connection string issue? I have the my_user setup to allow all hosts %