Run 1: "client" + "libs" + "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-common-5.6.23-2.el7.x86_64 mysql-community-libs-5.6.23-2.el7.x86_64 mysql-community-release-el7-5.noarch ===== errmsg.sys -rw-r--r--. 1 root root 60398 19. Jan 15:49 /usr/share/mysql/bulgarian/errmsg.sys -rw-r--r--. 1 root root 60930 19. Jan 15:49 /usr/share/mysql/czech/errmsg.sys -rw-r--r--. 1 root root 60937 19. Jan 15:49 /usr/share/mysql/danish/errmsg.sys -rw-r--r--. 1 root root 61936 19. Jan 15:49 /usr/share/mysql/dutch/errmsg.sys -rw-r--r--. 1 root root 60110 19. Jan 15:49 /usr/share/mysql/english/errmsg.sys -rw-r--r--. 1 root root 60413 19. Jan 15:49 /usr/share/mysql/estonian/errmsg.sys -rw-r--r--. 1 root root 61573 19. Jan 15:49 /usr/share/mysql/french/errmsg.sys -rw-r--r--. 1 root root 67893 19. Jan 15:49 /usr/share/mysql/german/errmsg.sys -rw-r--r--. 1 root root 66922 19. Jan 15:49 /usr/share/mysql/greek/errmsg.sys -rw-r--r--. 1 root root 60800 19. Jan 15:49 /usr/share/mysql/hungarian/errmsg.sys -rw-r--r--. 1 root root 61963 19. Jan 15:49 /usr/share/mysql/italian/errmsg.sys -rw-r--r--. 1 root root 67638 19. Jan 15:49 /usr/share/mysql/japanese/errmsg.sys -rw-r--r--. 1 root root 63234 19. Jan 15:49 /usr/share/mysql/korean/errmsg.sys -rw-r--r--. 1 root root 60201 19. Jan 15:49 /usr/share/mysql/norwegian/errmsg.sys -rw-r--r--. 1 root root 60254 19. Jan 15:49 /usr/share/mysql/norwegian-ny/errmsg.sys -rw-r--r--. 1 root root 60839 19. Jan 15:49 /usr/share/mysql/polish/errmsg.sys -rw-r--r--. 1 root root 63166 19. Jan 15:49 /usr/share/mysql/portuguese/errmsg.sys -rw-r--r--. 1 root root 61887 19. Jan 15:49 /usr/share/mysql/romanian/errmsg.sys -rw-r--r--. 1 root root 75801 19. Jan 15:49 /usr/share/mysql/russian/errmsg.sys -rw-r--r--. 1 root root 62587 19. Jan 15:49 /usr/share/mysql/serbian/errmsg.sys -rw-r--r--. 1 root root 60657 19. Jan 15:49 /usr/share/mysql/slovak/errmsg.sys -rw-r--r--. 1 root root 61795 19. Jan 15:49 /usr/share/mysql/spanish/errmsg.sys -rw-r--r--. 1 root root 61006 19. Jan 15:49 /usr/share/mysql/swedish/errmsg.sys -rw-r--r--. 1 root root 70200 19. Jan 15:49 /usr/share/mysql/ukrainian/errmsg.sys ===== 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 '%'