search for: mysqld_saf

...db.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Thu 2016-09-22 17:46:38 PDT; 4min 3s ago Main PID: 16261 (code=exited, status=1/FAILURE) Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: /usr/bin/mysqld_safe: line 139: /var/log/mysqld.log: Permission denied Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: /usr/bin/mysqld_safe: line 183: /var/log/mysqld.log: Permission denied Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: touch: cannot touch `/var/log/mysqld.log':...

...Press) on a CentOS 6.4 /64 bit server. I have installed the mysql-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # service mysqld start # /usr/bin/mysqladmin -u root password 'xxxxx' # /usr/bin/mysql_secure_installation Then I've noticed that mysqld_safe process is listening at 0.0.0.0 and decided to change that - so that my WordPress installation only uses domain sockets (or unix pipes? not sure). So I've modified the /etc/my.cnf to: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is re...

...server > Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor > preset: disabled) > Active: failed (Result: exit-code) since Thu 2016-09-22 17:46:38 PDT; > 4min 3s ago > Main PID: 16261 (code=exited, status=1/FAILURE) > > Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: /usr/bin/mysqld_safe: line > 139: /var/log/mysqld.log: Permission denied > Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: /usr/bin/mysqld_safe: line > 183: /var/log/mysqld.log: Permission denied > Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: touch: cannot touch > `/var...

Just installed mysql on centos 6.2. When I try to start it with service I get: #service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] Nothing at all is written to the error log. But if I start it with mysqld_safe it comes up and works fine. Anyone know what's going on here? -larry

...(/usr/lib/systemd/system/mariadb.service; enabled; vendor > > preset: disabled) > > Active: failed (Result: exit-code) since Thu 2016-09-22 17:46:38 PDT; > > 4min 3s ago > > Main PID: 16261 (code=exited, status=1/FAILURE) > > > > Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: /usr/bin/mysqld_safe: line > > 139: /var/log/mysqld.log: Permission denied > > Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: /usr/bin/mysqld_safe: line > > 183: /var/log/mysqld.log: Permission denied > > Sep 22 17:46:37 goat.xxx.com mysqld_safe[16261]: touch: can...

...done so far seems to work # cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 max_allowed_packet=2MB [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log-query=/var/log/mysql-query.log empty and then I added to /etc/init.d/mysqld get_mysql_option mysqld_safe log "/var/log/mysqld-query.log" querylogfile="$result" -and- start(){ touch "$querylog...

Hi Guys, I installed CentOS 6 and installed 'yum install mysql mysql-devel mysql-server' When I try and start MySQL I get: 120206 16:42:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 120206 16:42:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120206 16:42:07 InnoDB: Started; log sequence number 0 44233 120206 16...

> > The mysqld process runs as the mysql user. It's parent which is the > mysqld_safe runs as the root user. That being said the mysql user needs > to have at least read permission to the locations where the ssl files are > > located. By default on Centos the /etc/pki/CA/private directory has its > directory permissions to only allow the root user. If the mysql u...

When I run # mysql I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) What do I need to do? The install of MySQL was done as part of the Centos setup. Todd

...l* *ssl-ca=/etc/pki/CA/certs/ca.crt* *ssl-cert=/etc/pki/tls/certs/mysql.crt* *ssl-key=/etc/pki/tls/private/mysql.key* server-id = 1 log_bin = /var/log/mariadb/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M binlog_do_db = jokefire [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid On the mysql slave: [root at ops:~] #cat /etc/my.cnf [mysqld] # Settings user and group are ignored when systemd is used (fedora >= 15). # If you need to run mysqld under different user or group, # customize your sy...

i am at a lost, i setup the db schema , database.yml and etc.... passwords are correct. im getting the below error, im trying to get my dashboard to work .....help any? i also chmod the database.yml file to 660 # mysql -u dashboard -p dashboard_production Enter password: ERROR 1045 (28000): Access denied for user ''dashboard''@''localhost'' (using password:

...swap = 0kB Jun 18 08:45:21 lemodev kernel: Total swap = 1048568kB Jun 18 08:45:21 lemodev kernel: Out of Memory: Killed process 1006 (mysqld). Jun 18 08:45:22 lemodev /USR/SBIN/CRON[23726]: (root) CMD ([ -x /etc/munin/plugins/apt ] && /etc/munin/plugins/apt update 7 Jun 18 08:45:27 lemodev mysqld_safe[23728]: Number of processes running now: 0 Jun 18 08:45:27 lemodev mysqld_safe[23730]: restarted Jun 18 08:45:34 lemodev mysqld[23733]: 060618 8:45:34 InnoDB: Database was not shut down normally! Jun 18 08:45:34 lemodev mysqld[23733]: InnoDB: Starting crash recovery. Jun 18 08:45:34 lemodev mysq...

...sl-cert=/etc/pki/tls/certs/mysql.crt* > *ssl-key=/etc/pki/tls/private/mysql.key* > server-id = 1 > log_bin = /var/log/mariadb/mysql-bin.log > expire_logs_days = 10 > max_binlog_size = 100M > binlog_do_db = jokefire > > [mysqld_safe] > log-error=/var/log/mariadb/mariadb.log > pid-file=/var/run/mariadb/mariadb.pid > > On the mysql slave: > > [root at ops:~] #cat /etc/my.cnf > [mysqld] > # Settings user and group are ignored when systemd is used (fedora >= 15). > # If you need to run mysqld under d...

...press website I have installed mysql-server-5.1.69-1.el6_4.x86_64 and run /usr/bin/mysql_secure_installation on a CentOS 6.4 machine with mucho RAM (32 GB) and I wonder, what would be the best place for the mysqld parameters descibed at http://dev.mysql.com/doc/refman/5.1/en/server-parameters.html mysqld_safe --key_buffer_size=64M --table_open_cache=256 \ --sort_buffer_size=4M --read_buffer_size=1M & Should I just edit the file /etc/init.d/mysqld or is there a better place in CentOS for that (under sysconfig?) Thanks Alex

...do "pstree", i noticed that RH9 server shows many mysql children while centos shows only one. Here is the pstree result. (Both of them runs the same version of mysql) server A (RH9 , MySQL-server-4.1.19-0.glibc23 ) --------------------------------------------------------------------- ??mysqld_safe???mysqld???mysqld???13*[mysqld] and server B (CentOS 4.3 , MySQL-server-4.1.19-0.glibc23 ) --------------------------------------------------------------------- ??mysqld_safe???mysqld my question is, why mysql is showing one process in centos?. I use same my.cnf in both servers. So i believ...

I'm currently re-installing db41 port. Earlier using 'innodb_force_recovery = 6' seemed to fix that PANIC error. But I don't understand this permission error. I've tried various permissions as well 777, 766, 666, 760, etc etc. I've also ran mysqld_safe as root user, but with same permission error. Also tried different directories without luck. When I log in to the server shell, it won't chroot me to my home directory. Instead it puts me in '/' with error message "no .bash_login. And when I log out I get message "no .bas...

...t: auth-worker(29721): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist looking at mysqld.log, all i see is: 120721 17:58:44 InnoDB: Shutdown completed; log sequence number 0 76814 120721 17:58:44 [Note] /usr/libexec/mysqld: Shutdown complete 120721 17:58:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 120721 17:59:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120721 17:59:54 InnoDB: Initializing buffer pool, size = 8.0M 120721 17:59:54 InnoDB: Completed initialization of buffer pool 120721 17:59:54 InnoDB: Start...

...l root@cloneubuntu:/var/log/mysql# cat /var/log/mysql/error.log root@cloneubuntu:/var/log/mysql# ps ax | grep sql 4797 pts/0 S+ 0:00 grep --color=auto sql root@cloneubuntu:/var/log/mysql# cat /etc/mysql/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-external-locking bind-address =...

...helps: $ ps aux | grep mysql _mysql 137 0.0 0.5 635228 9760 ?? S Wed03PM 2:47.21 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/Macintosh-2.local.pid root 100 0.0 0.0 600172 496 ?? S Wed03PM 0:00.02 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/Macintosh-2.local.pid greg 53283 0.0 0.0 599700 372 s002 R+ 11:44AM 0:00.00 grep mysql QUESTION: So how can I determine what Mac startup component/files culminate in the above-mentioned mysqld & mysql startup? Thanks -- Greg...

Funny current debian service files use a wrong PIDFile path (should be /var/run/amba/samba.pid). If I use Type=forking and an wrong PIDFile systemctl start samba must be CTRL-C'ed. Type=notify works with or without an proper PIDFile. Am 12.07.2016 um 22:47 schrieb Sonic: > On Tue, Jul 12, 2016 at 4:29 PM, Achim Gottinger <achim at ag-web.biz> wrote: >> Does your PIDFile