WampServer

I created a database and user in WAMP5 1.7.2 just fine. Using the same set of batch files, in WampServer 2.0b fails.

ERROR 1045 (28000): Access denied for user '20080502_user'@'localhost' (using password: YES)


do-createdb.bat:

@echo off

echo %time%

rem WAMP5
set p="c:\wamp\mysql\bin"
rem WampServer 2.0
if "%COMPUTERNAME%" == "T61P" set p="C:\wamp\bin\mysql\mysql5.0.51a\bin"

echo create_db.txt
%p%\mysql.exe -u root < create_db.txt

echo create_user.txt
%p%\mysql.exe -u root mysql < create_user.txt

echo Login
%p%\mysql.exe 20080502_db -u 20080502_user --password=20080502_pw

echo %time%


create_db.txt:

create database 20080502_db;
\q


create_user.txt:

grant SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON 20080502_db.*
TO '20080502_user'@'%'
IDENTIFIED BY '20080502_pw';


I believe this is a bug in WampServer 2.0b which is installed on a new XP laptop. WAMP5 has never been on this laptop. These scripts work fine in WAMP5 1.7.2 on a different computer.



Edited 1 time(s). Last edit at 05/03/2008 04:55PM by rcpao.