1

I installed HeidiSQL to use MariaDB. When HeidiSQL created and opened a session, the following message appeared.

/ * Start "MyDB" session * /
/ * Access denied * /

Access was denied, but basic SQL was available.

Environment: Win10 x64, MariaDB 10.3, HeidiSQL 9.5.0.5196

Can anyone help me in fixing this?

Sudarshana Dayananda
  • 5,165
  • 2
  • 23
  • 45
Day Break
  • 88
  • 10

1 Answers1

2

I recommend updating to the most recent version since yours is outdated.

A similar problem has been answered in the following question https://stackoverflow.com/a/51494222/10820177

Basically, "Access denied" errors tell you are able to establish a physical connection but required privileges for your account are missing.

I hope this will help you.

EldoRay
  • 82
  • 10
  • 1
    Exactly, access denied messages can be tricky to solve, but you're right, physical connection is already there, so there is at least no firewall blocking you. – Anse Sep 06 '19 at 12:15
  • It's an old question, but thank you so much for answering. – Day Break Jan 03 '20 at 12:42