• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Liutauras Vilda
Sheriffs:
  • Tim Cooke
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Ron McLeod
  • Ganesh Patekar
  • salvin francis
Bartenders:
  • Tim Holloway
  • Carey Brown
  • Stephan van Hulst

How to reconfigure MYSQL to accept password @root ?  RSS feed

 
Ranch Hand
Posts: 468
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MYSQL server 8.0.13 and workbench 8.0.13 was working fine till suddenly the password was not accepted.

And so I can't log in and use the database.

I then decided to go to the re-configure available in the MYSQL Installer for Windows 10 but when it comes to the keying in password, the check button just gave me a red x and I can't continue the re-configuration.

So, I re-set my password again.



I am stumped and tired from trying all ways to revive MYSQL server and make MYSQL server to accept the password.


I have also granted all level of permissions to all users in accessing MYSQL server etc in Windows 10.

Please let me know how to make MYSQL server accept the password.

Tks.
 
tangara goh
Ranch Hand
Posts: 468
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My latest attempt shows that it seems Windows allow me to log in already but I am not sure.  cos it shows an id there.

C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\bin>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.13 MySQL Community Server - GPL
 
Marshal
Posts: 5634
147
Chrome Eclipse IDE Java Postgres Database VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It looks like you are getting logged in.  Can you work on the DB now?  Do you still have a problem?
 
Bartender
Posts: 20125
103
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There's nothing wrong with your second post. It's opening a mysql shell session for the userid "root". Although root is not the userid you should use except for administrative tasks.

Your first post failed because you attempted to connecto to the MySQL server using userid "ODBC". MySQL is quite serious about security and will only allow authorized users to connect to it, and further, it restricts what machines the connections may be done from and what database the connection is allowed for. You may need to adjust your GRANT rights for the database you wish to talk to.

Also note that MySQL is a program originally designed for a Unix-like environment, so user IDs and passwords are case-sensitive!
 
tangara goh
Ranch Hand
Posts: 468
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Knute Snortum wrote:It looks like you are getting logged in.  Can you work on the DB now?  Do you still have a problem?



Yes.  The schemas that were created earlier and still residing at the Data folder are not showing up in MYSQL server.

How do I bring them in ?
 
Tim Holloway
Bartender
Posts: 20125
103
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


You told MySQL to initialize a new data directory, but there was already data in it. MySQL did not like that.

If you cannot see schemas that used to be there, then it's likely that one of the following is at fault:

1. Your data directory isn't the directory that your database files are actually stored in (server not configured properly)

2. Your database files cannot be read by the userid that the MySQL daemon is running under (usually userid mysql). Most probably because your file ownership/access rights are incorrect.

3. The MySQL database userid that you connected to the MySQL server with doesn't have GRANT rights to see the schema.
 
tangara goh
Ranch Hand
Posts: 468
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Tim Holloway wrote:

You told MySQL to initialize a new data directory, but there was already data in it. MySQL did not like that.

If you cannot see schemas that used to be there, then it's likely that one of the following is at fault:

1. Your data directory isn't the directory that your database files are actually stored in (server not configured properly)

2. Your database files cannot be read by the userid that the MySQL daemon is running under (usually userid mysql). Most probably because your file ownership/access rights are incorrect.

3. The MySQL database userid that you connected to the MySQL server with doesn't have GRANT rights to see the schema.



But, I think I have the GRANT rights to root@localhost:

Please see below :

 
roses are red, violets are blue. Some poems rhyme and some are a tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database
https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!