Setting an Admin root password in mysql
(Ray: - "You can run the sql script that is in the installer/database folder to install the database." Not without a mysql password you can't!)
The password for Wamp is set up in one of two ways. The first way (which is recommended, but never seems to work) is to go to your MySQLInstanceConfig.exe (configuration Wizard) here:
C:\wamp\bin\mysql\mysql5.1.36\bin (or whichever of your directories contains the MySQLInstanceConfig.exe file).
Double-click on this to run it, and choose the first option (something like quick configuration? - but not the detailed option). Run through two or three steps - one of which is to enter a new password twice. Do this, and follow it through to the end. If you're very lucky, you will have started a new server instance. If things go the way they usually do though, it will say that it can't find this or that config file and you stop for tea.
The second way (if you haven't set up a password yet), is to enter a normal Windows command prompt, and CD your way (navigate) to the C:\wamp\bin\mysql\mysql5.1.36\bin (or what ever version your mySql is).
If you are not in your computer's C: drive when you enter the command prompt, type cd.. (cd followed by two dots) (then press return) and cd.. (return) until you get to the C:\> command prompt.
Then to get to the correct directory in order to run MySqlAdmin, type the following exactly (except for your mysql server version which might be different).and press retun after each entry:
Now your command prompt string should have grown to: C:\>wamp\bin\mysql\mysql5.1.36\bin
Now run the mysqladmin command:
If all has gone well, you should get some welcome to mySqladmin text with the commands and help switches tyhat you can use. At the very bottom, in its own line should be:
If you don't get any of that, then you may have not navigated to the right directory.
NOW: To set your password, type in the following exactly:
mysqladmin -u root password yourpassword
That whole line including 'mysqladmin'
WHERE 'yourpassword' is the password you want to use. Get it right, you only enter it once, and if you made a typo and don't know what it was, you are in a little trouble.
Assuming you don't get an error message and the prompt again says just mysqladmin, then you have successfully set up your Admin root user password. Type
to quit the mysql client command line, and return to Windows.
NOW: Having set up your mysql root password, you will now find yourself locked out of PHPmyAdmin, You'd think there would now be a log-in screen, but there isn't. SO this is the next step:
In windows, navigate to: C:\wamp\apps\phpmyadmin126.96.36.199\config.inc.php and open it with Notepad or other plain-text editor.
Look for the lines:
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; /* Enter your password between the two inverted commas */
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Your MysQl client (phpMyAdmin) now has the mysql password, and Powerstore 3 will now happily log on and complete the set-up,
localhost, root, yourpassword, yourdatabase