Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Phpmyadmin stops working Question Question
After updating bind-address in /etc/msql/my.cnf file MySQL stops working Question Question

Question

How to disable SQL_REQUIRE_PRIMARY_KEY in digital ocean manged database for mysql?

Posted September 14, 2021 89 views
MySQLDatabasesSQL

How to disable SQLREQUIREPRIMARY_KEY in digital ocean manged database for mysql globaly?

Add a comment
ajaypatel
By:
ajaypatel

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Phpmyadmin stops working Question Question
After updating bind-address in /etc/msql/my.cnf file MySQL stops working Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
Rajkishore September 15, 2021

Hi @ajaypatel,

You can reach out to DO support to disable global sqlrequireprimary_key for your MySQL managed database.

If you need to disable it on session level, you can execute the below command.

SET SESSION sql_require_primary_key = 0;

I hope this helps!

Regards,
Rajkishore

Reply Report

Related

Looking for something else?

Ask a new question Search for more help