Run 3: "client", neither "libs" nor "common" ===== OS NAME="Oracle Linux Server" PRETTY_NAME="Oracle Linux Server 7.0" ===== MySQL software mysql-community-client-5.6.23-2.el7.x86_64 mysql-community-release-el7-5.noarch ===== errmsg.sys drwx------. 3 joerg joerg 4096 13. Feb 16:23 . ===== Set up test user + DB +----------------------------------------------------+ | Grants for foobar@% | +----------------------------------------------------+ | GRANT USAGE ON *.* TO 'foobar'@'%' | | GRANT ALL PRIVILEGES ON `foo_db`.* TO 'foobar'@'%' | +----------------------------------------------------+ +--------------------+ | Database | +--------------------+ | information_schema | | foo_db | | mysql | | performance_schema | | test | +--------------------+ ===== Run some commands that will produce error messages -------------- create table some_tab ( id INT AUTO_INCREMENT, was VARCHAR(30), PRIMARY KEY (id) ) -------------- -------------- show create table some_tab -------------- *************************** 1. row *************************** Table: some_tab Create Table: CREATE TABLE `some_tab` ( `id` int(11) NOT NULL AUTO_INCREMENT, `was` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 -------------- insert into some_tab (was) values ("The very first row") -------------- -------------- insert into some_tab (was) values ("Give it a companion") -------------- -------------- commit -------------- -------------- select * from some_tab -------------- +----+---------------------+ | id | was | +----+---------------------+ | 1 | The very first row | | 2 | Give it a companion | +----+---------------------+ -------------- insert into some_tab (id, was) values (1, "Will not make it") -------------- ERROR 1062 (23000) at line 12: Duplicate entry '1' for key 'PRIMARY' -------------- show create table nonesuch -------------- ERROR 1146 (42S02) at line 13: Table 'foo_db.nonesuch' doesn't exist -------------- drop table will_fail -------------- ERROR 1051 (42S02) at line 14: Unknown table 'will_fail' ===== Cleanup ERROR 1141 (42000) at line 3: There is no such grant defined for user 'foobar' on host '%'