MySQL

MySQL is an open-source relational database management system. As with other relational databases, MySQL stores data in tables made up of rows and columns. Users can define, manipulate, control, and query data using Structured Query Language, more commonly known as SQL. A flexible and powerful program, MySQL is the most popular open-source database system in the world.

featured tutorialHow To Install MySQL on Ubuntu 20.04
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, My...

Hazel Virdó, and Mark Drake • Published on April 23, 2020 · Updated on March 18, 2022

featured tutorialHow To Reset Your MySQL or MariaDB Root Password on Ubuntu 20.04
Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB data...

Mateusz Papiernik • Published on February 12, 2021 · Updated on December 20, 2021

featured tutorialHow To Allow Remote Access to MySQL
Many websites and applications start off with their web server and database backend hosted on the same machine. With ...

Mark Drake • Published on March 7, 2019 · Updated on June 25, 2021

Subscribe to MySQL
Get notified when new articles on MySQL are published.
    All
  • 20 Results
    Newest
    All time
    English
    • Question

      Single Managed MySQL Database for all my Websites including sites not on DO

      I am interested in Managed MySQL Databases . But spending $15 / month for each website is way too expensive. I was wondering if using the Basic 1GB @ $15 / mo is efficient for all my websites (on and off DO) using it ...
      1 answer1 day agoBy Anjanesh LekshminarayananDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      mysql is using 100% cpu and causing establishing database error

      my droplet: 4 GB Memory / 80 GB Disk / BLR1 - Ubuntu/ wordpress/ woo commerceI’m getting database error every 2 hour, sometime i can resolve it by restarting the droplet, and sometime i need to restore a backupfunny t...
      Accepted Answer: Hi there, I would suggest a few things: Try following the steps from this tutorial here on how to tweak your MySQL server for better performance: https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mar...
      1 answer4 days agoBy BIOFOOT MEADICALDatabasesMySQLUbuntu 20.04
    • Question

      how to use spring boot api with reaactjs and mysql database

      how to use spring boot api with reaactjs and mysql database
      1 answer7 days agoBy DriftingLightSeaGreenWalrusMySQLReact
    • Question

      Managed MySQL database - Event Scheduler errors

      Hi, I have several managed MySQL databases and I have set up several event scheduler jobs for maintenance. None of the scheduled events run correctly and I see errors in the “Logs & Queries” DigitalOcean dashboard, su...
      No answers yet8 days agoBy Jérémie L.DigitalOcean Managed MySQL DatabaseMySQLSQL
    • Question

      How to give file permission to user in Managed Mysql

      I want to do some file operations on my managed mysql. I tried adding privileges using GRANT ALL ON testdb.* TO 'sammy'@'%' WITH GRANT OPTION;but this does not do the trick.I also tried grant file on testdb.* to 'samm...
      1 answer10 days agoBy Vaibhav ChauhanDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Completley reset mysql installation including files that come with the OS

      I am in Ubuntu 20.04. I followed the MySQL installation tutorial and I got an error after running sudo mysql_secure_installation so I decided to uninstall and reinstall. I tried the entire process again and I started ...
      1 answer14 days agoBy leoddcMySQLUbuntu 20.04
    • Tutorial

      How To Install MariaDB on Ubuntu 22.04

      MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement...
      15 days agoBy Brian Boucheron, Mark Drake, Tony TranMariaDBDatabasesMySQLUbuntuUbuntu 22.04
    • Question

      How to import big MYSQL table into DO Managed database

      I have database of the size 4gb that i would like to import into DO Mysql managed database. I tried using mysqlimport with multiple threads but having trouble getting the process to start mysqlimport: Error: 1227 Acce...
      1 answer17 days agoBy Diesel Utama IndonesiaDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Database Error when logging into wordpress

      I can access my website but can’t log into my wordpress website. When I do that I get Database error. I tried doing repairing database but it still showed my database error. I don’t know what happened but I haven’t ch...
      2 answers21 days agoBy Mohit PandeyDatabasesDigitalOcean Managed MySQL DatabaseMySQLWordPress
    • Question

      sudo mysql-create-db-and-user - SQL syntax ERROR 1064 (42000) at line 1

      Can anyone help get this command working again? This cmd used to work in the putty console - sudo mysql-create-db-and-user dbuserhere dbnamehere passwordhere This error now appears - ERROR 1064 (42000) at line 1: You ...
      2 answers23 days agoBy twc8ac35a8636DigitalOcean DropletsMySQL
    • Question

      Slow queries log on managed database

      Is it possible to view the slow queries log on a managed database? I don’t see it under the “Logs & Queries” tab, as suggested.
      1 answer23 days agoBy benDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      How to connect to database from a docker container inside a droplet?

      I have just created a droplet and installed Docker to run an openjdk image with a springboot app but i get this error when trying to connect to my database java.sql.SQLNonTransientConnectionException: Could not create...
      1 answer1 month agoBy Fer PerezDatabasesDockerJavaMySQLNetworking
    • Question

      How to restore a website if data is corrupted

      So, my site got messed up due to DDoS attack due to which I had to uninstall and install MYSQL again. I found that it isn’t wordpress database and the backup which I have is corrupted one and another backup which I ha...
      1 answer1 month agoBy Mohit PandeyDigitalOcean DropletsDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Getting Error while reinstalling MYSQL

      I had my disk space full due to which I couldn’t delete binary logs using sql command. So, I took a backup deleted some bin files manually using SFTP. After this mysql start messing up, so I uninstalled and installed ...
      Accepted Answer: Hi there, I could suggest following the steps from this answer here on how to completely uninstall MySQL: https://www.digitalocean.com/community/questions/completely-uninstall-mysql-server Let me know how it goes afte...
      1 answer1 month agoBy Mohit PandeyDigitalOcean DropletsMySQL
    • Question

      Can´t set root password when installing MySQL server

      Hi, When I try to setup a root password for the MySQL server following this guide (https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-20-04 ) I always get the f...
      2 answers1 month agoBy heusmichMySQL
    • Question

      "ERROR 1227 (42000) at line x: Access denied" when using doadmin user

      I made a dump of a MySQL DB with mysqldump and am now trying to restore it to my DigitalOcean managed DB using the doadmin user and I get this error: ERROR 1227 (42000) at line 18: Access denied; you need (at least on...
      Accepted Answer: Hi @jimwigginton , the command you’ve used: sed 's/SET @@SESSION.SQL_LOG_BIN.*//' -i backup.sql sed 's/SET @@GLOBAL.GTID_PURGED.*//' -i backup.sql I’m glad it has helped you. Having said that, yes the doadmin user on ...
      2 answers1 month agoBy Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Urgent: Your [placeholder] database’s functionality is at risk

      I’ve been getting these emails daily from DigitalOcean: Our systems have indicated that your MySQL cluster, [placeholder], has tables without primary keys. We have identified that MySQL tables without primary keys can...
      Accepted Answer: DigitalOcean support gave me this alternative query to run to find the problem tables: SELECT tab.table_schema AS database_name, tab.table_name AS table_name, tab.table_rows AS table_rows FROM information_schema.table...
      2 answers1 month agoBy Jim WiggintonDigitalOcean Managed MySQL DatabaseMySQL
    • Question

      Setting up a MySQL database

      I have LAMP installed on Ubuntu 20.4. I want to install a script that requires use of a MySQL database. I want to set up a separate/distinct database for a particular domain where the script will be installed. The dat...
      Accepted Answer: Hello, You can do that by following the instructions from step 3 here: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04#step-3-creating-a-dedicated-mysql-user-and-granting-privileg...
      1 answer1 month agoBy aecsp2000MySQL
    • Tutorial

      How To Set Up a Remote Database to Optimize Site Performance with MySQL on Ubuntu 20.04

      This guide will walk you through the process of configuring a remote MySQL database server that your website or application can connect to. It uses WordPress as a working example of something that can connect to the M...
      1 month agoBy Mark Drake, Brian Boucheron, Kong YangDatabasesMySQLUbuntuUbuntu 20.04WordPress
    • Question

      MYSQL sql_mode Keeps reseting

      Setup mysql Ver 14.14 Distrib 5.7.38, for Linux (x86_64) using EditLine wrapper Distributor ID: UbuntuDescription: Ubuntu 18.04.5 LTSRelease: 18.04Codename: bionic MYSQL Keeps reseting my sql_mode and so my website is...
      1 answer2 months agoBy kwstasna3MySQL