MySQL

SSH into Ubuntu Allow MySQL service listen on the server IP address instead of 127.0.0.1 Under [msqld], change bind-address = 127.0.0.1 to the db_server_IP_address. Restart the MySQL server: Allow SQL traffic through the firewall: Create a new user with permissions: Update an existing database and user to allow remote access:

How do I remove all data from a table and reset the AUTO_INCREMENT value back to 1? TRUNCATE database_name.table_name  

How do I change the AUTO_INCREMENT value? ALTER TABLE database_name.table_name AUTO_INCREMENT=5000