similar to: MySQL server install with datadir != /var/lib/mysql

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

I had to put a new HD in, and now I''m reinstalling everything, and can''t get mysql to fully work. I can''t remember how I fixed it. I''ve searched everywhere online and can''t find anything. when I try to use the >mysql command I get this: Can''t connect to local MySQL server through socket ''/tmp/ mysql.sock'' (2) My first

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

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

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

Hi, Using this module https://forge.puppetlabs.com/puppetlabs/mysql as described on documentation: class { ''mysql::server'': config_hash => { ''root_password'' => ''foo'' } } But, couldn''t set password after logging getting error: Access denied for user ''root''@''localhost'' (using password:

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

Hi, I'm trying to move the MySQL data directory to /home/mysql like I have done with every other install I have done before but the difference is this time I am trying to have SELinux active instead of turning it off. I seem to need some help in a) Understanding what the selinux failure messages are saying; and b) How to correct the issue I've read the selinux docs and all I got was a

Hi everyone, I am new to Puppet and try to make some simple "automation things". I have succeed with apache2, ssh modules, but have problems with Puppetlabs mysql module. It installs mysql server, changes/creates admin user password, but does not create database and user. I cannot find anything wrong in logs (--debug --verbose). I see that manifests is read, but no db/user in 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

Hello people, i asked for help due to connection problems to servers installed in my "xendbsrv00" domain. the problem still exists even if iptables and ip6tables are disabled on both sides. the connection to the sshd on my domain works perfectly. I still was not able to figure out why i can connect to sshd, but not the the installed mysqld and postgres daemons. Greetings thomas

You know, I suppose I could simply install the tarball, I've successfully installed mysql in the past that way. However, I thought I'd use yum, install the redhat/CentOS way, and I am amazed how hard it is to get this thing working. I admit to not having become all that familiar with mysql. Anyway, when I run # mysql_install_db --user=mysql I get a bunch of errors: 070321

I am trying to configure mysql to use a different datadir than default in order to move this to a larger volume. I have copied all mysql data from /var/lib/mysql to my new volume and ran both chown -R mysql:mysql * and chmod -R 660 * in order to setup correct ownership and rights for the data. It was working for a few days until today upon going into mysql and typing show databases, I receive

Hi; Since I decided to "yum remove openssl", genius that I am (not!), I managed to screw up the OS so badly the server co. had to rebuild it for me <:-) These good people backed everything up very well, so the damage was minimal. Now I'm trying to rebuild MySQL. I did the "yum install mysql" no problem. However... [root at 13gems old]# /etc/init.d/mysqld start -bash:

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 installer works so it has to be some problem with wine somehow. Using Ubuntu

Hi I am finishing my mail server config and just trying to get the mysql login working - it fails to connect and thorws the following error Mar 21 21:58:21 mail0 authdaemond: failed to connect to mysql server (server=localhost, userid=courier): Can't connect to local MySQL server through socket '/tmp/mysql.sock.' (2) Mar 21 21:58:21 mail0 couriertcpd: LOGIN FAILED, user=tom at

Hi, I am having Mysql connection problem for my first AddressBook application (which I took it from http://www-128.ibm.com/developerworks/linux/library/l-rubyrails/) I have gem installed the latest ruby, rails, lighttpd, fastcgi, mysql-4.1.14 on linux. Everything looks good. When I do: mysql -h localhost -u test -ptest -D AddressBook mysql> SELECT COUNT(*) FROM contacts; +----------+ |

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

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]

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