Re: Can we delete ibd table without repercussion?

[Karen Goh]

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.