
When you delete every records from a table, which has an AUTO Increment ID field, the *delete* option will not reset the* Auto Increment *number. For example, if the table had 5 rows, and you deleted all the rows (either one by one or through _delete from tablename where 1;_), and then if you insert a new row, it will get a ID value as **6 **not as **1**. Because the auto increment value is not reset.

The easiest way to reset the auto increment number is to use the query **truncate tablename; **which removes all the rows from that table and resets the auto increment back to 1.

But if you want to do it visually, phpMyAdmin provides options for that:

![][1]

[1]: https://veerasundar.com/img/2012/04/auto-increment.png "auto-increment-mysql"

1.  In phpMyAdmin, open the table for which you want to reset the auto increment number.
2.  Then go to: **Operations -> Table Options. **
3.  Reset the **AUTO_INCREMENT **field to whichever value you want and save the changes.

That's it. The next time, when you insert new records, they will start from the auto increment number you set above.


How to reset Auto Increment back to 1 in XAMPP MySQL using phpMyAdmin


So, you have installed XAMPP on windows, [changed its server port][1] to a different number other than 80 and [changed the MySQL *root* password][2] to a more secure one. Now its the time to create some HTML files that will be served by XAMPP server.

[1]: https://veerasundar.com/blog/how-to-change-xampp-server-port "How to change XAMPP server port?"
[2]: https://veerasundar.com/blog/how-to-change-the-root-password-for-mysql-in-xampp "How to change the 'Ëœroot' password for MySQL in XAMPP?"

By default, XAMPP serves any file that is located under the directory *[xampp\_installation\_folder]/htdocs, * which means that you have to copy all your HTML/PHP files inside this directory. But what if you maintain a different folder for all your projects files and you want XAMPP to serve them too along with _htdocs_?

Lets make XAMPP to do this.

1.  Open the file *[xamp\_installation\_folder]/apache/conf/httpd.conf* in any text editor.
2.  Copy below lines after the _htdocs _ element after changing the directory to your own folder.

            Options Indexes FollowSymLinks Includes ExecCGI
            AllowOverride All
            Order allow,deny
            Allow from all

3.  Then search for this string: . Inside that element, add a new alias as followed:
    Alias /yoursite/ "C:/path/to/your/folder/yoursite/"

4.  Save the file and restart the XAMPP server.

After this, if you have a website named 'Ëœyoursite' inside the folder *'Ëœc:/path/to/your/folder'* you can access it directly by using the URL: _http://localhost:8080/yoursite/ _(assuming you have [changed XAMPP port][3] to 8080).

[3]: https://veerasundar.com/blog/how-to-change-xampp-server-port "Change XAMPP server port"


Making XAMPP to serve any directory outside htdocs


If you've installed both [XAMPP][1] and Skype in you system and wondering why the things are not going well when you run these two applications simultaneously, then you are not alone. There are a good number of folks who are complaining about this conflict between XAMPP and Skype. The reason behind this is simple - both Skype and XAMPP by default uses the same port number 80. So, when you start one application first and the other application later, there will be port conflict and the second application will fail to work properly.

[1]: https://veerasundar.com/blog/xampp-apache-mysql-php-perl-environment-in-windows "XAMPP - Apache, MySQL, PHP, Perl environment in Windows"

So, how to fix it? Easy. Change the port number of XAMPP server or disable the usage of port 80 in Skype. To do the first one you can check out my earlier post [How to change XAMPP server port][2]. To disable the port 80 in Skype, follow below steps:

[2]: https://veerasundar.com/blog/how-to-change-xampp-server-port "How to change XAMPP server port?"

1.  Start Skype.
2.  Go to **Tools >> Options >> Connections**.
3.  Uncheck the use of Port 80 as an alternative port.

And, you are done!


XAMPP conflicts with the Skype port


Follow these steps to change the XAMPP server port number:

1.  Stop the XAMPP server, if it is running already.
2.  Open the file **[XAMPP Installation Folder]/apache/conf/httpd.conf**.
3.  Now search for the string `Listen 80` (I'm assuming that your XAMPP was using the port 80. Otherwise, just search for the string 'Listen'). This is the port number which XAMPP uses. Change this 80 to any other number which you prefer.
4.  Then search for the string `ServerName` and update the port number there also.
5.  Now save and re-start XAMPP server and you are done.

## Why do we need to change the port number?

Because, these days, it is very common that a web developer needs to have multiple web servers running, all at the same time. For example, an XAMPP server can be used to run the local WordPress blog, while a JBoss server also needs to be up for testing a java web applications. In such scenarios, if two or more servers are trying to use the same port number, then the late comer will fail to get the port. So, it becomes necessary to change any one server's port number to avoid the conflict.


How to change XAMPP server port?


By default, when you install XAMPP in your windows machine, the `root` password for the MySQL is set to empty. But this is not recommended, as the MySQL database without a password will be accessible to everyone. To avoid this, a proper/secure password must be set to the user `root`. To do it in XAMPP, there are two ways.

## Method 1: reset XAMPP MySQL root password through web interface:

After you started your XAMPP server, go to the browser and type the URL **http://localhost/security/** (incase you've [modified XAMPP server port][1], you need to include that port number also in previous URL). The security page will be shown where you can change the `root` password for MySQL. This will update the phpMyAdmin config also.

[1]: https://veerasundar.com/blog/how-to-change-xampp-server-port "How to change XAMPP server port?"

## Method 2: reset XAMPP MySQL root password through SQL update:

1.  Start the Apache Server and MySQL instances from the XAMPP control panel.
2.  After the server started, open any web browser and give **http://localhost:8090/phpmyadmin/** (if you are running XAMPP on 8090 port). This will open the phpMyAdmin interface. Using this interface we can manager the MySQL server from the web browser.
3.  In the phpMyAdmin window, select _SQL_ tab from the right panel. This will open the SQL tab where we can run the SQL queries.
4.  Now type the following query in the textarea and click **Go**  
    `UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; FLUSH PRIVILEGES;`
5.  Now you will see a message saying that the query has been executed successfully.
6.  If you refresh the page, you will be getting a error message. This is because the phpMyAdmin configuration file is not aware of our newly set root passoword. To do this we have to modify the phpMyAdmin config file.
7.  Open the file **[XAMPP Installation Path] / phpmyadmin / config.inc.php** in your favorite text editor.
8.  Search for the string `$cfg\['Servers'\]\[$i\]['password'] = '';` and change it to like this, `$cfg\['Servers'\]\[$i\]['password'] = 'password';` Here the 'password' is what we set to the `root` user using the SQL query.
9.  Now all set to go. Save the config.inc.php file and restart the XAMPP server.


This article explains how to change the MySQL root password in XAMPP for windows. When you install XAMPP, the default root password for MySQL would be empty, which is not recommended.

#xampp (5)