Mysql workbench keeps asking for password

1 answer to this question.

Hey, @Arivukani,

You can see once thing, the solution is to revert back to native password authentication. You can do this by logging in to MySQL using socket authentication by doing:

sudo mysql -u root

Once logged in:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Which will revert back to the native (old default) password authentication.

Now use password as the password whenever required by MySQL.

Mysql workbench keeps asking for password
answered Mar 30, 2020 by Gitika
• 65,890 points

  • All categories
  • Mysql workbench keeps asking for password
    Apache Kafka (84)
  • Mysql workbench keeps asking for password
    Apache Spark (596)
  • Mysql workbench keeps asking for password
    Azure (131)
  • Mysql workbench keeps asking for password
    Big Data Hadoop (1,907)
  • Mysql workbench keeps asking for password
    Blockchain (1,673)
  • Mysql workbench keeps asking for password
    C# (124)
  • Mysql workbench keeps asking for password
    C++ (268)
  • Mysql workbench keeps asking for password
    Career Counselling (1,060)
  • Mysql workbench keeps asking for password
    Cloud Computing (3,356)
  • Mysql workbench keeps asking for password
    Cyber Security & Ethical Hacking (145)
  • Mysql workbench keeps asking for password
    Data Analytics (1,266)
  • Mysql workbench keeps asking for password
    Database (853)
  • Mysql workbench keeps asking for password
    Data Science (75)
  • Mysql workbench keeps asking for password
    DevOps & Agile (3,500)
  • Mysql workbench keeps asking for password
    Digital Marketing (111)
  • Mysql workbench keeps asking for password
    Events & Trending Topics (28)
  • Mysql workbench keeps asking for password
    IoT (Internet of Things) (387)
  • Mysql workbench keeps asking for password
    Java (1,178)
  • Mysql workbench keeps asking for password
    Kotlin (3)
  • Mysql workbench keeps asking for password
    Linux Administration (384)
  • Mysql workbench keeps asking for password
    Machine Learning (337)
  • Mysql workbench keeps asking for password
    MicroStrategy (6)
  • Mysql workbench keeps asking for password
    PMP (423)
  • Mysql workbench keeps asking for password
    Power BI (516)
  • Mysql workbench keeps asking for password
    Python (3,154)
  • Mysql workbench keeps asking for password
    RPA (650)
  • Mysql workbench keeps asking for password
    SalesForce (92)
  • Mysql workbench keeps asking for password
    Selenium (1,569)
  • Mysql workbench keeps asking for password
    Software Testing (56)
  • Mysql workbench keeps asking for password
    Tableau (608)
  • Mysql workbench keeps asking for password
    Talend (73)
  • Mysql workbench keeps asking for password
    TypeSript (124)
  • Mysql workbench keeps asking for password
    Web Development (2,999)
  • Mysql workbench keeps asking for password
    Ask us Anything! (66)
  • Mysql workbench keeps asking for password
    Others (1,124)
  • Mysql workbench keeps asking for password
    Mobile Development (46)

Join the world's most active Tech Community!

Welcome back to the World's most active Tech Community!

Subscribe to our Newsletter, and get personalized recommendations.

Already have an account? Sign in.

What is default password for MySQL Workbench?

The default user for MySQL is root and by default it has no password.

How do I find my MySQL Workbench password?

In order to recover the password, you simply have to follow these steps: Stop the MySQL server process with the command sudo service mysql stop. Start the MySQL server with the command sudo mysqld_safe –skip-grant-tables –skip-networking & Connect to the MySQL server as the root user with the command mysql -u root.

How do I bypass MySQL username and password?

How to Change MySQL User Password.
Login to the MySQL shell as root. Access the MySQL shell by typing the following command and enter your MySQL root user password when prompted: mysql -u root -p. ... .
Set the MySQL user password. ... .
Verify the new password..

Why MySQL Workbench is not connecting?

Check that MySQL is running on address localhost. Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed). Check the user root has rights to connect to localhost from your address (MySQL rights define what clients can connect to the server and from which machines).