step 3 - "A Prestashop database already exists, please drop it or change the prefix”

[Nmore]

Hello!

I’m trying to install PRESTASHOP, but I could’t finish the install, it stops at the step 3, always with the message
“A Prestashop database already exists, please drop it or change the prefix”.
Always I creating a new database.
Video:
http://www.youtube.com/watch?v=NwUhJyBz7Gk

Apache/2.2.8 (Win32) PHP/5.2.6 Server - AppServ 2.5

Any Ideas?
Thanks you!

[lip2502]

up I have the same problem.
The database is created, but it still won't move on to step 4.
Any idea ?

Thanks

[RealDealSER]

im new here but i will try and help ya. Go into "Manage MYSQL" or MYSQL and just delete the database. Then create a new one ( be sure to rename it the same thing "prestashop") and try to reinstall again. What i mean by reinstall is just activate the index.php file again. you dont have to upload the entire file again. it is reading the database from the previous prestashop install you completed. Hope this helps. Cheers

[mytheory.]

Yep, do what the OP said.

If you're using PHPMYADMIN it's quite easy... just select the DATABASE from the list on the left column and choose the "DROP" option.

If you're using the command line... log in via CMD or terminal.

>mysql -u username -p (hit enter, next line will ask for your password)
>Enter password: (Enter your password, hit enter)

Then you can view the databases by typing:
>SHOW DATABASES;

Then you can drop one of the databases from the list with this command:
>DROP DATABASE name_of_database;

Then you can create a new database:
>CREATE DATABASE name_of_database;

Then if you logged into as root.. you probably want to dedicate another user specifically for your PS DB esp. if you have other databases.
So create user and grant privileges:
>CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
>GRANT ALL PRIVILEGES ON name_of_database TO 'username'@'localhost';

Then try the installation process again.

[mytheory.]

Oh yea... and at the end:

>FLUSH PRIVILEGES;