similar to: MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

Hello CentOS users, for a Wordpress 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 \

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

Hello. This is my mysql-server.pp file, both master and client are runing ubuntu. -------------------- class mysql-server { package { "mysql-server": ensure => installed } package { "mysql-client": ensure => installed } service { "mysql": enable => true, ensure => running, require => Package["mysql-server"], } file

looking through logs I noticed this today: grep mysql /var/log/maillog | grep fail Aug 3 17:35:25 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:35:57 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:36:02 dovecot: auth-worker(28335): Error:

Folks I'm having problems installing Mariadb in Centos 7. Here's what I did: 0) Become root 1) Make sure that mariadb and mysql are NOT installed. 2) Delete residual libs rm -rf /var/lib/mysq* 3) yum install -y mariadb-server installed mariadb-5.5.50-1.el7_2.x86_64 from the Centos 'updates' repository 4) systemctl start mariadb 5) systemctl status mariadb

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

Hi, i''ve a big problem in a xenU (256M RAM, 2.6.11.12-xenU, in 3 LVM partition (/, swap and /home) This xenU freeze and crash with this messages in syslog. This xenU work very fine since 2005 september. Is it serious ? What could be the solution ? Regards Franck ############ SYSLOG ...................... Jun 18 08:45:21 lemodev kernel: oom-killer: gfp_mask=0x1d2 Jun 18 08:45:21

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=/var/run/mysqld/mysqld.pid

At 09:36 AM 9/23/2016, you wrote: >On 2016-09-22 18:07, david wrote: > > Folks > > > > I'm having problems installing Mariadb in Centos 7. > > > > > > Here's what I did: > > > > 0) Become root > > 1) Make sure that mariadb and mysql are NOT installed. > > 2) Delete residual libs > > rm -rf /var/lib/mysq* >

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 have set up an cluster with ocfs2 on top of drbd in primary/primary mode. As long as the datadir is in /var/lib/mysql, everything works fine. But as soon as I put the datadir on the ocfs2 filesystem /mnt/data/mysql mysql fails with: [Ubuntu] root at fs2:/etc# mysqld --safe-mode 090930 18:08:14 [Warning] Can't create test file /mnt/data/mysql/fs2.lower-test 090930 18:08:14 [Warning]

Hi, I''ve tried running the mysql daemon on a few different servers running Xen, and seen two different sorts of problems. In one case, on two identically configured systems, the mysql daemon segv''s but restarts immediately. This happened with Xen 2.0.5, I haven''t yet seen it with 2.0.6. It seems to be the same problem as this one:

Hello. I would like to ask about having mysql data hosted on glusterfs. Please see my issue below. I have posted DEBUG log information on pastebin. I am using GlusterFS version: glusterfs 1.4.0rc7 FUSE Version :fuse-2.7.3glfs10 my ISSUE is: When hosting mysql data on glusterfs I have an issue: The first time I start the glusterfsd server using [root at mohan ~]#

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

Hey everybody, I'm trying to get mysql master/slave replication to work under SSL. I've created the certs for both the slave and the master. I've configured the master and slave my.cnf. And it does appear that replication is actually working. Master is actually MariaDB (version 5.5.41-MariaDB-log, and the slave is MySQL (version 5.5.41-log). But there are two issues I'd like to

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

Hey all, I've been having some trouble creating a mysql user that can connect to the database from localhost. It's always been a straight forward thing to do in the past, so its time for a sanity check, if you guys don't mind. Ok, so here's the actual command with actual simplified password that I'm using. It's on localhost so I don't think it's a security threat

> > No: /etc/pki/CA should NOT be group writeable. Ditto for > /etc/pki/tls/cernts and private Ok, yeah I can understand that. I'll correct it. Still need a way to get SSL enabled however. Any suggestions there? Thanks Tim On Thu, Mar 12, 2015 at 11:40 AM, <m.roth at 5-cent.us> wrote: > Tim Dunphy wrote: > >> > >> The mysqld process runs as the mysql

Hi, Can anyone help me out re how I change the startup options for mysql (v5.0) running on my Mac? (I just want to add the "--log" option is about it). I tried doing "sudo ./Library/StartupItems/MySQLCOM/MySQLCOM restart" however this started a 2nd instances of mysql & mysqld. Here is what I see start after Mac startup if this helps: $ ps aux | grep mysql _mysql 137 0.0

I'm having some problems getting two nodes to mount a shared gluster volume where I have the MySQL data files stored. The databases are Innodb. Creating the volume on the master server works fine and it mounts, and when I mount that on the first mysql node it works fine, too. However, when I try to mount it with the second node I get this error: InnoDB: Unable to lock ./ibdata1, error: 11