Unable to add values to newly-created mySQL table

#1

Hello,

I created a table “departmentsPOR160893” on the “retail_export” database.

However, I am unable to subsequently insert additional values after the table has been created.

I generate the following error:
mysql> use departmentsPOR160893;ERROR 1044 (42000): Access denied for user ‘retail_user’@’%’ to database ‘departmentsPOR160893’

If one does not have write access to this database, how could I have created the table.

Can you explain how I may add values into this newly created table please?

Many thanks,
Patrick

0 Likes