Default password for MySQL on Windows installation?

[jackson]

Hello,

I'm trying to install latest OTRS (3.2.3) on Windows machine, using bundled package/installer, but I'm stuck on second Web installer page. I have to enter root password for MySQL, but neither empty nor 'root' works.

I cannot also login to mysql by mysql.exe client - root, root@localhost, with password, without password - nothing works. Mysqladmin cannot change password either.

Any ideas?

Regards,
Jackson

[jojo]

the bundled mysql has no root password

[jackson]

Thanks for reply, but how can i login then?

C:\OTRS\mysql\bin>mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

C:\OTRS\mysql\bin>mysql -u root@localhost
ERROR 1045 (28000): Access denied for user 'root@localhost'@'localhost' (using password: NO)

C:\OTRS\mysql\bin>mysql -u root@localhost -p
Enter password: <EMPTY>
ERROR 1045 (28000): Access denied for user 'root@localhost'@'localhost' (using password: NO)

[jojo]

check if another mysql instance is running on the system

[jackson]

I didn't have any other mysql instances. I've reinstalled OTRS, and i've changed root password by mysqladmin before launching web install. It seems to be ok.

It may be linked to problem with apache - http://bugs.otrs.org/show_bug.cgi?id=9248

[TzunTzai]

Hello,

I'm trying to install latest OTRS (3.2.3) on Windows machine, using bundled package/installer, but I'm stuck on second Web installer page. I have to enter root password for MySQL, but neither empty nor 'root' works.

I cannot also login to mysql by mysql.exe client - root, root@localhost, with password, without password - nothing works. Mysqladmin cannot change password either.

Any ideas?

Regards,
Jackson

Hi,

I ran into the same problem. Ended up downloading "MySQL Workbench 5.2 CE"
http://www.mysql.com/products/workbench/

In MySql WorkBench, verify the OTRS database is present. Then follow the steps below.
- Go to Server Administrator --> Users & Privileges -->
- Verify user account otrs @ localhost is present
- Set the password to reflect the password in the Config.pm file (C:\..\OTRS\OTRS\Kernel\Config.pm)
- Select the Admin Roles tab --> Verify everything is checked --> Click Apply
- Select the Scheme Priv tab at the top -- > Select otrs user --> Check all boxes --> Save Changes
- For s**ts and giggle, I added another account otrs @ % with the same adjustments

Actually, I miss read your post. I didn't have any issues during the install, however I did have issues access the DB during upgrades. Either way, the MySQL Workbench helped me correct any access problems I was having with OTRS Windows.

Hope this helps.

~Alex

[waleeed12]

I did have issues access the DB during upgrades. Either way, the MySQL Workbench helped me correct any access problems I was having with OTRS Windows.