Technology Errors

ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist

Earlier today while adding a new site to a server running as a web server with many virtual hosts I ran into an error flushing the privileges after I added a new MySQL database followed by a user with only access to that new MySQL database. After a bit of investigation I realized that when I recently updated the MySQL server on the CentOS Linux server in question it must have had some issues during the upgrade. Below I describe not only the error in more detail but also how to resolve the MySQL error when attempting to flush the privileges.

Technology Insights

Create Zen Cart MySQL Database And MySQL User

I always forget specific MySQL syntax including creating a MySQL user and granting that user specific access only via localhost to a specific database. So when I install Zen Cart I always end up looking how to do this via the MySQL documentation. Below are simple instructions on how to create a MySQL database using mysqladmin, create a MySQL user, and grant permission to the created database to the created MySQL user.