search for: mysqld

Hello, I've only had experience with PostgreSQL sofar, but have now to install MySQL (and WordPress) 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 s...

i was trying to setup an application checked out from svnin my local machine. i managed to do all that is required except when it came to the step of creating databases for the application, when i tried to connect to mysql i got this error ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock'' (2) i have spent more than 5

I just installed CentOS 3.5. Included in the install was mysql. When trying to start it using: service mysqld start. The system responds with mysqld not recpognized as a service. When trying to use /usr/bin/mysql I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). A search of the system does not reveal mysql.sock. Anyone...

i have an app im installing that tries look for mysqld.sock in /var/run/mysqld/mysqld.sock and mysql puts it at /var/lib/mysql/mysql.sock. if i point mysql at /var/run the app works i.e mysqld -socket=/var/run/mysqld/mysqld.sock; if i don''t i get an error that goes " Showing app/views/articles/index.rhtml where line #35 raised: No such...

...already running: mysql 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...

...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...

I have a huge mysql.log file full of errors. I'd like to sort it by the most common line, and work from there. I did go through the manpage for sort, and googled a bit, but I found nothing relevant. Here is an example of the output: [root@ log]# tail mysqld.log 110925 11:05:35 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './ox_data_summary_ad_hourly.MYI'; try to repair it 110925 11:05:35 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './ox_data_summary_ad_hourly.MYI'; try to repair it 110925 12:05:28 [ERROR] /us...

Hi; I installed mysql using yum, so I have an /etc/init.d/mysqld file. For some reason, however, mysqld doesn't boot on reboot of the machine. Please advise. TIA, Victor -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20091110/3a8a8747/attachment-0003.html>

Bug, explainable, or expected?? Checking the status of mysqld as root, then as a regular user: # /etc/init.d/mysqld status mysqld (pid 4806) is running... $ /etc/init.d/mysqld status mysqld dead but subsys locked

Quoting Chris Lattner <clattner at apple.com>: Dear staff, I am using the ds-aa to pass mysqld. I compile mysqld 4.0.12 statically (compile all libraries statically to the executable) and got the bc file, named it as mysqld.bc3. I use the command to pass: opt -load <poolalloc install dir>/lib/libLLVMDataStructure.so -ds-aa mysqld.bc3 -print-alias-sets -disable-output...

...(/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:...

Nothing I have 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=/...

...modev kernel: HighMem: empty Jun 18 08:45:21 lemodev kernel: Swap cache: add 362182, delete 362182, find 132895/144029, race 0+0 Jun 18 08:45:21 lemodev kernel: Free swap = 0kB Jun 18 08:45:21 lemodev kernel: Total swap = 1048568kB Jun 18 08:45:21 lemodev kernel: Out of Memory: Killed process 997 (mysqld). Jun 18 08:45:21 lemodev kernel: oom-killer: gfp_mask=0x1d2 Jun 18 08:45:21 lemodev kernel: DMA per-cpu: Jun 18 08:45:21 lemodev kernel: cpu 0 hot: low 32, high 96, batch 16 Jun 18 08:45:21 lemodev kernel: cpu 0 cold: low 0, high 32, batch 16 Jun 18 08:45:21 lemodev kernel: Normal per-cpu: empty J...

...11700 R 2.3 2.1 0:46 httpd 3151 apache 15 0 17644 17M 11588 R 1.7 2.2 1:16 httpd 3373 apache 16 0 16772 16M 11704 R 1.7 2.1 0:57 httpd 3174 apache 16 0 17632 17M 11608 R 1.5 2.2 1:12 httpd 3214 mysql 16 0 84056 64M 2652 R 1.4 8.5 0:07 mysqld-max 3479 apache 15 0 17608 17M 11612 R 1.4 2.2 0:51 httpd 3152 mysql 15 0 84056 64M 2652 R 1.0 8.5 0:08 mysqld-max 3215 apache 16 0 17636 17M 11588 R 1.0 2.2 1:08 httpd 3477 mysql 16 0 84056 64M 2652 R 1.0 8.5 0:06 mysqld-max 3531 apache...

Hi. I started mysqld.exe using Wine and it seems to work. But when I try to connect the server seems to answer somehow (connection is established, telnet works) but it seems that no communication takes place. mysql freezes and in telnet no response is shown. Any idea what this could mean? Running in Windows without an...

Quoting hc2428 at columbia.edu: Dear staff, Here is the bc file. Heming > Quoting Chris Lattner <clattner at apple.com>: > > Dear staff, > I am using the ds-aa to pass mysqld. I compile mysqld 4.0.12 > statically (compile all libraries statically to the executable) and > got the bc file, named it as mysqld.bc3. > I use the command to pass: > > opt -load <poolalloc install dir>/lib/libLLVMDataStructure.so -ds-aa > mysqld.bc3 -print-alias-sets...

I just did an unwanted mysql upgrade and am now unable to start the mysql service. After doing some searching the common solution is to just create a symlink ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock The issue for me is I don''t have the file I am trying to symlink to (/var/run/mysqld/mysqld.sock) If I try to start mysql manually (mysql start) I get the error: # mysql start ERROR 2002 (HY000): Can''t connect to local MySQL server through socket '...

On Wed, May 13, 2009 at 1:36 PM, <hc2428 at columbia.edu> wrote: > Quoting Chris Lattner <clattner at apple.com>: > > Dear staff, >     I am using the ds-aa to pass mysqld. I compile mysqld 4.0.12 > statically (compile all libraries statically to the executable) and > got the bc file, named it as mysqld.bc3. >     I use the command to pass: > > opt -load <poolalloc install dir>/lib/libLLVMDataStructure.so -ds-aa > mysqld.bc3 -print-alias-sets...

...with rails. I have stopped when I want to use scaffold. as it is mentionned in the book: ruby script/generate scaffold Product Admin but i get an error: it said no such file or directory /tmp/mysql.sock I have checked my configuration of mysql and i found that mysql socket is located on /var/run/mysqld/mysqld.scok any help would be appreciated thanks in advance best regards, -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to...

...RROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root at 13gems www]# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) There's no mysqld in the ps wax. Please advise. beno -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20091105/1d721b8a/attachment-0004.html>