Related

Join the DigitalOcean 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

Can not connect to database server MySql Workbench

Phpmyadmin stops working

Question

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

Posted September 14, 2021 1.8k

MySQL Databases SQL

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

By:

ajaypatel

Related

Join the DigitalOcean 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

Can not connect to database server MySql Workbench

Phpmyadmin stops working

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

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

ajaypatel September 15, 2021

Thanks @Rajkishore
Reply Report
rsinhamatri January 4, 2022

How can we contact the db support?
Reply Report
- Rajkishore January 4, 2022
  
  Hi @rsinhamatri,
  
  You can reach out to support using the below link and make sure to select the “Managed database” type.
  
  https://docs.digitalocean.com/support/
  
  Regards,
  Rajkishore
  
  Reply Report

Looking for something else?

Ask a new question Search for more help