similar to: mysql won't start with service, but starts with mysqld_safe

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

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

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

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

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

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 \

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

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:

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

OK so at some point I borked my mysql 4.1.20 installation on my x86_64 system. Possibly relevant: I have enabled the centosplus repository in yum.conf because I needed a package from there. I have not upgraded mysql from there. Everything was working, then "something" aparrently happened, and now mysql won't start. The logs say: 061031 11:37:38 mysqld started 061031 11:37:38

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

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

This should be an easy one. I'm trying to get postfix going. I've never done this before. I followed the directions at http://wiki.centos.org/HowTos/postfix. I opened port 25: iptables -I INPUT -p tcp -m tcp --dport 25 -j ACCEPT Here's an attempt to send mail: [motor at localhost motor]# mail -v larry.martell at gmail.com Subject: test test . EOT larry.martell at gmail.com...

On Thu, Mar 12, 2015 at 8:57 AM Tim Dunphy <bluethundr at gmail.com> wrote: > 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

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* > 3) yum install -y mariadb-server > installed mariadb-5.5.50-1.el7_2.x86_64 from

Hi All, I have two servers, one is centos 4.3 (new) and other is rh9 (old). Both of them run mysql as the primary database server. I installed mysql via the rpms available in mysql.com downloads. Recently when i 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)

On Mon, Dec 11, 2017 at 4:32 PM, Larry Martell <larry.martell at gmail.com> wrote: > On Mon, Dec 11, 2017 at 4:25 PM, Clint Dilks <clintd at scms.waikato.ac.nz> wrote: >> On Tue, Dec 12, 2017 at 10:09 AM, Larry Martell <larry.martell at gmail.com> >> wrote: >> >>> On Tue, Dec 5, 2017 at 8:22 AM, Pete Biggs <pete at biggs.org.uk> wrote:

On Mon, Oct 2, 2017 at 5:29 PM, Stephen John Smoogen <smooge at gmail.com> wrote: > On 2 October 2017 at 17:21, Larry Martell <larry.martell at gmail.com> wrote: >> I an running CentOS7 in a docker container. I need to send email from >> that container so I installed sendmail and then I run: >> >> m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf` and when