I have a vague concept of how MySQL works, and there are a few questions
Why I used to php,xampp in the time of the MySQL, now with NODE,NPM again installed MySQL, finally connected to the database, connected to the same database. I guess this is because of the MySQL port, I only know it is 3306 by default. I would like to ask how many of my computer's MySQL installation directory? Where is the path?
I also have access to the same MySQL path with navicat,phpmyadmin, and I wonder how it works.
Mac is different from Linux in file management, for example, I can not directly refer to the Linux system solution when asking questions.
As above is some of my problems, I hope that someone can give a solution, I hope it is better to tell me, the root of these problems is where, it is best to tell me what should be read to find out which documents to understand these problems.
Reply content:
I have a vague concept of how MySQL works, and there are a few questions
Why I used to php,xampp in the time of the MySQL, now with NODE,NPM again installed MySQL, finally connected to the database, connected to the same database. I guess this is because of the MySQL port, I only know it is 3306 by default. I would like to ask how many of my computer's MySQL installation directory? Where is the path?
I also have access to the same MySQL path with navicat,phpmyadmin, and I wonder how it works.
Mac is different from Linux in file management, for example, I can not directly refer to the Linux system solution when asking questions.
As above is some of my problems, I hope that someone can give a solution, I hope it is better to tell me, the root of these problems is where, it is best to tell me what should be read to find out which documents to understand these problems.
The root of your problem is not clear. MySQL is the application of C/s structure, you visit any of the management clients, such as Navicat, phpMyAdmin, and including your PHP and node code, are only using a MySQL client (generally, is based on Libmysql, of course, the latest version of PHP is implemented by its own mysqlnd)
The real MySQL is the default listener 3306 Port server-side program, since you are XAMPP installed, then it should be located under the/application/xampp
MAC OS X's kernel has been modified from BSD, and Linux is much the same, but OS X has a lot of customization to the directory and BSD is also different, so the Linux program for you can refer to but not completely copy, you understand the OS x directory planning is generally no problem.