CMD Prompt access to xampp mysql

[Hamish]

Hi,

I'm completely new to all this and just finding my way.

I want to access mysql dbs from Cmd Prompt but cannot find the right path. I have downloaded xampp directly onto c:\xampp-win32-1.7.4-VC7\xampp\ as suggested in the guide.

When I then try to access through CMD Prompt -
C:\xampp-win32-1.7.4-VC6\xampp\mysql\bin\mysql -u root -p ;
I get a request for a password: I have changed my 'root' password in phpMYadmin but not in the config.inc file but when I put in my new password it throws me out. I then try the same path with no password with the same result.

I would really appreciate it if someone could point me in the right direction.

Regards,

'H'

[JonB]

Other than the fact that its recommended you install in C:\XAMPP.

1st suggestion - try the full MySQL syntax i.e. user instead of u, password instead of p.
2nd suggestion - try the extended syntax --password instead of p.

Final suggestion - use the resetroot.bat found in \xampp\mysql. It resets the 'root' and 'pmauser' pws to a null.
Note that resetroot.bat file may need a fix to work properly -- read this:
http://bravo.newnetenterprises.com/word ... r-password

Good Luck

[Hamish]

Done and dusted - thanks very much.

After much experimneting I found that I also had to change the password in the config.php and leave out the ';' at the end of each command.

Thanks for your help.

'H'