Access of MySQL on command line

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

Access of MySQL on command line

Postby ucas » 15. August 2010 11:15

Hi. I use Windows 7. I use beta version of XAMPP. I uploaded sql files, created databse user. Now how to access that database over windows command line?
Cheers :roll:
ucas
 
Posts: 8
Joined: 07. August 2010 12:43

Re: Access of MySQL on command line

Postby JonB » 15. August 2010 13:14

Thanks to your lack of self-control and incredibly discourteous post on the other topic, I won't be answering your question.

BTW <> this particular question has nothing to do with XAMPP, rather your impatience and complete lack of knowlege. Get a book or tutuorial on MySQL.

:evil:
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: Access of MySQL on command line

Postby ucas » 15. August 2010 13:34

I am trying to obtain some skills on SQL language. But still that is not the main subject I am interested in. Thus I am trying to spend just few moments on irrelevent things. Time goes so fast......
ucas
 
Posts: 8
Joined: 07. August 2010 12:43

Re: Access of MySQL on command line

Postby JonB » 16. August 2010 04:49

ucas -

Thank you for the sincere apology you sent me.

You can either use the MySQL command line tools with arguments for specific tasks
Open a command window at C:\xampp\mysql\bin

then use (for instance) mysqldump.exe (with parameters) to backup Databases and/or tables
or
mysqladmin - to administer the databases with command lne directives

To start a session for manipulating MySQL databases with SQL statements/directives
Open a command window at C:\xampp\mysql\bin
Type
mysql.exe -u 'root' -p 'yourpassword'
This will start the MySQL monitor - some call it the MySQL shell - but the correct name is Monitor (works the same on any platform basically)

OR use this clever tool 'MySQL Workbench' (which I use) its a local GUI Client to design/build/use MySQL databases. (works with any MySQL database - local or remote- uses Connect [obviously]) :mrgreen:

http://wb.mysql.com/

Good Luck
:)
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: Access of MySQL on command line

Postby ucas » 16. August 2010 09:22

No problem. Thanks for info.
ucas
 
Posts: 8
Joined: 07. August 2010 12:43


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests