MySQL

MySQL is a prominent open-source relational database management system. An incredibly flexible and powerful program, MySQL is used to store and retrieve data for a wide variety of popular applications.

MySQL subscription active
You will receive email notifications for new publications on MySQL.
1019 Results
  • Question

    How to change caching_sha2_password to mysql_native_password on a DigitalOcean's Managed MySQL Database?

    I want to use the new DigitalOcean MySQL Managed Databases with my PHP application but I'm getting this error here: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; con...
    Accepted Answer: Hello, The easiest way to fix that would be to alter your existing user with the following: ALTER USER <^>myuser <^>IDENTIFIED WITH mysql_native_password BY '<^>mypassword<^>'; Another thing that you could do is to ...
    6 By bitmap Databases MySQL PHP WordPress
  • Question

    Completely uninstall mysql-server

    Hi there, first of all I need to make some history to tell why am getting to this point. A few days ago, making a multisite WordPress installation I lost access to database. This I solved it without breaking my head. ...
    Accepted Answer: Hi there @themingisprose, Indeed deleting files directly from your MySQL folder is really not recommended. You can take a look at this guide here on how to delete old MySQL binary files here (https://bobbyiliev.com/bl...
    1 By themingisprose MySQL Ubuntu 20.04
  • Question

    Remote login for MySQL no longer working

    I have a MySQL database on my droplet which I was remote logging into and updating from a Python script for the last couple of months. I used this tutorial to get everything working (https://linuxize.com/post/mysql-re...
    Accepted Answer: Hi there @zsmith126028, I could suggest a couple of things: First check if your MySQL is actually binding on 0.0.0.0:3306: command netstat -plant | grep 3306 Doublecheck your IP address, you could do that by visiting...
    1 By zsmith126028 MySQL
  • Question

    Reseting WordPress admin password via the command line (terminal)

    I've seen this question a lot where people have forgotten their WordPress admin password and they don't remember their email in order to use the "Lost Password" feature. The password can be changed/reset from MySQL/Ma...
    Accepted Answer: First you need to identify the table responsible for storing WordPress user accounts. Usually the table that stores all user information is <^>wp_users<^> but you may have different database prefix so you can check yo...
    2 By alexdo WordPress MySQL MariaDB
  • Question

    Access denied for user 'test'@'localhost' (using password: NO)

    My login attempts fail for a new user account that I have created, and I have spent several hours learning how authentication is handled by MySQL, with no progress. Everything is on the same server: - MySQL 5.7 - phpM...
    Accepted Answer: Hello, I think that you have a typo in your grant privileges query. I've tried your queries and it worked as normal, I just had to adjust the grant privileges query a little bit. Here's what I did: I created a databas...
    2 By CommunityUser1121 MySQL LAMP Stack
  • Question

    Port 3306 blocked even though do, ufw, and iptables are configured to allow.

    I am trying to remotely connect to my mysql instance and have been unsuccessful. ufw shows port 3306 open iptables is not configured and the droplet firewall shows that it should be allowed. I have confirmed that my i...
    Accepted Answer: Hi there @damianyates, It sounds like that your MySQL service might be binding only on 127.0.0.1:3306 and if you want to access MySQL from the outside world, you need to change this to 0.0.0.0:3306. To check if this i...
    2 By damianyates MySQL DigitalOcean Cloud Firewalls Firewall
  • Question

    How can I kill all MySQL sleeping queries?

    Hello, I've noticed that I have a lot of sleeping MySQL processes. I tried killing them one by one but there are too many to do so. Does anyone know if there is an easier way to kill all sleeping processes at once? Th...
    Accepted Answer: Hello, Yes, you can kill all of your sleeping connections with this command: for i in `mysql -e "show processlist" | awk '/Sleep/ {print $1}'` ; do mysql -e "KILL $i;"; done However, this is not a permanent solution...
    2 By bitmap MySQL Linux Basics
  • Question

    How to upgrade MySQL server, for the one-click app

    Hello, I'm using the PHPMyAdmin one-click app, but the MySQL server version is way behind and I'm not sure how to upgrade it without breaking anything The current version is: mysql Ver 14.14 Distrib 5.7.30, for Lin...
    Accepted Answer: Hi there @Geekologist, With the PHPmyAdmin 1-Click installation, you get MySQL 5.7 and PHPmyAdmin 4.6.6. I believe that if you upgrade your MySQL installation you would need to upgrade PHPmyAdmin to the latest version...
    1 By Geekologist PHP MySQL One-Click Install Apps Ubuntu Ubuntu 18.04 Databases DigitalOcean
  • Question

    Update MySQL version cPanel/WHM using API / command line / Terminal

    Recently I was asked if there is a way to update the MySQL version using the command line and which is the best way to do this.
    Accepted Answer: There a few ways to update MySQL or MariaDB and one of them is doing this via the command line / terminal and I would like to share the process with you. Introduction cPanel is one of the most popular Linux-based cont...
    1 By alexdo CentOS MySQL MariaDB Linux Commands
  • Question

    How to improve mysql for wordpress in ubuntu 18?

    I have had a lot of problems loading batch images in wordpress, I have read that there are ways to solve it by improving the database cache, how can I do it? I have seen other posts here but they talk about ubuntu 14 ...
    Accepted Answer: Hi @stiven8as, Let's review a few things before you go to your MySQL. The first big issues would be the size of the images, how big are they? If you have images with a size of 4,5,6,7 MB it will take time until they l...
    1 By stiven8as Ubuntu 18.04 WordPress Apache MySQL
  • Question

    Mysql Crashes when server is reboot

    log 1 ``` 2020-06-17T15:55:14.199344Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicitdefaultsfortimestamp server option (see documentation for more details). 2020-06-17T15:55:14....
    Accepted Answer: Hi @csselo, Both logs don't seem to provide the full information on which can act upon. I can only see it's failed with status 1 which is usually the code on generic errors. Anyway, what I'll recommend is to recreate ...
    1 By csselo MySQL Block Storage
  • Question

    How to install manually phpMyAdmin on Ubuntu?

    It is usually recommended to use distribution packages when possible - they usually provide integration to your distribution and you will automatically get security updates from your distribution. You can find a coll...
    Accepted Answer: There are a few ways of installing phpMyAdmin as described in the official documentation here: https://docs.phpmyadmin.net/en/latest/setup.html However I've been using another method which is a bit more convenient for...
    1 By bobbyiliev MySQL PHP LAMP Stack Apache
  • Question

    Can't login to mysql as root user even though I have the password

    I followed this tutorial on how to set up phpMyAdmin on Ubuntu 18.04: https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04 In step 2 I'm trying to log in to mysql using...
    Accepted Answer: Hi there @maxRay, It looks like that the MySQL password that you are trying to use is not correct. In case that you've lost the MySQL root password I could suggest following the steps from this tutorial here on how to...
    2 By maxRay MySQL Ubuntu 18.04
  • Question

    IP addresses in MySQL logs

    While going through the MySQL logs from a DO instance, I found the following entries: ``` 2020-06-04T08:14:44.965714Z 2 [Warning] Hostname 'rnd.group-ib.ru' does not resolve to '80.82.70.118'. 2020-06-04T08:14:44.9658...
    Accepted Answer: Hi @AGhafoori, Hmm this does look troubling. Usually, this doesn't give out IP addresses unless specifically told so. I'll recommend to check your whole log and see if these IP addresses occur on other lines of the lo...
    2 By AGhafoori MySQL
  • Question

    What are mySQL credentials?

    Hi There, I inherited a 1Click LAMP install on a droplet that was created 3 years ago. I need to move the db off the droplet for a number of reasons but I don't know the credentials to login to mySQL or the db usern...
    Accepted Answer: Hey, Usually with the 1-Click installs, the passwords are saved to a file when the droplet is created. Try having a look for any .password files in the root directory. I've just created a new droplet and the passwords...
    2 By ScoutDigital MySQL Ubuntu LAMP Stack
  • Question

    "Cannot log in to the MySQL server" without code using phpMyAdmin on CentOS7

    I've set up a new CentOS 7 server with Apache, MySQL and phpMyAdmin using Digital Ocean's guides. However, when I try to log in to phpMyAdmin via the browser, I get the message "Cannot log in to the MySQL server" with...
    Accepted Answer: Assuming MySQL 8. ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD'; Reason: Some applications are having trouble with <^>caching _sha2 _password<^> method. Above sets the credentials to use the...
    4 By NielsKersic MySQL Databases CentOS
  • Question

    How To Find php.ini? (Ubuntu LAMP on 18.04)

    I'm trying to upload a large database to phpMyAdmin, and so need to adjust the values of uploadmaxfilesize, memorylimit and postmax_size in the php.ini configuration file. However I'm having trouble locating php.ini o...
    Accepted Answer: Hi @alexanderCrab, The best way to see which PHP.ini your website is looking at is using phpinfo. PHPinfo() is a PHP method which can be used in a file like so ``` <?php phpinfo(); ``` Basically, what you need to do ...
    1 By alexanderCrab PHP MySQL Ubuntu 18.04
  • Question

    Why can't I connect to a remote MySQL server from a PHP application, but can connect from mysql-client

    Hi! I'm bamboozled. Here's the setup: * One application server, Ubuntu 18.04 LTS (PHP 7.2, mysql-client) * One database server, Ubuntu 18.04 LTS (mysql-server 5.7) I need to connect to the database from a PHP appl...
    Accepted Answer: Hello, This is quite interesting. As you are able to connect to the database with the mysql command, my guess would be that the password that you are using might not be correct, does your password have any special cha...
    1 By firestormbe352da97c3f50bea MySQL PHP Ubuntu 18.04
  • Question

    Has anyone solved this error?A PHP Error was encountered Severity: Warning Msg: mysqli:real_connect(): (HY000/2002): Connection refused

    error 1 A PHP Error was encountered Severity: Warning Message: mysqli::real_connect(): (HY000/2002): Connection refused Filename: mysqli/mysqli_driver.php Line Number: 201 error 2 A PHP Error was encountered Severity:...
    Accepted Answer: Hello, It looks like that your server is running out of disk space. You can check that with this command: df -h My guess would be that the server ran out of space and MySQL crashed, that is why you are getting the f...
    1 By thiago20 MySQL PHP Ubuntu
  • Question

    Can't connect to MySQL instance in managed databases

    Managed MySQL instances were just released yesterday so I decided to spin one up to test it out. I have not been able to connect to the instance using any tool at my disposal. Running OSX 10.14.6 Sequel Pro (nightly b...
    Accepted Answer: <^>Answer:<^> Okay I think I've gotten to the bottom of this. I can't edit my original question but leaving this here in case someone else runs into it. The use of the non-standard port must have been blocked on my ne...
    6 By jhazel DigitalOcean MySQL