similar to: mysql secure installation and multi mysqld

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

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

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

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

Hi all, I am trying to configure utf8 in mysql under centos6 to display special characters, like accents. I use this mysql instance to store plain syslog logs. I have configured this under my.cnf: [mysqld] init_connect = 'SET collation_connection = utf8_general_ci' init_connect = 'SET NAMES utf8' character-set-server = utf8 collation-server = utf8_general_ci [client]

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'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; 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:

Not sure if there is an app like this yet. I want to keep tabs on my web applications and thought of using a 'page checker'/ I was thinking either running a sum on the directory or each file...but thinking a simple date check would be fine. The idea is web application, except the uploads area for photos, never has changes to its files except when I change it. However, if it gets

I put this page together just so I won't spam the board anymore begging for help..lol http://bobhoffman.com/vmissue.html This shows a working effort of bonded eths, bridged into a vm, and a few other things. The only missing thing is something on the host that ends up putting the VM internet connection into some kind of limbo. Whether it is hardware related, bug related, libvirt nat

Has anybody sucessfully used puppetlabs-mysql (or some other method) to install MySQL-server on Linux with a my.cnf where datadir != /var/lib/mysql ? -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view

Okay, Yahoo is bumming me. Only system my mail is having an issue with. All mail is accepted, but junked. I can only think it is the DKIM/Domain keys. It is apparent that the dkim-milter is not part of the centos 5.x distro nor is it part of the mirrors, as far as I can tell. So...have any of you done it with your servers for sendmail? There are some sites that claim to have rpms and I have

Hi All: I'm trying to get mysql 5 installed on my CentOS 4.6 installation. I've installed mysql using yum: yum -y install perl-DBD-MySQL mysql-server mysql php-mysql mod_auth_mysql phpmyadmin mysqlclient Yum says it installed fine: Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package phpmyadmin.noarch 0:2.11.4-1.el4.rf set to

Hi; It's been a while since I controlled my own server and I'm rusty. Trying to install mysql yum install mysql All looks well. Here's what happens: [root at 13gems www]# mysql ERROR 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

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

I have been reading the threads on here with great ernest about redhat making a move to throw off centos compilations. I read some stories about microsoft wanting to work closer with centos http://www.theregister.co.uk/2011/05/17/microsoft_and_centos/ I have to update to centos 6 due to some needs of clients who need newer mysql and php (and installing them on centos5 was too hard for me). I

Hate to ask, but after reading the last few months of centos history online I am worried. And to learn the lead guy seems to have absconded with the cash and left all the hard working devs high and dry..well that is scary. They all worked so hard and who knows what will happen now. If centos falls I have no choice but to go to redhat. I am wondering if the conversion will be easy or a complete

Perhaps I am trying to do the impossible. centos6, spamassassin, procmail, dovecot, postfix. Postfix, by default, accepts all incoming mail to any user listed in the shadow/passwd and alias files. I cannot find a way to stop that without manually blocking each non wanted user (like nobody, apache) without killing local delivery. For most of the users listed in those files, who cares. However

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