CODEWITHSUNDEEP
mysqlsql
Zeta Reactor
Zeta Reactor

Reputation: 95

Can not remove max user connections

I am fairly new to SQL, and not sure if i'm doing something wrong or is the database limited by the host company.

Every time i try to use one of the recomanded solutions that i was able to find, i get an error.

error

GRANT USAGE ON *.* TO overlim1_bot_acc@localhost WITH MAX_USER_CONNECTIONS 0;

What should/can i do? Should i upgrade to a bigger host?

Upvotes: 1

Views: 126

Answers (1)

Derviş Kayımbaşıoğlu
Derviş Kayımbaşıoğlu

Reputation: 30565

Most probably, the user which you are currently connected does not have GRANT privilage,

You need to use elevated user such as root, in order to grant other user for anything.

Upvotes: 1

Related Questions