This is how to use indexing on a mySQL database

How to apply an index to a column in a mySQL table. How to use the "explain" feature to see the cost of a query. How to remove an index. How to compare the difference in cost between an indexed column and a full table scan query.

[@pikaboyny]

Im already a software engineer working but sometimes i like refreshers and you do a great job 👍 thank you

[@shadsluiter]

I appreciate that!

[@tiekamskaidriba3691]

Do you have something on remote connection to mysql database hosted on a private computer, please?

[@shadsluiter]

Good idea. In brief, you need to add a new "root" user with % as the host name. Use the IP address of the host computer to refer to the server. I will create a video that shows these steps since this is a common question with students in my class.

[@tiekamskaidriba3691]

@@shadsluiter Thank you for reply. But why exactly "root" user? I want to create "test" user and restrict the rights of actions. And it just doesn't work somehow with the ip address. I am thinking if the problem exists because my (host) computer is connected to internet through a hotspot from my mobile phone. Or my friend does not have sql installed on her computer while using Workbench, or Windows is preventing connection to my virtual sql server. Or... I feel so lost...