近日安装OTRS2.4,系统安装提示“table mysql.servers doesn't exist
发现缺省安装出来的mysql数据库 确实没有mysql.servers 表.
只能新建表了,
还好 mysql安装后本机已经有了原始数据表结构. 只用导入即可.
[root@localhost mysql]# ls -l *.sql
-rw-r--r-- 1 root root 591286 Sep 19 19:28 fill_help_tables.sql
-rw-r--r-- 1 root root 42121 Sep 19 19:28 mysql_fix_privilege_tables.sql
-rw-r--r-- 1 root root 1878 Sep 19 19:28 mysql_system_tables_data.sql
-rw-r--r-- 1 root root 16510 Sep 19 19:28 mysql_system_tables.sql
-rw-r--r-- 1 root root 9669 Sep 19 19:28 mysql_test_data_timezone.sql
[root@localhost mysql]# pwd
/usr/share/mysql
cd /usr/share/mysql/
[root@localhost mysql]#
mysql -u root -p
********
mysql> use mysql;
输入密码后运行
mysql> source mysql_fix_privilege_tables.sql
mysql> show tables;
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
23 rows in set (0.00 sec)