Re: Can we delete ibd table without repercussion?
Posted by: Karen Goh
Date: January 08, 2019 08:38PM

Hi Peter,

Thank you so much for your reply.

I'd like to highlight to you that when I use Workbench to do the connection, the user is mysql@localhost and then it just asked me for the password.

I used to think it should be root@locahost but I did not bother to find out more, since I could continue to use MYSQL server to do my work.

Is there something wrong with the set-up of MYSQL server in this case?

I have also tried SHOW GRANTS and this is what I get:

C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\bin>mysql> SHOW GRANTS;
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\bin>mysql> SHOW GRANTS FOR 'mysql'@'localhost


For the 2nd SHOW GRANTS for mysql@localhost, there was no result after I enter the command.

What's happening here ?

Could you advise me what should be done to make things right?

Thanks.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.