Table ‘表名' doesn't exist

操作系统是suse linux,安装的是压缩版的mysql 5.5,已经安装成功了。
mysql服务可以起来,并且用mysql front远程也能连上,并且也创建了数据库,还导入了数据。
但是在执行查询的时候就报错了。
---------------------------
错误
---------------------------
SQL 执行错误 # 1146. 从数据库的响应:

Table 'smplatform.OMS_USER' doesn't exist
---------------------------
确定
---------------------------

我查了/usr/local/mysql/data下的linux-9p0s.err文件,错误如下:

121011 2:15:31 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

121011 2:15:31 [Note] Event Scheduler: Purging the queue. 0 events
121011 2:15:33 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 23 user: 'smplatform'

121011 2:15:33 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 22 user: 'smplatform'

121011 2:15:33 InnoDB: Starting shutdown...
121011 2:15:35 InnoDB: Shutdown completed; log sequence number 22123213
121011 2:15:35 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

121011 02:15:35 mysqld_safe mysqld from pid file /usr/local/mysql/data/linux-9p0s.pid ended
121011 02:16:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
121011 2:16:46 [Note] Plugin 'FEDERATED' is disabled.
121011 2:16:46 InnoDB: The InnoDB memory heap is disabled
121011 2:16:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121011 2:16:46 InnoDB: Compressed tables use zlib 1.2.3
121011 2:16:46 InnoDB: Using Linux native AIO
121011 2:16:46 InnoDB: Initializing buffer pool, size = 128.0M
121011 2:16:46 InnoDB: Completed initialization of buffer pool
121011 2:16:46 InnoDB: highest supported file format is Barracuda.
121011 2:16:47 InnoDB: Waiting for the background threads to start
121011 2:16:48 InnoDB: 1.1.8 started; log sequence number 22123213
121011 2:16:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121011 2:16:48 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121011 2:16:48 [Note] Server socket created on IP: '0.0.0.0'.
121011 2:16:49 [Note] Event Scheduler: Loaded 0 events
121011 2:16:49 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.25' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)


搞了一天了,没有结果,求高手帮忙解决,再拜!
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值