To import sql file to the database through command

 mysql -u root -p abc < data.sql

To see  what are the instance running on particular port

sudo lsof -i :3306

The command sudo lsof -i :3306 is used to list open files associated with the MySQL server, which typically runs on port 3306. This command provides information about processes that have opened files or network connections on the specified port.

Here's a breakdown of the command:

• sudo: This is used to run the command with elevated privileges, allowing you to view information about all processes, including those owned by other users.

• lsof: This command stands for "list open files." It is used to show information about files that are opened by processes.

• -i :3306: This option specifies that you want to filter the results based on a specific network port, in this case, port 3306. This is the default port for MySQL.

When you run this command, you will get a list of processes that have opened files or network connections on port 3306. This can be helpful for troubleshooting or monitoring MySQL-related activities on your system.

You can stop through

sudo kill PID

If you want to forcefully terminate the process, you can use the kill -9 option, like this:

sudo kill -9 PID

you can stop mysql server through below commands

sudo service mysql stop
sudo service mysql start
sudo service mysql status

sudo systemctl stop mysql
sudo systemctl status mysql
sudo systemctl start mysql


export DATABASE_URL=mysql://root:root@localhost:3306/testdb?charset=utf8mb4

extra content

<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-ZFY4X8C654"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-ZFY4X8C654');
</script>




G-ZFY4X8C654


8079368677



https://www.websitepolicies.com/cookie-consent-banner-generator

https://stefanbschneider.github.io/blog/posts/django-google-analytics/index.html