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 rootOnce logged in:
Which will revert back to the native (old default) password authentication.
Now use password as the password whenever required by MySQL.
• 65,890 points
Related Questions In Database
- All categories
- Apache Kafka (84)
- Apache Spark (596)
-
Azure (131)
- Big Data Hadoop (1,907)
- Blockchain (1,673)
-
C# (124)
- C++ (268)
- Career Counselling (1,060)
-
Cloud Computing (3,356)
- Cyber Security & Ethical Hacking (145)
- Data Analytics (1,266)
- Database (853)
- Data Science (75)
- DevOps & Agile (3,500)
-
Digital Marketing (111)
- Events & Trending Topics (28)
- IoT (Internet of Things) (387)
-
Java (1,178)
- Kotlin (3)
- Linux Administration (384)
-
Machine Learning (337)
- MicroStrategy (6)
- PMP (423)
-
Power BI (516)
- Python (3,154)
- RPA (650)
-
SalesForce (92)
- Selenium (1,569)
- Software Testing (56)
-
Tableau (608)
- Talend (73)
- TypeSript (124)
-
Web Development (2,999)
- Ask us Anything! (66)
- Others (1,124)
-
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).