Windows web-installer fails to create database: problem & solution

Problem: The web-installer in a Windows install fails to create the otrs database, complaining that the admin user you specified doesn't have privileges. Solution: mysql is set up with a root user with no password. Add the location of mysql.exe to your system path, then at a command line type: mysql -u root and you'll be logged in to mysql's console. now you need to create an admin user. Let's call it 'admin' with password 'Admin'. You can try something like the following, and your installer will still fail: grant all privileges on localhost.* to admin@localhost identified by 'Admin'; flush privileges; You have to explicity grant privileges to create new databases, by adding the option "with grant option" to your mysql command, like so: grant all privileges on localhost.* to admin@localhost identified by 'Admin' with grant option; flush privileges; now you can exit mysql (you might want to set a root password while you're at it). cheers Stewart __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
participants (1)
-
Stewart Midwinter