Can t connect to mysql server in workbench Kindly please support username root Password 1234 i gave

0 votes
Mar 29, 2020 in Database by Arivukani
• 120 points
556 views

1 answer to this question.

0 votes

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.

answered Mar 30, 2020 by Gitika
• 65,970 points

Related Questions In Database

0 votes
1 answer

How can I connect databases server to EC2 server?

Hi@Trinu, You can create one database in AWS ...READ MORE

answered May 1, 2020 in Database by MD
• 95,320 points
313 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,380 points
1,533 views
0 votes
1 answer

How to connect to MySQL Database?

using MySql.Data; using MySql.Data.MySqlClient; namespace Data { ...READ MORE

answered Oct 12, 2018 in Database by Frankie
• 9,810 points
473 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,240 points
1,390 views
0 votes
1 answer

How to install MySQL in windows?

You can download the all in one ...READ MORE

answered Feb 28, 2019 in Database by Priyaj
• 58,140 points
306 views
0 votes
1 answer

What is MySQL Workbench?

MySQL Workbench is a designing or a ...READ MORE

answered Nov 29, 2018 in Database by Sahiti
• 6,380 points
126 views
0 votes
1 answer

MySQL Workbench Functionalities

The functionalities of MySQL Workbench are as ...READ MORE

answered Nov 29, 2018 in Database by Sahiti
• 6,380 points
289 views
0 votes
1 answer

What are the various MySQL Workbench editions?

MySQL Workbench is mainly available in three ...READ MORE

answered Dec 6, 2018 in Database by CodingByHeart77
• 3,720 points
193 views
0 votes
1 answer
0 votes
1 answer

How to design data warehouse for support whole business?

Hi, @There, So here are a few steps ...READ MORE

answered Jun 1, 2020 in Database by Gitika
• 65,970 points
250 views