数据库常见错误信息和解决方法

Originally posted by kevinwong at 2005/5/21 08:06
我的還是不行o....都是說我
Discuz! info: Can not connect to MySQL server

Time: 2005-5-21 12:05am
Script: /upload/install.php?language=chinese_big5

Error: Access denied for user: 'jadekwan_ue ...

说说我的体会，我是自己的机器，装win2000简体中文版，在虚拟目录的有权限写，仍然还是这个提示，后来想起来我用的是NTFS文件系统，于是到windows下，将discuz目录的操作权限改成可写，一切OK，害我忙了2个小时。写出来，大家分享下。。

Discuz! info: Can not connect to MySQL server

Time: 2005-5-28 6:45am
Script: /snow/install.php?language=chinese_gb2312

Error: Access denied for user: 'username@localhost' (Using password: YES)
数据库帐户密码不对，请联系空间商

An error report has been dispatched to our administrator.


各位大虾帮帮忙啊，偶出现了上面的情况，咋办啊，教教我啊…………
上面说的都不懂，偶用的是外国的空间。

Discuz! info: MySQL Query Error

User: 123
Time: 2005-5-28 6:00pm
Script: /~huane/bbs/admincp.php

SQL: CREATE TABLE cdb_access ( uid mediumint(8) unsigned NOT NULL default '0', fid smallint(6) unsigned NOT NULL default '0', allowview tinyint(1) NOT NULL default '0', allowpost tinyint(1) NOT NULL default '0', allowreply tinyint(1) NOT NULL default '0', allowgetattach tinyint(1) NOT NULL default '0', PRIMARY KEY (uid,fid)) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

Discuz! info: Can not connect to MySQL server

Time: 2005-5-29 7:41am
Script: /bbs/install.php?language=chinese_gb2312

Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
服务器端口不对，请咨询空间商正确的端口

Similar error report has beed dispatched to administrator before.
这是什么原因呢!

Discuz! info: MySQL Query Error

Time: 2005-6-7 9:51am
Script: /discuz/index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.adminid, m.groupid, m.email, m.timeoffset,m.tpp, m.ppp, m.credit, m.timeformat, m.dateformat, m.signature, m.invisible, m.lastvisit, m.lastactivity as user_lastactivity, m.lastpost, m.newpm, m.accessmasks, m.regdate FROM cdb_sessions s, cdb_members m WHERE m.uid=s.uid AND s.sid='synDgw' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='203.218.91.47' AND m.uid='1' AND m.password='402096d7ef06bb1150e92dafba4651a1' AND m.secques='8d9edc3d'
Error: Table 'test.cdb_sessions' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.
----------------------------------------------------------------------------------------------------------------------------------------------------
我第一次安装成功，有2个会員。但是关机后就出现这个问题了。
我看过DATABASE，他根本没有建立过TABLE。那我填那个DATABASE干吗？根本用不上。
我是用MySQL4.1的。请多指教！

[ Last edited by isolator on 2005-6-7 at 10:06 ]

Discuz! info: Can not connect to MySQL server

Time: 2005-6-20 2:24pm
Script: /bbs/install.php?language=chinese_gb2312

Error: Access denied for user 'xmnew'@'localhost' (using password: YES)
数据库帐户密码不对，请联系空间商

Similar error report has beed dispatched to administrator before.

SQL: SELECT plug_title,plug_key,plug_stats,plug_tables FROM
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Errno.: 1064

請指教﹐怎樣修復阿﹖

原帖由 迎客松 于 2005-5-28 18:02 发表
Discuz! info: MySQL Query Error

User: 123
Time: 2005-5-28 6:00pm
Script: /~huane/bbs/admincp.php

SQL: CREATE TABLE cdb_access ( uid mediumint(8) unsigned NOT NULL default '0', fid smallint( ...

这个是因为MYSQL版本不同造成的，一个是4.0一个是4.1吧

原帖由 米蘭迷 于 2005-6-24 06:07 发表
SQL: SELECT plug_title,plug_key,plug_stats,plug_tables FROM
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use  ...

你这个是那个文件出现这个问题啊？

原帖由 jslxf 于 2005-5-29 15:42 发表
Discuz! info: Can not connect to MySQL server

Time: 2005-5-29 7:41am
Script: /bbs/install.php?language=chinese_gb2312

Error: Can't connect to local MySQL server through socket '/var/lib/mysq ...

MYSQL数据库挂了，找你的空间商解决吧