Ubuntu – Does installing thesql-server include thesql-client as well

aptMySQLserver

I was wondering what the difference is between mysql-server and mysql-client and came upon this stackoverflow post explaining the difference. I was curious if installing mysql-server also included mysql-client. So, after creating a fresh AWS Ubuntu instance, I ran which which mysqld and which mysql to confirm nothing came preinstalled with the AWS instance, and sure enough both commands returned nothing. However, after running sudo apt install mysql-server, when I ran which mysql and which mysqld they both returned something: which mysqld returned /usr/sbin/mysqld and which myself returned /usr/bin/mysql, suggesting that my installation of mysql-server installed both the client and the server. Is that accurate? As I mentioned, the stack overflow post I visited earlier indicated they were distinct pieces of software, so I'm wondering why installing mysql-server would install the client as well?

Best Answer

They are separate pieces of software, but installing mysql-server installs mysql-client as well, because you can use mysql-client to connect to the server, even over localhost. If you look at the package listing for mysql-server, you will see it depends on mysql-server-8.0, which depends on mysql-client-8.0, causing apt to install the client as well.

Related Solutions

Ubuntu – unable to locate package thesqld-server

You want to install mysql-server, which does exist in 12.04.

If you can't find it maybe you've done a clean install and haven't done an update yet, so do the following:

sudo apt-get update
sudo apt-get install mysql-server

If that doesn't work update your question with what happens.

Ubuntu – Can’t start MySQL server if the .sock file is changed in /etc/thesql/the.cnf

By looking at this line in the following line in the log, it appears that Apparmor is denying access.

Jan  2 12:09:36 praveshp-lt kernel: [ 7060.098580] type=1400 audit(1357108776.036:33):
     apparmor="DENIED" operation="mknod" parent=6702 profile="/usr/sbin/mysqld" 
     name="/run/mysqld/mysqld1.sock" pid=7039 comm="mysqld" requested_mask="c"
     denied_mask="c" fsuid=116 ouid=116

To allow this, add a file /etc/apparmor.d/local/usr.sbin.mysqld with the entry below, and restart MySQL.

/var/run/mysqld/mysqld1.sock w,

Thanks to Rinzwind for pointing this out.

Best Answer

Related Solutions

Ubuntu – unable to locate package thesqld-server

Ubuntu – Can’t start MySQL server if the .sock file is changed in /etc/thesql/the.cnf

Related Question