Wamp and Heidisql sync

User, date Message
User: Dave00!
Posted: Wed, 21 Jul 10 17:20
Category: General
2 posts since Wed, 21 Jul 10 		So i a newb here.. i downloaded drupal, wamp, heidi, and i installed every thing, ran every thing. once i began the configuration of drupal. there is a part that it asks to sync to the database.. it asks for database name, user name, password.. i input the the heidi data name i gave it.. user root, and no password.. but when it runs the configuration, it says the username and password are valid.. but there is an unknown database name... why cant i sync heidi which is my database.... em i doing something wrong?

PLEASE HELP!
User: anse
Posted: Wed, 21 Jul 10 18:31
1822 posts since Fri, 07 Apr 06 		"unknown database" is caused by some

USE NonExistantDatabase

. So I'm sure you have specified the wrong database name in your Drupal config, or you have some minor typo in that name.
User: Dave00!
Posted: Wed, 21 Jul 10 19:00
2 posts since Wed, 21 Jul 10 		well this is what i did.. open heidi,click on create.. then i i input w/e name i want as the database name.. then in the drupal database config.. it asks me for the database name.. i input the exact name i created it under.. and the the username is root, and there is no password.. so i dont know what the typo is.. i even made the name Dave to make it easier and no typos.. and nothing..
User: anse
Posted: Wed, 21 Jul 10 19:44
1822 posts since Fri, 07 Apr 06 		Was just a guess as I don't have a better explanation. Be sure to handle the database name case sensitive. It is case insensitive in MySQL for Windows system by default, but case sensitive on Linux.
User: kalvaro
Posted: Fri, 23 Jul 10 19:20
145 posts since Thu, 29 Nov 07 		Don't use the root user. Create a user from HeidiSQL (Tools-> User Manager) with a proper password. Then click the "Add privilege" button, select the database you created for Drupal, hit "OK" and click the checkbox on the left of the database name so the user has all the permissions: select, insert, update...
 

Please login to leave a reply, or register at first.