Help - Search - Members - Calendar
Full Version: Something Wrong With My Database
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
goingfish
sometimes it doesn't work ,and it read

"Query Error: CREATE TEMPORARY TABLE heap_hitupdate (tid INT(10) UNSIGNED NOT NULL ,hits SMALLINT(6) UNSIGNED NOT NULL) TYPE = HEAP

The URL Is:
http://nfzmbbs.cn/index.php

MySQL Server Error:
Access denied for user '83687_izj'@'192.168.1.1' to database 'nfzmbbs_zxq_izj' ( 1044 ) " ,



but after refresh it will work well ,how to solve it ?my site is http://www.nfzmbbs.cn
IamShipon1988
You entered the wrong host. For the "servername" or "host" you must enter localhost. So it should be 'username'@'localhost'

Also when you set up your database, did you select the proper permissions? Most users grant full access to the database; however, if you want (or need) to be more restrictive with database permissions: You will need to at least grant the ALTER, CREATE, DELETE, INSERT, SELECT, and UPDATE permissions to your database user.

Next time you have database problem, then please post in the database section. You will receive better help there. I'll move it for you now.
weiyg
QUOTE(goingfish @ Jan 17 2010, 12:26 PM) *
sometimes it doesn't work ,and it read

"Query Error: CREATE TEMPORARY TABLE heap_hitupdate (tid INT(10) UNSIGNED NOT NULL ,hits SMALLINT(6) UNSIGNED NOT NULL) TYPE = HEAP

The URL Is:
http://nfzmbbs.cn/index.php

MySQL Server Error:
Access denied for user '83687_izj'@'192.168.1.1' to database 'nfzmbbs_zxq_izj' ( 1044 ) " ,

but after refresh it will work well ,how to solve it ?my site is http://www.nfzmbbs.cn


can you DNS CHINA DOMAIN

QUOTE(goingfish @ Jan 17 2010, 12:26 PM) *
sometimes it doesn't work ,and it read

"Query Error: CREATE TEMPORARY TABLE heap_hitupdate (tid INT(10) UNSIGNED NOT NULL ,hits SMALLINT(6) UNSIGNED NOT NULL) TYPE = HEAP

The URL Is:
http://nfzmbbs.cn/index.php

MySQL Server Error:
Access denied for user '83687_izj'@'192.168.1.1' to database 'nfzmbbs_zxq_izj' ( 1044 ) " ,

but after refresh it will work well ,how to solve it ?my site is http://www.nfzmbbs.cn

你的中文域名能解析??
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2012 Invision Power Services, Inc.