Can't connect to mysql server in workbench. Kindly please support. username: root & Password: 1234 (i gave)

0 votes
Mar 28 in Database by Arivukani
• 120 points
262 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 by Gitika
• 51,280 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 in Database by MD
• 79,930 points
131 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,320 points
1,144 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
298 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,210 points
1,040 views
0 votes
1 answer

How to install MySQL in windows?

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

answered Feb 27, 2019 in Database by Priyaj
• 57,700 points
181 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,320 points
70 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,320 points
154 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
111 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 in Database by Gitika
• 51,280 points
132 views