The MySQL database userid that you connected to the MySQL server with doesn't have GRANT rights to see the schema.īut, I think I have the GRANT rights to see below : Most probably because your file ownership/access rights are incorrect.ģ. Your database files cannot be read by the userid that the MySQL daemon is running under (usually userid mysql). Your data directory isn't the directory that your database files are actually stored in (server not configured properly)Ģ. If you cannot see schemas that used to be there, then it's likely that one of the following is at fault:ġ. You told MySQL to initialize a new data directory, but there was already data in it. Newly created data directory C:\Program Files (x86)\MySQL\mysql-8.0.13-win圆4\data\ initialize specified but the data directory has files in it. Please let me know how to make MYSQL server accept the password. I have also granted all level of permissions to all users in accessing MYSQL server etc in Windows 10. I am stumped and tired from trying all ways to revive MYSQL server and make MYSQL server to accept the password. T13:48:30.526721Z 0 -initialize specified but the data directory has files in it. Mysqld: Can not perform keyring migration : Invalid -keyring-migration-source option. 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.Ĭ:\Program Files (x86)\MySQL\mysql-8.0.13-win圆4\bin>mysqlĮRROR 1045 (28000): Access denied for user (using password: NO)Ĭ:\Program Files (x86)\MySQL\mysql-8.0.13-win圆4\bin>mysqld FLUSH PRIVILEGES Ĭ:\Program Files (x86)\MySQL\mysql-8.0.13-win圆4\bin>mysqld FLUSH TABLES Ĭ:\Program Files (x86)\MySQL\mysql-8.0.13-win圆4\bin>mysqld -u USERNAME -p MYSQL server 8.0.13 and workbench 8.0.13 was working fine till suddenly the password was not accepted.Īnd so I can't log in and use the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |