show grants for charm@'localhost'; ---------------------+ | Grants for charm@localhost | +-----------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'charm'@'localhost' IDENTIFIED BY PASSWORD '*EDD1CD76B1331E363B2BAED3F0B7EAF28559FBEWD' | | GRANT ALL PRIVILEGES ON `charmstyle_com`.`charmstyle_com` TO 'charm'@'localhost'
i used
grant all on charmstyle_com to charm@'localhost' IDENTIFIED BY 't1q4gytrur'; flush privileges;
then i import the database,it shows an error:
ERROR 1142 (42000) at line 29: CREATE command denied to user 'charm'@'localhost' for table 'adminnotification_inbox'
You granted the user permissions only to the 'charmstyle_com' table inside the 'charmstyle_com' database. What you probably want is to grant permissions to all the tables in 'charmstyle_com' (or at least the 'adminnotification_inbox' table)
GRANT ALL PRIVILEGES ON `charmstyle_com`.* TO 'charm'@'localhost'
alternatively
GRANT ALL PRIVILEGES ON `charmstyle_com`.`adminnotification_inbox` TO 'charm'@'localhost'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With