cant login as mysql user root from normal user account in ubuntu 18.04

So in order to to change the plugin back to mysql_native_password: Login with sudo: sudo mysql -u root Change the plugin and set a password with a single command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test'; note test is your password   OR    ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret") ...

View More
  Dibaca 196 kali

How can I disable MySQL Strict Mode?

This is enabled by default, but you can disable it in one of a couple ways. First, verify which mode(s) MYSQL is running with: $ mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';" You'll need to replace root with whatever username has superuser permissions on your server (but, it's usually just root). You'll also be prompted for the password. This will print out something like this (but much prettier): sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_D ...

View More
  Dibaca 335 kali