Just seen your edit - do you want your pint back?
lologirl wrote:EDIT: Izzy since doing what you told me I can't access MySQL from my cmd window, as I usually do.
When I put in my password, I get;
- Code: Select all
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
and net start mysql now returns
- Code: Select all
The service name is invalid.
I get the same error result if I try and use
net start mysql when MySQL is not installed as a service.
You can install the MySQL service in XAMPP by going to
C:\xampp\mysql folder.
Double click on
mysql_installservice.bat file.
Check in XCP that there is a tick is in the Svc box and MySQL has the green running indication.
Now if you type
net start mysql it will tell you the service is already running.
Next go back to the XCP and Stop MySQL but leave the tick in the Svc box.
Now issue the command net start mysql and it should start the service.
Check by looking in the XCP for the green running next to MySQL.
All should now be working again with no errors.
You can now run mysql from a command console window in
C:\xampp\mysql\bin folder.
start>Run...type
cmdtype
cd C:\xampp\mysqltype at the
C:\xampp\mysql\bin> prompt
mysqlat the
mysql> prompt type
\? to test it works.
You can also type
mysqladmin at the
C:\xampp\mysql\bin> prompt in the bin folder which will give a long list of commands or type your usual commands you typed before but remember if you did not create your database in XAMPP then it may not be available until you export/import from the other instance.
IMHO, phpMyAdmin has a GUI for MySQL and for most people is much easier than the command line -
http://localhost/phpmyadmin - user root no password unless you set one in the Security page in the XAMPP Welcome Page -
http://localhost/security