how to connect to mySQL

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

how to connect to mySQL

Postby laode » 22. March 2011 01:22

Hi,

I know, it's a very newbi-question, but I can't find in any docu of WAMPP-components how to connect to mySQL.

Here is what I got:

I installed XAMPP on windows Vista successfully without any trouble, I started XAMPP-control Panel and from there started Apache + mySQL.

But I can't find how to get a mySQL-command-interface or GUI-tool to work with mySQL !

All I see in mySQL-Tutorial is about using it from command-prompt, but nowhere I find how to get to the prompt for the first time !?

thanks for any hint, Lao De
laode
 
Posts: 1
Joined: 22. March 2011 01:09

Re: how to connect to mySQL

Postby Altrea » 22. March 2011 01:46

Hi laode,
laode wrote:All I see in mySQL-Tutorial is about using it from command-prompt, but nowhere I find how to get to the prompt for the first time !?

The MySQL CLI can be found in the xampp\mysql\bin folder.
So open your Windows command line, navigate to that folder and know you can prompt your mysql.
Start with the connect

e.g.
Code: Select all
C:\xampp\mysql\bin>mysql --user=root db_name


Read more about the MySQL CLI

Or you just type into your Browser http://localhost/phpmyadmin and use it's GUI to administrate/manipulate the Databases.

P.S.: next time take some time to read the forum descriptions before you post. This Board has an english section and several forums!
And it's never a bad idea to post some information about your XAMPP version. For example, the XAMPP 1.7.3 has a Shell Button in it's XAMPP control panel.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests