Page 1 of 1

how to connect to mySQL

PostPosted: 22. March 2011 01:22
by laode
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

Re: how to connect to mySQL

PostPosted: 22. March 2011 01:46
by Altrea
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.