Re: [CentOS] mysql-connector-odbc i686 package

El 30/7/20 a las 4:51, sthustfo escribió: > Hi all, > > I am looking for a i686 package (32 bit) for mysql-connector-odbc. However, > I could locate only the x86-64 version on the repositories. Not much of a > DB person but trying to connect to a 64bit MySQL server on remote host. > > Any suggesti

Re: [CentOS] mysql-connector-odbc i686 package

If you can find the RPMS, you could rebuild for I686. -Original Message- From: CentOS On Behalf Of sthustfo Sent: Wednesday, July 29, 2020 9:52 PM To: CentOS mailing list Subject: {EXTERNAL} [CentOS] mysql-connector-odbc i686 package CAUTION:  This email originated outside of BSWH

[CentOS] mysql-connector-odbc i686 package

Hi all, I am looking for a i686 package (32 bit) for mysql-connector-odbc. However, I could locate only the x86-64 version on the repositories. Not much of a DB person but trying to connect to a 64bit MySQL server on remote host. Any suggestions where I can locate the i686 package? Is there a mar

Re: [CentOS] MySQL on Centos 7 (armv7)

On 06/03/2017 08:52 AM, Johnny Hughes wrote: On 06/03/2017 08:19 AM, Leon Vergottini wrote: Dear Community I am trying to install MySQL 5.6 on a Raspberry PI 3B. Using my normal procedure by downloading the yum repo rpm and installing MySQL through that is not working. There is no r

Re: [CentOS] MySQL on Centos 7 (armv7)

On 06/03/2017 08:19 AM, Leon Vergottini wrote: > Dear Community > > > > I am trying to install MySQL 5.6 on a Raspberry PI 3B. Using my normal > procedure by downloading the yum repo rpm and installing MySQL through that > is not working. There is no rpm information for arm7. > > > > C

[CentOS] MySQL on Centos 7 (armv7)

Dear Community I am trying to install MySQL 5.6 on a Raspberry PI 3B.   Using my normal procedure by downloading the yum repo rpm and installing MySQL through that is not working.  There is no rpm information for arm7. Can anyone please point me in a direction where I can find a procedure

[CentOS] mysql client ssl connection failure

The problem and solution is posted here for posterity. On a production CentOS 5.11 system, I recently had a cron job that started failing. One of the thing that the cron job does is connect to a MySQL server via TCP using SSL. Debugging things got me to the point where invoking the mysql client

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

Hi, as that example is for maria db, teh oracle mysql rpm dose not ship with something like /etc/systemd/system/mysqld.service.d Can I just create /etc/systemd/system/mysqld.service.d/limits.conf and than I'm ready to go? Thanks for your patience and regards . Götz Am 29.04.15 um 14:58

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

we can set ulimt to limit the number of open files On Thu, Apr 30, 2015 at 3:22 PM, Götz Reinicke - IT Koordinator < goetz.reini...@filmakademie.de> wrote: > +1 Thanks! That was a little bit confusing at first. > > Regards . Götz > > Am 30.04.15 um 04:21 schrieb carlh04...@gmail.com: > >

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

+1 Thanks! That was a little bit confusing at first. Regards . Götz Am 30.04.15 um 04:21 schrieb carlh04...@gmail.com: > Thank you for clarifying this, Johan. Very much appreciated! > > On Wed, 29 Apr 2015 22:28:00 +0200 > Johan Kooijman wrote: > >> Carl, >> >> By default my.cnf has to

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

Thank you for clarifying this, Johan. Very much appreciated! On Wed, 29 Apr 2015 22:28:00 +0200 Johan Kooijman wrote: > Carl, > > By default my.cnf has to obey the OS limits, so in this case the > order is: systemd > /etc/security/limits* > /etc/my*. > > On Wed, Apr 29, 2015 at 3:22 PM, Carl E.

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

Carl, By default my.cnf has to obey the OS limits, so in this case the order is: systemd > /etc/security/limits* > /etc/my*. On Wed, Apr 29, 2015 at 3:22 PM, Carl E. Hartung wrote: > Hi Johan, > > Does systemd also overrule /etc/my.conf? > > Thx! > > Carl > > On Wed, 29 Apr 2015 14:58:52 +0200

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

Hi Johan, Does systemd also overrule /etc/my.conf? Thx! Carl On Wed, 29 Apr 2015 14:58:52 +0200 Johan Kooijman wrote: > Gotz, > > This is due to systemd, it overrules your settings. Add a file to > systemd config fixes it: > > [root@mysql2 ~]# cat /etc/systemd/system/mariadb.service.d/limits

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

Gotz, This is due to systemd, it overrules your settings. Add a file to systemd config fixes it: [root@mysql2 ~]# cat /etc/systemd/system/mariadb.service.d/limits.conf [Service] LimitNOFILE=1 LimitMEMLOCK=1 On Wed, Apr 29, 2015 at 8:31 AM, Götz Reinicke - IT Koordinator < goetz.reini...

Re: [CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

On 29/04/2015 09:31 AM, Götz Reinicke - IT Koordinator wrote: Hi, may be somewon has a working solution and information on that: I installed the most recent mysql community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_lim

[CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

Hi, may be somewon has a working solution and information on that: I installed the most recent mysql community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, change/add that to /etc/security/limits.conf and modify the sy

Re: [CentOS] mysql can't connect from localhost -strange behavior

On 30/03/15 05:22, Tim Dunphy wrote: mysql> FLUSH PRIVILEGES; Yup! That was it. Thanks for the reminder! :) Tim >From the mySQL man pages: If you modify the grant tables indirectly using account-management statements such as GRANT, RE

Re: [CentOS] mysql can't connect from localhost -strange behavior

On Mon, Mar 30, 2015 at 3:16 AM, Fernando Cassia wrote: > You should keep in mind the security-related changes coming in MySQL 5..7, > if you ever choose to upgrade. Sorry, I erased this link by mistake while composing my reply. Here it goes. http://mysqlopt.blogspot.com/2015/02/mysql-575-m15-

Re: [CentOS] mysql can't connect from localhost -strange behavior

On Mon, Mar 30, 2015 at 12:27 AM, Tim Dunphy wrote: > 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. > Hi Tim, You shou

Re: [CentOS] mysql can't connect from localhost -strange behavior

[root@ops:~] #mysql --user=proftpd --password=testpattern -h localhost On Sun, Mar 29, 2015 at 10:27 PM, Tim Dunphy wrote: > 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

Re: [CentOS] mysql can't connect from localhost -strange behavior

> > mysql> FLUSH PRIVILEGES; Yup! That was it. Thanks for the reminder! :) Tim On Mon, Mar 30, 2015 at 12:15 AM, Steven Tardy wrote: > > > mysql> grant all privileges on ftp.* to 'proftpd'@'localhost' > identified by > > 'testpattern'; > > Query OK, 0 rows affected (0.35 sec) > > mysql> FLUSH

Re: [CentOS] mysql can't connect from localhost -strange behavior

> mysql> grant all privileges on ftp.* to 'proftpd'@'localhost' identified by > 'testpattern'; > Query OK, 0 rows affected (0.35 sec) mysql> FLUSH PRIVILEGES; ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

[CentOS] mysql can't connect from localhost -strange behavior

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

Re: [CentOS] mysql replication - problems

On Thu, March 12, 2015 11:49, Tim Dunphy wrote: > > Ok, yeah I can understand that. I'll correct it. Still need a way to > get SSL enabled however. Any suggestions there? The method we use is to create an application specific directory under /etc/pki and place its certificates and keys in there.

Re: [CentOS] mysql replication - problems

Hey Alberto, Perfect! Thanks for your response. Moving the certs and keys to an alternate location worked exactly right. Master: MariaDB [(none)]> show variables like '%ssl%'; +---+--+ | Variable_name | Value| +---+-

Re: [CentOS] mysql replication - problems

On Thu, Mar 12, 2015 at 10:49 AM Tim Dunphy wrote: > > > > 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? > > I totally misrea

Re: [CentOS] mysql replication - problems

On Thu, Mar 12, 2015 at 10:49 AM Tim Dunphy wrote: > > > > No: /etc/pki/CA should NOT be group writeable. Ditto for > > /etc/pki/tls/cernts and private > I agree - Sorry I did not mean to imply that the directory permissions on /etc/pki/CA should be modified. However it was mentioned it as a

Re: [CentOS] mysql replication - problems

On Thu, March 12, 2015 10:40 am, m.r...@5-cent.us wrote: > Tim Dunphy wrote: >>> >>> 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 ss

Re: [CentOS] mysql replication - problems

> > 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, wrote: > Tim Dunphy wrote: > >> > >>

Re: [CentOS] mysql replication - problems

Tim Dunphy wrote: >> >> 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/p

Re: [CentOS] mysql replication - problems

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

Re: [CentOS] mysql replication - problems

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

[CentOS] mysql replication - problems

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

Re: [CentOS] MySQL - replication - how to restore master?

It's quite simple really. Just make your master a slave of your slave. It's called Multi Master. see http://mysql-mmm.org/ On Wed, Aug 13, 2014 at 9:53 PM, John Horne wrote: > Hello, > > We have MySQL running as a master which is replicating to a single slave > server. We are, however, consid

Re: [CentOS] MySQL - replication - how to restore master?

> -Original Message- > From: John Horne [mailto:john.ho...@plymouth.ac.uk] > Sent: Wednesday, August 13, 2014 7:53 AM > To: CentOS list > Subject: [CentOS] MySQL - replication - how to restore master? > > Hello, > > However, I am having trouble finding out wh

[CentOS] MySQL - replication - how to restore master?

Hello, We have MySQL running as a master which is replicating to a single slave server. We are, however, considering what is required when a 'disaster' of some sort happens to either server. By disaster, this could be some event which requires the entire server to be rebuilt, and which would usual

Re: [CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

On 02/13/2014 09:21 PM, Ljubomir Ljubojevic wrote: > On 02/13/2014 09:18 PM, Ljubomir Ljubojevic wrote: >> On 02/13/2014 08:49 PM, Les Mikesell wrote: >>> On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic >>> wrote: I have a strange problem. I installed cacti, and set it up

Re: [CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

On 02/13/2014 09:18 PM, Ljubomir Ljubojevic wrote: > On 02/13/2014 08:49 PM, Les Mikesell wrote: >> On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic wrote: >>> >>> I have a strange problem. >>> >>> I installed cacti, and set it up. >>> >>> When I click on the Plugins Management, I noticed Erro

Re: [CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

On 02/13/2014 08:49 PM, Les Mikesell wrote: > On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic wrote: >> >> I have a strange problem. >> >> I installed cacti, and set it up. >> >> When I click on the Plugins Management, I noticed Error >> "FATAL: Database or Table does not exist" >> >> Further

Re: [CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

On 02/13/2014 08:17 PM, Clint Dilks wrote: > Hi, > > Have you verified that permissions on /tmp appear correct ? > > An example from one of my systems > > > # ls -lsahd /tmp > 4.0K drwxrwxrwt. 3 root root 4.0K Feb 14 07:01 /tm > > So permissions 1777 > Already checked. [root@chiron ~]# ls -lsahd

Re: [CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic wrote: > > I have a strange problem. > > I installed cacti, and set it up. > > When I click on the Plugins Management, I noticed Error > "FATAL: Database or Table does not exist" > > Further testing revealed that at the moment MySQL can not crea

Re: [CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

Hi, Have you verified that permissions on /tmp appear correct ? An example from one of my systems # ls -lsahd /tmp 4.0K drwxrwxrwt. 3 root root 4.0K Feb 14 07:01 /tm So permissions 1777 Perhaps test creating a file in /tmp as root and as a non root user and let us know the results that way we

[CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

Hi. I have a strange problem. I installed cacti, and set it up. When I click on the Plugins Management, I noticed Error "FATAL: Database or Table does not exist" Further testing revealed that at the moment MySQL can not create temporary files in /tmp. It is same for ANY database! SELinux is d

Re: [CentOS] MySQL stale socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul Heinlein said the following on 20/12/2013 16:50: > On Fri, 20 Dec 2013, Luigi Rosa wrote: > >> I can confirm that this is a bug added to the latest releases og MySQL. >> >> I tested it only in VM (both VMware and XEN). >> >> How to reproduce. >

Re: [CentOS] MySQL stale socket

On Fri, 20 Dec 2013, Luigi Rosa wrote: I can confirm that this is a bug added to the latest releases og MySQL. I tested it only in VM (both VMware and XEN). How to reproduce. * start a CentOS VM with MySQL * abruptly turn the VM off (not shutdown, of course) * restart VM * MySQL starts but th

Re: [CentOS] MySQL stale socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I can confirm that this is a bug added to the latest releases og MySQL. I tested it only in VM (both VMware and XEN). How to reproduce. * start a CentOS VM with MySQL * abruptly turn the VM off (not shutdown, of course) * restart VM * MySQL starts b

Re: [CentOS] MySQL stale socket

On Mon, 16 Dec 2013 10:51:54 +0100 Luigi Rosa wrote: > > I have a server with a faulty power supply that resets the server > every 4/5 hours. > > While I wait for the supplier to change the PS, I am facing an issue > with MySQL. > > When the system comes back on, mysqld script starts the daemo

[CentOS] MySQL stale socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a server with a faulty power supply that resets the server every 4/5 hours. While I wait for the supplier to change the PS, I am facing an issue with MySQL. When the system comes back on, mysqld script starts the daemon, but the connections vi

[CentOS] MySQL stale socket

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a server with a faulty power supply that resets the server every 4/5 hours. While I wait for the supplier to change the PS, I am facing an issue with MySQL. When the system comes back on, mysqld script starts the daemon, but the connections vi

Re: [CentOS] Mysql databases from old system?

On 11/15/2013 10:19 AM, Les Mikesell wrote: > On Fri, Nov 15, 2013 at 12:16 PM, Reindl Harald > wrote: >> > >> >in other words you do not know anything Reindl is banned from this list for serial rudeness, but replies privately to list postings with his 'wisdom'. please don't copy his private

Re: [CentOS] Mysql databases from old system?

On Fri, Nov 15, 2013 at 12:32 PM, Reindl Harald wrote: > >> Yes, if you do things that work in general, you don't have to know all >> of the internals of every specific version of every specific program >> that you might ever touch. > > than better be quiet instead contradict and correct people wi

Re: [CentOS] Mysql databases from old system?

On Fri, Nov 15, 2013 at 12:16 PM, Reindl Harald wrote: > > in other words you do not know anything about the mysql-internals > as you statet more than once, have no expierience and come up with > generic theory to defend your statements Yes, if you do things that work in general, you don't have t

Re: [CentOS] Mysql databases from old system?

On Fri, Nov 15, 2013 at 12:00 PM, Reindl Harald wrote: > > and why did you strip the part where i googled for you the endianess > of MacOSX on PPC because i clearly statet mysql-data dirs used here > in production went from MySQL 3.x on Windows i686 over MySQL 4.0-4.5 > on Apple OSX *Power PC* to

Re: [CentOS] Mysql databases from old system?

On Fri, Nov 15, 2013 at 10:58 AM, Reindl Harald wrote: > >> I don't know specifically about Mysql but pretty much anything that stores >> binary >> representations to disk needs to be converted. > > with this logic you would need to convert MS office files > containing embedded images too No

Re: [CentOS] Mysql databases from old system?

On Fri, Nov 15, 2013 at 10:01 AM, Reindl Harald wrote: > > abd what has the CPU type to do with the mysql datadir? Really??? You've never used processors with different bit/byte order than Intel's? I don't know specifically about Mysql but pretty much anything that stores binary representations

Re: [CentOS] Mysql databases from old system?

Am 15.11.2013 um 16:55 schrieb Les Mikesell : > On Fri, Nov 15, 2013 at 6:18 AM, Timothy Murphy wrote: >> Last week I had a hard disk failure on my CentOS server. >> I managed to re-install CentOS on a new disk. >> I have the old mysql databases from /var/lib/mysql . >> Can I just move them to my

Re: [CentOS] Mysql databases from old system?

On Fri, Nov 15, 2013 at 6:18 AM, Timothy Murphy wrote: > Last week I had a hard disk failure on my CentOS server. > I managed to re-install CentOS on a new disk. > I have the old mysql databases from /var/lib/mysql . > Can I just move them to my new disk? > > Any help or suggestions gratefully rec

Re: [CentOS] Mysql databases from old system?

Marios Zindilis wrote: > On Fri, Nov 15, 2013 at 2:18 PM, Timothy Murphy > wrote: > >> Last week I had a hard disk failure on my CentOS server. >> I managed to re-install CentOS on a new disk. >> I have the old mysql databases from /var/lib/mysql . >> Can I just move them to my new disk? >> >> Any

Re: [CentOS] Mysql databases from old system?

MySQL is usually confined in /var/lib/mysql, so if you move the /etc/my.cnf and the /var/lib/mysql from the old server to the new one, you should be able to start the server normally, otherwise you should get some useful errors. A typical error in such case is MySQL files ownership/permissions.

[CentOS] Mysql databases from old system?

Last week I had a hard disk failure on my CentOS server. I managed to re-install CentOS on a new disk. I have the old mysql databases from /var/lib/mysql . Can I just move them to my new disk? Any help or suggestions gratefully received. -- Timothy Murphy e-mail: gayleard /at/ eircom.net Schoo

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

On 10/30/2013 05:22 AM, Leon Fauster wrote: > Am 29.10.2013 um 22:56 schrieb Reindl Harald : >>> php-mysql is linked against mysql-5.0-libs and talking to >>> a mysql-5.5 server. Should this cause an unpredictable behavior? >> no - how do you come to this idea? > In the last decade i saw very stra

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

Am 30.10.2013 um 17:31 schrieb Matthew B. Brookover : > > On Wed, 2013-10-30 at 11:22 +0100, Leon Fauster wrote: >> Am 29.10.2013 um 22:56 schrieb Reindl Harald : >>> >>> no - how do you come to this idea? >> >> In the last decade i saw very strange results while updating >> or doing similar th

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

On Wed, 2013-10-30 at 11:22 +0100, Leon Fauster wrote: > Am 29.10.2013 um 22:56 schrieb Reindl Harald : > >> php-mysql is linked against mysql-5.0-libs and talking to > >> a mysql-5.5 server. Should this cause an unpredictable behavior? > > > > no - how do you come to this idea? > > In the last

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

Am 29.10.2013 um 22:56 schrieb Reindl Harald : >> php-mysql is linked against mysql-5.0-libs and talking to >> a mysql-5.5 server. Should this cause an unpredictable behavior? > > no - how do you come to this idea? In the last decade i saw very strange results while updating or doing similar th

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

ges and will leave > > mysql-5.0-5.el5_9 in place for now. FYI, I searched through the rest of > > the installed packages, the only one that has the client library is > > mysql-5.0.95-5.el5_9. > > > php-mysql is linked against mysql-5.0-libs and talking to > a mysql-5.5 server. Should this cause a

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

Am 28.10.2013 um 22:30 schrieb Matthew B. Brookover : > On Mon, 2013-10-28 at 22:18 +0200, Eero Volotinen wrote: >> 2013/10/28 Matthew B. Brookover >> >>> I upgraded a web server from CentOS 5.9 to 5.10. The instructions also >>> indicate that MySQL 5.0 is no longer supported so I followed the >

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

On Mon, 2013-10-28 at 22:18 +0200, Eero Volotinen wrote: > 2013/10/28 Matthew B. Brookover > > > I upgraded a web server from CentOS 5.9 to 5.10. The instructions also > > indicate that MySQL 5.0 is no longer supported so I followed the > > instructions to upgrade to 5.5. Everything seems to be

Re: [CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

2013/10/28 Matthew B. Brookover > I upgraded a web server from CentOS 5.9 to 5.10. The instructions also > indicate that MySQL 5.0 is no longer supported so I followed the > instructions to upgrade to 5.5. Everything seems to be working so I > tried to remove MySQL 5.0 and MySQL 5.1. It seems

[CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

I upgraded a web server from CentOS 5.9 to 5.10. The instructions also indicate that MySQL 5.0 is no longer supported so I followed the instructions to upgrade to 5.5. Everything seems to be working so I tried to remove MySQL 5.0 and MySQL 5.1. It seems there are still dependencies on MySQL 5.0:

Re: [CentOS] MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-networking On Sep 13, 2013, at 6:44 AM, Alexander Farber wrote: > 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 ha

Re: [CentOS] MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

Thank you, that was it. I didn't realize "mysqld-nt" means "Windows only" ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

Docs says it's Windows specific: http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_enable-named-pipe On Fri, Sep 13, 2013 at 1:44 PM, Alexander Farber < alexander.far...@gmail.com> wrote: > Hello, > > I've only had experience with PostgreSQL sofar, > but have now to insta

[CentOS] MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

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

Re: [CentOS] Mysql cluster vs. mysql-libs

On 06/06/2012 12:45 AM, Dennis Jacobfeuerborn wrote: > Hi, > it seems even a minimal install of Centos 6.2 now requires mysql-libs as a > dependency for postfix and cronie. When I try to install the mysql cluster > rpms from mysql.com I get a collision between the files. > Since this is the first t

[CentOS] Mysql cluster vs. mysql-libs

Hi, it seems even a minimal install of Centos 6.2 now requires mysql-libs as a dependency for postfix and cronie. When I try to install the mysql cluster rpms from mysql.com I get a collision between the files. Since this is the first time I get into contact with mysql cluster I wonder if somebody

Re: [CentOS] mysql

On 06/05/2012 11:13 AM, Leonard den Ottolander wrote: > See for yourself: > > # grep mysql /etc/shadow > mysql:!!:15404:: Ah - good, from man 5 shadow... encrypted password Refer to crypt(3) for details on how this string is interpreted. If the password field c

Re: [CentOS] mysql

Hello Steve, On Tue, 2012-06-05 at 10:57 -0400, Steve Clark wrote: > I see that installing mysql in Centos 6.x creates a mysql user > with a login shell of /bin/bash. Is a default password also installed? > > I certainly hope not, but it makes me nervous. See for yourself: # grep mysql /etc/sh

[CentOS] mysql

Hello List, I see that installing mysql in Centos 6.x creates a mysql user with a login shell of /bin/bash. Is a default password also installed? I certainly hope not, but it makes me nervous. -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: stev

Re: [CentOS] mysql secure installation and multi mysqld

On 5/17/2012 5:30 AM, Leon Jacobs wrote: > On Thu, May 17, 2012 at 5:44 AM, Bob Hoffman wrote: >> is it possible to make each one of those instances a replicate/slave of >> a different master >> (thus a backup mysql server in a way?) > I just recently finished playing with this. I ended up brining

Re: [CentOS] mysql secure installation and multi mysqld

On Thu, May 17, 2012 at 5:44 AM, Bob Hoffman wrote: > is it possible to make each one of those instances a replicate/slave of > a different master > (thus a backup mysql server in a way?) I just recently finished playing with this. I ended up brining up a dedicated VM for this "backup mysql serve

[CentOS] mysql secure installation and multi mysqld

If you adjust the my.cnf file to make separate instances of mysql. How would you go through the mysql secure installation? Is is possible or must it all be done manually for each one? is it possible to make each one of those instances a replicate/slave of a different master (thus a backup m

Re: [CentOS] mysql-bin files - filling up the space.

On Thu, May 3, 2012 at 11:23 AM, Prabhpal S. Mavi wrote: > > > Dear All Greetings, > > i am seeking help from guys with mysql knowledge. i can see lot of these > files in mysql directory. And they are eventually filling up the space on > the server. what these files are? some exists with very old

[CentOS] mysql-bin files - filling up the space.

Dear All Greetings, i am seeking help from guys with mysql knowledge. i can see lot of these files in mysql directory. And they are eventually filling up the space on the server. what these files are? some exists with very old time stamps. such as February 2012. can these be deleted? This Number

Re: [CentOS] MySQL query profiling

On 03/22/2012 11:18 AM, Andy Taylor wrote: > Hi, > > I recently upgraded to the latest MySQL 5.0.95 package as part of the > CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for > performance testing. However, if I try to use any of the profiling > functionality I get this erro

Re: [CentOS] MySQL query profiling

Hello Johnny, Andy, On Thu, 2012-03-22 at 12:01 -0500, Johnny Hughes wrote: > On 03/22/2012 11:46 AM, Johnny Hughes wrote: > OK ... I have verified that it is now turned off and that it was on in > 5.0.77 > > from 5.0.95 build log: > <..> > checking whether query profiling should be incl

Re: [CentOS] MySQL query profiling

On 03/22/2012 05:01 PM, Johnny Hughes wrote: > > So, profiling was indeed in 5.0.77 and it is indeed not in 5.0.95 The default in configure for 5.0.77 was to have it turned on, whereas in 5.0.95 the default has been to turn it off : +{ $as_echo "$as_me:$LINENO: checking whether query profiling

Re: [CentOS] MySQL query profiling

On 03/22/2012 11:46 AM, Johnny Hughes wrote: > On 03/22/2012 11:32 AM, Johnny Hughes wrote: >> On 03/22/2012 11:18 AM, Andy Taylor wrote: >>> Hi, >>> >>> I recently upgraded to the latest MySQL 5.0.95 package as part of the >>> CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for

Re: [CentOS] MySQL query profiling

On 03/22/2012 11:32 AM, Johnny Hughes wrote: > On 03/22/2012 11:18 AM, Andy Taylor wrote: >> Hi, >> >> I recently upgraded to the latest MySQL 5.0.95 package as part of the >> CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for >> performance testing. However, if I try to use a

Re: [CentOS] MySQL query profiling

On 03/22/2012 11:18 AM, Andy Taylor wrote: > Hi, > > I recently upgraded to the latest MySQL 5.0.95 package as part of the > CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for > performance testing. However, if I try to use any of the profiling > functionality I get this erro

[CentOS] MySQL query profiling

Hi, I recently upgraded to the latest MySQL 5.0.95 package as part of the CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for performance testing. However, if I try to use any of the profiling functionality I get this error: ERROR 1289 (HY000): The 'SHOW PROFILE' feature is

Re: [CentOS] MySQL/file system question

On Mon, 2012-02-13 at 18:59 -0500, Boris Epstein wrote: > Here we go: > [root@gala ~]# ls -l /proc/18702/fd > total 0 ... > lrwx-- 1 root root 64 Feb 13 18:58 7 -> /home/mysql/tmp/ibE0DGCO > (deleted) > lrwx-- 1 root root 64 Feb 13 18:58 8 -> > /home/mysql/mysql_data/ib_logfile0 > lrwx-

Re: [CentOS] MySQL/file system question

On Mon, Feb 13, 2012 at 6:53 PM, Ljubomir Ljubojevic wrote: > On 02/13/2012 11:31 PM, Boris Epstein wrote: > >> > > In fact, I did look in /proc/{pid#}/fd and found the file names, thanks! > > Coud quite figure out the size of those invisible files - but no matter, > > hopefully I've got enough ro

Re: [CentOS] MySQL/file system question

On 02/13/2012 11:31 PM, Boris Epstein wrote: >> > In fact, I did look in /proc/{pid#}/fd and found the file names, thanks! > Coud quite figure out the size of those invisible files - but no matter, > hopefully I've got enough room. > ls -l /proc/{pid#}/fd -- Ljubomir Ljubojevic (Love is in the

Re: [CentOS] MySQL/file system question

On Mon, Feb 13, 2012 at 4:06 PM, Boris Epstein wrote: > > > > I haven't thought of it this way. In fact it matches with this description: > > http://dev.mysql.com/doc/refman/5.1/en/temporary-files.html > > I can kind of see the advantages; the disadvantages, of course, are that a > major transact

Re: [CentOS] MySQL/file system question

> > > > If the process is stopped the transaction cannot be resumed for a myriad > reasons; loss of the temporary file is a trivial concern. > > -- > System & Network Administrator [ LPI & NCLA ] > > OpenGroupware Developer > Adam

Re: [CentOS] MySQL/file system question

On Mon, 2012-02-13 at 17:06 -0500, Boris Epstein wrote: > On Mon, Feb 13, 2012 at 4:58 PM, Adam Tauno Williams > wrote: > > On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote: > > > Hello listmates, > > > I got a rather strange situation that I can't quite make sense of. OK, > > I've > > > got

Re: [CentOS] MySQL/file system question

> > > > Easy. It is using temporary files the *correct* way. > > 1. Open file > 2. Unlink file > 3. Use file > 4. Close file > > This means (a) even if the process abends the resources allocated to the > file are released and (b) an external process can't see [or modify] the > temporary file. > >

Re: [CentOS] MySQL/file system question

On Mon, Feb 13, 2012 at 4:58 PM, Adam Tauno Williams wrote: > On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote: > > Hello listmates, > > I got a rather strange situation that I can't quite make sense of. OK, > I've > > got a very large data file to sort (hundreds of millions of lines) and I

Re: [CentOS] MySQL/file system question

On Mon, 2012-02-13 at 16:45 -0500, Boris Epstein wrote: > Hello listmates, > I got a rather strange situation that I can't quite make sense of. OK, I've > got a very large data file to sort (hundreds of millions of lines) and I > decided to use MySQL for the purpose. I inserted the stuff into a tab

[CentOS] MySQL/file system question

Hello listmates, I got a rather strange situation that I can't quite make sense of. OK, I've got a very large data file to sort (hundreds of millions of lines) and I decided to use MySQL for the purpose. I inserted the stuff into a table easily enough. Then I decided to sort it and got stuck as it

  1   2   3   4   >