[mysql] How do I use MySQL through XAMPP?

I installed XAMPP v3.2.1 because I wanted to learn how to create database in MySQL and learn more about TOMCAT. However, I am a little confused about what to do now. I have read many blogs and the documentation on this page http://dev.mysql.com/doc/refman/5.0/en/creating-database.html.

While following the directions I found that: I can't access my local host.

Attempted Solution: I shut down skype because I read that might be an issue. I don't have any older versions of XAMPP on my computer and I don't believe I am connected to any other servers. So, I don't have permission to do anything.

OR

Am I trying to access mysql through the wrong command prompt? I am trying to use MySQL from the XAMPP shell. I am not sure why I cannot get everything working. Am I going about this the wrong way?

Thanks for any help

XAMPP Apache + MariaDB + PHP + Perl (X -any OS)

• After successful installation execute xampp-control.exe in XAMPP folder

• Start Apache and MySQL

• Open browser and in url type localhost or 127.0.0.1

• then you are welcomed with dashboard

By default your port is listing with 80.If you want you can change it to your desired port number in httpd.conf file.(If port 80 is already using with other app then you have to change it).

For example you changed port number 80 to 8090 then you can run as 'localhost:8090' or '127.0.0.1:8090'

Changing XAMPP Default Port: If you want to get XAMPP up and running, you should consider changing the port from the default 80 to say 7777.

• In the XAMPP Control Panel, click on the Apache – Config button which is located next to the ‘Logs’ button.

• Select ‘Apache (httpd.conf)’ from the drop down. (Notepad should open)

• Do Ctrl+F to find ’80’ and change line Listen 80 to Listen 7777

• Find again and change line ServerName localhost:80 to ServerName localhost:7777

• Save and re-start Apache. It should be running by now.

The only demerit to this technique is, you have to explicitly include the port number in the localhost url. Rather than http://localhost it becomes http://localhost:7777.

<?php
if(!@mysql_connect('127.0.0.1', 'root', '*your default password*'))
{
    echo "mysql not connected ".mysql_error();
    exit;

}
echo 'great work';
?>

if no error then you will get greatwork as output.

Try it saved my life XD XD