change the stupid password

[mrsayao]

Ok... I found the uniform server after having trouble with other wamp installations. I like the fact that TUS is touted as "secure for production" out of the box. All I've done so far is unpacked and stuck it on a drive all by itself. I ran the security check and changed all the passwords except for the mysql password. I looked at the documentation and followed the directions:

1 - input password

2 - click change

3 - stop server with stop.bat (I'm using 'Stop_Server.bat' found in the Alternative Control folder)

4 - start server with start.bat (same dir as above, 'Start_Server.bat')

5 - The default Uniform Server info/index page comes up

6 - I click Admin page

7 - I'm STILL greeted with the "unsecure" change mysql password under the Security Checklist heading

 

I've tried several things:

a - after step 2, I wait 10 seconds and go on to step 3

b - after step 2, I wait until the page says Done and refreshes and @ the top of the apanel with "cannot read file"

c - after step 2, immediately go on to step 3.

 

none seem to work...

actually I just realized that even after restoring the mysql password, the top of the Change Password screen, it says "cannot read file"

 

I'm going insane.

[Ric]

This is a known bug in US54 solution edit file

UniServer\home\admin\www\mqsetup.php

Locate line:

$filename=$usf_my_cnf;

Change to:

$filename=$usf_my_ini;

 

Note: If you have not changed the MySQL port above bug is minor.

The MySQL port is read from configuration file my.cnf since this file does not exist the default port is used.

 

With the above modification, file my.ini is correctly read.

 

To change password:

UniTray > Start UniServer

UniTray > Admin Panel

Admin left menu click link “MySQL Server Configuration”

Current MySQL Password displayed, change to new password

Click “Change” button

That’s it no need to restart servers.

 

Note:

Security Center will display secure for MySQL Server

 

This Wiki page is worth a read:

http://wiki.uniformserver.com/index.php/5....#MySQL_Password

 

All the best

Ric

[mrsayao]

Hi Ric,

Thanks for the help... for some reason it still didn't work. I found a mini-fix but ran into another problem.

In the same directory of the mqsetup.php I noticed there is a mysql_password file that contained the default root password. Even after changing the password when opening the file, the password still was "root".

I deleted the file, followed your steps to point to the ini file, restarted, and that file reappeared but this time it was blank. From this point, security check said it was secure. phpmyadmin still won't load up. You mentioned something about mysql ports, but I've yet to even get that far! I haven't done much, basically changed the other passwords. I'm about to start from scratch. Would you suggest using a different version of US?

[Ric]

Try a clean install of Uniform Server 5.3-Nano that currently has no issues on Vista or W7

 

Alternatively you can try the new beta 5.4.1-Nano

 

All the best

Ric

[cwhoward1]

Hi Ric,

Thanks for the help... for some reason it still didn't work. I found a mini-fix but ran into another problem.

In the same directory of the mqsetup.php I noticed there is a mysql_password file that contained the default root password. Even after changing the password when opening the file, the password still was "root".

I deleted the file, followed your steps to point to the ini file, restarted, and that file reappeared but this time it was blank. From this point, security check said it was secure. phpmyadmin still won't load up. You mentioned something about mysql ports, but I've yet to even get that far! I haven't done much, basically changed the other passwords. I'm about to start from scratch. Would you suggest using a different version of US?

 

I had the similar experience. I edited the password file with my desired password and then it seemed to work.

 

Chuck