MySQL Community Server 5.7.6 has been released (part 1/3)
Dear MySQL users, MySQL Server 5.7.6-m16 (Milestone Release) is a new version of the world's most popular open source database. This is the sixth public milestone release of MySQL 5.7. http://dev.mysql.com/doc/mysql-development-cycle/en/development-milestone-releases.html [Due to size limitations on email/forum and the sheer number of changes since 5.7.5, this announcement had to be split into three parts. This is part 1.] As with any other pre-production release, caution should be taken when installing on production level systems or systems with critical data. Note that 5.7.6-m16 includes all features in MySQL 5.6. For information on installing MySQL 5.7.6-m16 on new servers, please see the MySQL installation documentation at http://dev.mysql.com/doc/refman/5.7/en/installing.html MySQL Server 5.7.6-m16 is available in source and binary form for a number of platforms from the Development Releases selection of our download pages at http://dev.mysql.com/downloads/mysql/ MySQL Server 5.7.6-m16 is also available from our repository for Linux platforms, go here for details: http://dev.mysql.com/downloads/repo/ Windows packages are now available via the new Installer for Windows Installer or .ZIP (no-install) packages for more advanced needs. It should be noted that the previous MSI packaging is no longer available and the point and click configuration wizards and all MySQL products are now available in the unified Installer for Windows: http://dev.mysql.com/downloads/installer/ 5.7.6-m16 also comes with a web installer as an alternative to the full installer. The web installer doesn't come bundled with any actual products and instead relies on download-on-demand to fetch only the products you choose to install. This makes the initial download much smaller but increases install time as the individual products will need to be downloaded. We welcome and appreciate your feedback, bug reports, bug fixes, patches, etc.: http://bugs.mysql.com/report.php The following section lists the changes in MySQL 5.7.6-m16 since the previous milestone. http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html Enjoy! - Bjorn Munch MySQL Release Engineering == Changes in MySQL 5.7.6 (2015-03-09, Milestone 16) Note This is a milestone release, for use at your own risk. Significant development changes take place in milestone releases and you may encounter compatibility issues, such as data format changes that require attention in addition to the usual procedure of running mysql_upgrade. For example, you may find it necessary to dump your data with mysqldump before the upgrade and reload it afterward. Account Management Notes * Incompatible Change: The CREATE USER and ALTER USER statements have gained user-management capabilities. Together, they now can be used to fully establish or modify authentication, SSL, and resource-limit properties, as well as manage password expiration and account locking and unlocking. For example, ALTER USER can assign passwords, and it can modify the authentication plugin for users with no need for direct manipulation of the mysql.user table. For details, see CREATE USER Syntax (http://dev.mysql.com/doc/refman/5.7/en/create-user.html) , and ALTER USER Syntax (http://dev.mysql.com/doc/refman/5.7/en/alter-user.html). Account locking control is a new feature that permits administrators to completely disable an account from being used to connect to the server. Account locking state is recorded in the account_locked column of the mysql.user table. See User Account Locking (http://dev.mysql.com/doc/refman/5.7/en/account-locking.html). A new statement, SHOW CREATE USER, shows the CREATE USER statement that creates the named user. The accompanying Com_show_create_user status variable indicates how many times the statement has been executed. A new system variable, log_backward_compatible_user_definitions, if enabled, causes the server to log CREATE USER, ALTER USER, and GRANT statements in backward-compatible (pre-5.7.6) fashion. Enabling this variable promotes compatibility for cross-version replication. The authentication_string column in the mysql.user table now stores credential information for all accounts. The Password column, previously used to store password hash values for accounts authenticated with the mysql_native_password and mysql_old_password plugins, is removed. If you upgrade to this release of MySQL from an earlier version, you must run mysql_upgrade (and restart the server) to incorporate the changes to the mysql database. mysql_upgrade moves Password column values to the
Re: Mysql Syslog client.
Hi Stephan, I've already tried syslog but it works fine in my environment. $ /usr/mysql/5.7.6/bin/mysql --syslog -h 192.168.198.214 -u yoku mysql show databases; Mar 13 11:27:57 dev-personal-04 MysqlClient: SYSTEM_USER:'ttanaka', MYSQL_USER:'yoku', CONNECTION_ID:9, DB_SERVER:'192.168.198.214', DB:'--', QUERY:'show databases;' $ /usr/mysql/5.7.6/bin/mysql -h sys-db02 -P 3307 -u yoku --syslog mysql status Mar 13 11:30:01 dev-personal-04 MysqlClient: SYSTEM_USER:'ttanaka', MYSQL_USER:'yoku', CONNECTION_ID:17818, DB_SERVER:'sys-db02', DB:'--', QUERY:'status' mysql show databases; Mar 13 11:30:03 dev-personal-04 MysqlClient: SYSTEM_USER:'ttanaka', MYSQL_USER:'yoku', CONNECTION_ID:17818, DB_SERVER:'sys-db02', DB:'--', QUERY:'show databases;' $ /usr/mysql/5.7.6/bin/mysql -S /usr/mysql/5.7.6/data/mysql.sock -u root --syslog mysql select current_user(); Mar 13 11:30:24 dev-personal-04 MysqlClient: SYSTEM_USER:'ttanaka', MYSQL_USER:'root', CONNECTION_ID:10, DB_SERVER:'--', DB:'--', QUERY:'select current_user();' mysql command line client's --syslog sends log to local(client machine)'s syslogd. yoku0825, 2015-03-13 3:59 GMT+09:00 Stephan Gomes Higuti higuti@gmail.com: Hello guys. Im using MySQL 5.7.6 for testing some new features, including syslog support for client. Its working great and Im getting the following lines when using localhost: Mar 12 12:36:34 server1 MysqlClient[17854]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql', QUERY:'use mysql' Mar 12 12:36:36 server1 MysqlClient[17854]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql', QUERY:'show tables;' Mar 12 12:36:55 server1 MysqlClient[17856]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:6, DB_SERVER:'--', DB:'mysql', QUERY:'use mysql ' However, if I try to access MySQL in any other server, for example mysql -uuser -ppasswd -hserver2, it doesn't log in syslog. My client section config is: [client] #password = [your_password] port= 3306 socket = /var/lib/mysql/mysql.sock syslog Have any of you tried this? Thank you in advance. Stephan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Mysql Syslog client.
Hello guys. Im using MySQL 5.7.6 for testing some new features, including syslog support for client. Its working great and Im getting the following lines when using localhost: Mar 12 12:36:34 server1 MysqlClient[17854]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql', QUERY:'use mysql' Mar 12 12:36:36 server1 MysqlClient[17854]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql', QUERY:'show tables;' Mar 12 12:36:55 server1 MysqlClient[17856]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:6, DB_SERVER:'--', DB:'mysql', QUERY:'use mysql ' However, if I try to access MySQL in any other server, for example mysql -uuser -ppasswd -hserver2, it doesn't log in syslog. My client section config is: [client] #password = [your_password] port= 3306 socket = /var/lib/mysql/mysql.sock syslog Have any of you tried this? Thank you in advance. Stephan
Re: ssh basics
- Original Message - From: Thufir hawat.thu...@gmail.com Subject: Re: ssh basics On Mon, 09 Mar 2015 16:00:08 +0100, Johan De Meersman wrote: All in all, you've done the opposite of what I asked - you've told me what you know and tried, but not what you were trying to figure out with your original question :-p Sounds like you mostly have a lot of fun, then :-p -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
