CMD Prompt access to xampp mysql

Problems with the Windows version of XAMPP, questions, comments, and anything related.

CMD Prompt access to xampp mysql

Postby Hamish » 18. June 2011 21:45

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'
Hamish
 
Posts: 15
Joined: 18. June 2011 21:21
Operating System: Windows 7

Re: CMD Prompt access to xampp mysql

Postby JonB » 20. June 2011 10:55

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: CMD Prompt access to xampp mysql

Postby Hamish » 21. June 2011 14:06

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'
Hamish
 
Posts: 15
Joined: 18. June 2011 21:21
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 52 guests

cron