Re: Mysql devel
Am 23.02.2016 um 13:12 schrieb Larry Martell: On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell wrote: On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: Am 23.02.2016 um 04:47 schrieb Larry Martell: I am trying to install the mysql devel libs (so I can build MySQLdb). This is on RHEL 6. It's failing as shown below. Can anyone help with this? you are mixing remi and other repos I did this: # yum shell --enablerepo=remi remove php-mysql install php-mysqlnd run Followed by this: yum install mysql-devel /usr/local/bin/pip2.7 install MySQL-python Now the MySQL server is down and will not come up. It fails with this: Fatal error: mysql.user table is damaged. Please run mysql_upgrade It was running 5.1 before and now it's running 5.7. But how can I run mysql_upgrade if I can't start the server? Actually it was running 5.5 before: Server version: 5.5.44 MySQL Community Server (GPL) by Remi all your problems are coming from careless mix repos and allow updates without considering the result and read how to deal with 3rd party repos from the very beginning downgrade and re-consider how you are doing upgrades 5.5 to 5.7 and skip 5.6 entirely is a bad idea make sure that you don't mix mysql-packages from different repos and RTFM https://wiki.centos.org/de/AdditionalResources/Repositories/ Les RPM de Remi repository - (See http://rpms.famillecollet.com/) Remi Collet maintains latest version of MySQL and PHP (backports of fedora RPM). Suggest caution if using this repo due to replacement of core packages Third Party Repositories WARNING: These repositories are not provided nor supported by CentOS. The CentOS project has no control over these sites. Many have their own mailing lists, IRC channels, issue trackers, etc. for support issues with their packages. NOTE: If you are considering using a 3rd Party Repository, then you should seriously consider how to prevent unintended 'updates' from these side archives from over-writing some core part of CentOS. One approach is to only enable these archives from time to time, and generally leave them disabled. See: man yum Another approach is to use the exclude= and includepkgs= options on a per sub-archive basis, in the matching .conf file found in /etc/yum.repos.d/ See: man yum.conf The yum Priorities plug-in can prevent a 3rd party repository from replacing base packages, or prevent base/updates from replacing a 3rd party package. signature.asc Description: OpenPGP digital signature
Re: Mysql devel
On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell wrote: > On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: >> >> >> Am 23.02.2016 um 04:47 schrieb Larry Martell: >>> >>> I am trying to install the mysql devel libs (so I can build MySQLdb). >>> This is on RHEL 6. It's failing as shown below. Can anyone help with >>> this? >> >> >> you are mixing remi and other repos > > I did this: > > # yum shell --enablerepo=remi >> remove php-mysql >> install php-mysqlnd >> run > > Followed by this: > > yum install mysql-devel > /usr/local/bin/pip2.7 install MySQL-python > > Now the MySQL server is down and will not come up. It fails with this: > > Fatal error: mysql.user table is damaged. Please run mysql_upgrade > > It was running 5.1 before and now it's running 5.7. > > But how can I run mysql_upgrade if I can't start the server? Actually it was running 5.5 before: Server version: 5.5.44 MySQL Community Server (GPL) by Remi > >> >>> Package mysql-community-devel.x86_64 0:5.7.11-1.el6 will be installed >>> for package: mysql-server-5.5.44-1.el6.remi.x86_64 >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Mysql devel
On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: > > > Am 23.02.2016 um 04:47 schrieb Larry Martell: >> >> I am trying to install the mysql devel libs (so I can build MySQLdb). >> This is on RHEL 6. It's failing as shown below. Can anyone help with >> this? > > > you are mixing remi and other repos I did this: # yum shell --enablerepo=remi > remove php-mysql > install php-mysqlnd > run Followed by this: yum install mysql-devel /usr/local/bin/pip2.7 install MySQL-python Now the MySQL server is down and will not come up. It fails with this: Fatal error: mysql.user table is damaged. Please run mysql_upgrade It was running 5.1 before and now it's running 5.7. But how can I run mysql_upgrade if I can't start the server? > >> Package mysql-community-devel.x86_64 0:5.7.11-1.el6 will be installed >> for package: mysql-server-5.5.44-1.el6.remi.x86_64 > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Mysql devel
Am 23.02.2016 um 04:47 schrieb Larry Martell: I am trying to install the mysql devel libs (so I can build MySQLdb). This is on RHEL 6. It's failing as shown below. Can anyone help with this? you are mixing remi and other repos Package mysql-community-devel.x86_64 0:5.7.11-1.el6 will be installed for package: mysql-server-5.5.44-1.el6.remi.x86_64 signature.asc Description: OpenPGP digital signature
ANN: DAC for MySQL 3.0.3 is out!
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll. What’s new in v3.0.3: This release includes Prepare feature based on the MySQL binary protocol, packages for work with FastReport, improvements and bug fixes. Full changelog: [!] Prepare and UnPrepare methods with MySQL binary protocol added to the TMySQLTable, TMySQLQuery and TMySQLStoredProc [!] Packages for integration into FastReport components added [!] More informative message introduced for TMySSHDatabase connection errors [!] TMySSHDatabase.AddSSHKeyToSystemCache property added [!] TMySSHDatabase.ShowPLinkConsole property added [+] Options.AutoPrepare property added to the TMySQLTable, TMySQLQuery and TMySQLStoredProc [*] A little bit of optimization for opening table with specified IndexName property added [-]"Error occurs when opening table with an alias and ENUM fields" bug fixed [-] "TMySQLDataSet returns data in incorrect characterSet if use FetchOnDemand property" bug fixed [-] "Filtering in Mobile target platforms not working" bug fixed [-] "TMySQLTable.GetTableEngine getting incorrect result if two tables of the same name exist in separate schemas" bug fixed [-] "Incorrect error message if open TMySQLDataSet with the FetchOnDemand property" bug fixed [-] Memory leaks when using FetchOnDemand with RequestLive eliminated [-] "Error occurs when calling post method in TMySQLDataSet with enabled FetchOnDemand and RequestLive properties" bug fixed [-] "Record with only null value NOT NULL field with default value not inserting" bug fixed [-] "Raise exception when post null value to the NOT NULL field with default value" bug fixed You're welcome to download the DAC for MySQL v3.0.3 right now at: http://microolap.com/products/connectivity/mysqldac/download/ , or login to your private area on our site at http://microolap.com/my/downloads/ Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/ -- Aleksandr Andreev Developer MicroOLAP Technologies LTD aleksandr.andr...@gf.microolap.com http://microolap.com