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
IamShipon1988
Jan 18 2010, 12:26 AM
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.