search

Category: MySQL


Remote access to a MySQL server running on Ubuntu 18

Posted by in 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:


Resetting the AUTO_INCREMENT value in MySQL

Posted by in MySQL

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


Changing AUTO_INCREMENT value in MySQL

Posted by in MySQL

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


close
search

Hi, guest!

settings

menu