Linux – Should both thesqld_safe and thesqld be running at the same time on startup

centoslinuxMySQL

On launching my CentOS VPS (setup by someone else), MySQL starts two processes on boot:

mysql : /usr/libexec/mysqld –basedir=/usr –datadir=/var/lib/mysql –user=mysql
root: /bin/sh /usr/bin/mysqld_safe –datadir=/var/lib/mysql –socket=/var/lib/mysql/mysql.

Is this normal / the correct way to setup MySQL (that root is running mysqld_safe?)

Thanks!

Yes, that's the way it's supposed to be. mysqld_safe spawns a mysql-user run daemon (mysqld).

If you are having problems connecting through socket, you may try connecting to your mysql server via tcp:

mysql -h localhost

Or using username/password:

mysql -h localhost -u root -p

Either one may work depending on how the users are set up. If you get this error it means that the mysql command is at least talking to the server:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

In general on Linux systems, an Errno 13 means Permissions Denied or Access Denied.

What's the output of

# ls -ld /var/log/mysql
# ls -l /var/log/mysql

Does this match with your MySQL user?

If not, suggested solution (providing mysql is your mysql user and mysql is your group):

chown -R mysql:mysql /var/log/mysql