Recently in Database Category
MySQL 5.0 delivers dozens of new enterprise features, including:
* Stored Procedures and SQL Functions -- to embed business logic in the database and improve performance;
* Triggers -- to enforce complex business rules at the database level;
* Views -- to ensure protection of sensitive information;
* Cursors -- to allow easier database development and reference of large datasets;
* Information Schema -- to provide easy access to metadata;
* XA Distributed Transactions -- supports complex transactions across multiple databases in heterogeneous environments;
* SQL Mode -- provides server-enforced data integrity for new and existing data;
* New Federated and Archive Storage Engines -- MySQL's unique pluggable storage engine architecture allows greater flexibility, functionality and performance by making it easy to swap database engines in and out, based on users' application requirements;
* New Migration Toolkit -- A new graphical toolkit that completely migrates all data and objects from Oracle, Microsoft SQL Server, Microsoft Access and other database platforms to MySQL;
* Instance Manager -- new management assistant that allows remote starting/stopping of any MySQL Server, as well as remote editing of configuration files, reading of error and query logs, and more;
* Updated Connectors and Visual Tools -- new high-performance versions of MySQL's ODBC, Java and .NET database drivers are now available, along with updated versions of the MySQL Query Browser and MySQL Administrator.
The Problem
PHPMyAdmin has been setup to use "cookie" authentication, but when you try to log into phpmyadmin, it returns:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client"
The Fix
This is because, the mysqlclient installed on the box does not use the same authentication protocol that the mysqlserver is using. You can either upgrade the client, or reset the root password using this
SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');
When using srvbuild in sybase to create the master database device and sybsystemprocs device I got the following error message: The given master device size is too
large.
The error was so ,since, there was so much free space on the file system that it overflowed the datatype ASE used to store that value.
I created a dumb file, a very large file using dd:
dd if=/dev/zero of=/sybase-system/bigfatdumbfile.dat count=10000000000000
This solved the issue.
