Flying Sagittarius Posted June 13, 2008 Share Posted June 13, 2008 I have no idea how to connect to my MySQL server. Everything is stored on one server. Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted June 13, 2008 Share Posted June 13, 2008 When connecting to the MySQL server use: localhost as the hostname root as the username no password is set for the root username. MySQL is installed in C:\path\to\xampp\mysql Quote Link to comment Share on other sites More sharing options...
Flying Sagittarius Posted June 13, 2008 Author Share Posted June 13, 2008 Where's the MySQL client (Command line program... the program where I input my queries directly to the server) in relation to the /xampp/ folder? Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted June 14, 2008 Share Posted June 14, 2008 You can use phpMyadmin (which comes with XAMPP) for managing MySQL. If you want to use the command line. Then just open up the Command Prompt (Start > Run > cmd) Then at the command line just type mysql -u root -p and press enter. If XAMPP adds MySQL to the PATH this should work. If it doesn't then you'll have to navigate to the MySQL bin folder first, run the following command to change folders in the command line cd C:/xampp/mysql/bin Then run the mysql -u root -p command again Quote Link to comment Share on other sites More sharing options...
Flying Sagittarius Posted June 14, 2008 Author Share Posted June 14, 2008 thank you everyone, help much appreciated. I'm much more familiar with the command line than phpMyAdmin. And the server is "localhost", right? Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted June 14, 2008 Share Posted June 14, 2008 Yes. Use localhost as the hostname. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.