Menu
recently I've installed Mysql and it turns out the service name of it is "mysql" (there no "d" suffix), I remember before this time it's "mysqld" all the time. And when you type in "sudo service mysqld status" it would say this service does not exists.
Is there any difference between this two? Or it's a total diffrent version of mysql?
240
MySQL isisAn information technology system (IT system) is generally an information system, a communications system, or, more specifically speaking, a computer system — including all hardware, software, and peripheral equipment — operated by a limited group of IT users.https://en.wikipedia.org › wiki › Information_technologyInformation technology - Wikipedia a database management system. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server.
So if you are using one user for your client, it won't be a problem and is more secure than the previous versions. Since MySQL leverages the most up-to-date hardware and software, it changes its default variables. You can read here for more details. Overall, MySQL 8.0 has dominated MySQL 5.7 efficiently.
MYSQL Server, or mysqld is the database server program.It manages access to the actual databases on disk or in the memory. MYSQL Client are programs for communicating with the server to manipulate the information in the databases that the server manages.
"d" stands for "daemon" and this is the server service. mysql is the command-line client program. This is for Windows and Linux, didn't test for other OSes
104
Don't worry about service names - they can be customized... by default, mysql takes MySQL as service names on windows machines.
If you want to change the service on either machine, just uninstall the service..
/path/to/mysql/bin/mysqld --remove mysql
Now, you can rename it... say Neelima
/path/to/mysql/bin/mysqld --install Neelima
Now you will see a service name called Neelima for MySQL server...
Back to the difference between mysql & mysqld (forget service names here) --
mysql -- a command-line client for executing SQL statements interactively or in batch mode.
mysqld -- the MySQL server.
39
Mysqld = Mysql + D
D stands for Daemon
Pronounced DEE-mun or DAY-mun. Daemon is a process that runs in the background and performs a specified operation at predefined times or in response to certain events.
Hope it clears MySqld
mysql -- A command-line client for executing SQL statements Like Terminal in ubuntu
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
