Mysql Error Number 1289
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about
Mysql View Stored Procedure Code
Stack Overflow the company Business Learn more about hiring developers or posting ads with procedure in mysql us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error Code: 1289. The 'SHOW PROCEDURE|FUNCTION CODE' feature is disabled; to have it working up vote 1 down vote favorite i want to show my procedure code from mysql workbench program. i right click on any procedure and click the "alter procedure" option but didn't happen anything. and i'm try another way to show my code and alter the procedure's codes. with mysql code i want to show to the codes, this code statement follow: SHOW PROCEDURE CODE pusers but i getting this error: Error Code: 1289. The 'SHOW PROCEDURE|FUNCTION CODE' feature is disabled; to have it working My OS is MAC Lion OSX and MySQL Workbench program version are "version 5.2.47 revision 10398" and "version 5.2.45 revision 10251". There are old and new versions of this program. have u got any idea? mysql stored-procedures mysql-workbench alter share|improve this question asked Jul 2 '13 at 6:38 Mesuti 13615 with what user you created the procedure? and with what user you tried to exec SHOW PROCEDURE? my guess is that they are 2 different users –Stephan Jul 2 '13 at 7:19 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote It's by design. SHOW PROCEDURE CODE Syntax This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. As the error message explicitly says if you want to be able to use this feature you need to build your MySql with --with-debug option. share|improve this answer answered Jul 3 '13 at 6:05 peterm 57.5k56277 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Fac
Bradford Email Updates: Status: Can't repeat Impact on me: None Category:MySQL Server: Errors Severity:S3 (Non-critical) Version:5.1.16/6.0 OS:Any Assigned to: Tags: CREATE TABLE, eror message, SQL_MODE View Add Comment Files Developer Edit Submission View Progress Log Contributions [26 Jun 2007 20:11] Ronald Bradford Description: When attempting to create a table with sql_mode NO_ENGINE_SUBSTITUTION for a DISABLED engine, you get an error message with 'UNKNOWN'. In 5.0, appropriate message states 'InnodB' when this was used. In 5.1.16 and 6.0.0 it shows UNKNOWN In 5.1.19 you http://stackoverflow.com/questions/17418968/error-code-1289-the-show-procedurefunction-code-feature-is-disabled-to-hav get a completely different error message. How to repeat: bin/mysqld_safe --skip-innodb & bin/mysql -uroot test mysql> select version(); +-----------+ | version() | +-----------+ | 5.0.37 | +-----------+ 1 row in set (0.01 sec) mysql> set session sql_mode=NO_ENGINE_SUBSTITUTION; Query OK, 0 rows affected (0.00 sec) mysql> create table T2 (id INT UNSIGNED NOT NULL) ENGINE=InnoDB; ERROR 1289 (HY000): The 'InnoDB' https://bugs.mysql.com/bug.php?id=29373 feature is disabled; you need MySQL built with 'InnoDB' to have it working mysql> select version(); +-------------+ | version() | +-------------+ | 6.0.0-alpha | +-------------+ 1 row in set (0.00 sec) mysql> set session sql_mode=NO_ENGINE_SUBSTITUTION; Query OK, 0 rows affected (0.00 sec) mysql> create table T2 (id INT UNSIGNED NOT NULL) ENGINE=InnoDB; ERROR 1289 (HY000): The 'UNKNOWN' feature is disabled; you need MySQL built with 'UNKNOWN' to have it working mysql> select version(); +-------------+ | version() | +-------------+ | 5.1.19-beta | +-------------+ 1 row in set (0.00 sec) mysql> set session sql_mode=NO_ENGINE_SUBSTITUTION; Query OK, 0 rows affected (0.00 sec) mysql> create table T2 (id INT UNSIGNED NOT NULL) ENGINE=InnoDB; ERROR 1286 (42000): Unknown table engine 'InnoDB' [26 Jun 2007 20:22] Sveta Smirnova Thank you for the report. I can not repeat described behaviour with current development sources, although bug is repeatable with 6.0.0-alpha Please wait next build. Legal Policies Your Privacy Rights Terms of Use Contact Us Portions of this website are copyright © 2001, 2002 The PHP Group Page generated in 0.031 sec. using MySQL 5
help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. need help on MySQL https://bytes.com/topic/mysql/answers/573932-need-help-mysql-error-1289-openssl-missing error:1289(--openssl missing) P: 18 sarma Hi friends, I am using MySQL 5.0.24a on Linux. When I try to use des_encrypt() function, I am getting the warning like des_encrypt() is disabled and You http://www.w3resource.com/mysql/mysql-show.php need MySQL built with '--with-openssl' to have it working. To be specific, Output is Error (Code 1289): The 'des_encrypt' feature is disabled; you need MySQL built with '--with-openssl' to have it working. can mysql error u please help me out, how to resolve this problem. Thanks in advance regards sarma Dec 6 '06 #1 Post Reply Share this Question 2 Replies Expert 100+ P: 1,754 sashi Hi friends, I am using MySQL 5.0.24a on Linux. When I try to use des_encrypt() function, I am getting the warning like des_encrypt() is disabled and You need MySQL built with '--with-openssl' to have mysql error number it working. To be specific, Output is Error (Code 1289): The 'des_encrypt' feature is disabled; you need MySQL built with '--with-openssl' to have it working. can u please help me out, how to resolve this problem. Thanks in advance regards sarma Hi there, This error means that you need to re-compile your mysql server with openssl feature enable. Please check out more details at MYSQL site, hope it helps. Good luck & Take care. Dec 6 '06 #2 reply P: 18 sarma Hi there, This error means that you need to re-compile your mysql server with openssl feature enable. Please check out more details at MYSQL site, hope it helps. Good luck & Take care. Thanks shashi. I re-compiled with --openssl option and encountered same error. So I decided to use aes_encrypt() and aes_decrypt() functions instead of des_encrypt() and des_decrypt(). Anyways thanks shashi. regards sarma Dec 7 '06 #3 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics need mysql.sock mysql support missing need help debugging missing parenthesis New to MySQL...... Find Missing Data Installing
Google Plus API Youtube API Firebug WebP Web Dev Tools Exercises HTML CSSJavaScript C Programming Exercise C# Sharp Exercise Java PHPPython jQuery jQuery-UI MySQLSQLPostgreSQL ExercisesSQLite Exercises MongoDB Exercises Twitter Bootstrap ExamplesEuler Project Posts Wordpress Webhosting jQuery JavaScript CSS3 MySQL SQL HTML5 PHP Linux Featured: SQL Procedure,jQuery Exercises,C# Sharp Exercises,Python Exercises, HomeMySQL Home MySQL Installation MySQL Administration Tools MySQL Connectors and APIs MySQL Storage Engines (table types) MySQL Language Structure MySQL Data Types Connecting to and disconnecting from MySQL MySQL CREATE DATABASES, TABLES MySQL CONSTRAINT MySQL CREATE INDEX MySQL ALTER TABLE MySQL Partitioning MySQL Insert MySQL Update MySQL Delete MySQL basic select statement MySQL UNION Aggregate functions and grouping MySQL functions and operators Advance queries in MySQL MySQL JOINS MySQL Subqueries MySQL Procedure MySQL Triggers MySQL Transaction MySQL Views MySQL SecurityMySQL Show Commands MySQL DROP Exporting and importing data between mysql and microsoft excel MySQL backup and restore Working with PDO MySQL Cluster Overview MySQL Questions Answers MySQL Exercises MySQL SHOW COMMANDS Last update on August 25 2016 12:05:19 (UTC/GMT +8 hours) SHOW COMMANDS There are various forms of MySQL SHOW commands, which provides information about databases, tables, columns, or status information about the commands. See the following section : : Version : MySQL 5.6 Table of contents MySQL SHOW BINARY LOGS MySQL SHOW ERRORS MySQL SHOW SLAVE HOSTS MySQL SHOW BINLOG EVENTS MySQL SHOW EVENTS MySQL SHOW SLAVE STATUS MySQL SHOW CHARACTER SET MySQL SHOW FUNCTION CODE MySQL SHOW STATUS MySQL SHOW COLLATION MySQL SHOW FUNCTION STATUS MySQL SHOW TABLE STATUS MySQL SHOW COLUMNS MySQL SHOW GRANTS MySQL SHOW TABLES MySQL SHOW CREATE DATABASE MySQL SHOW INDEX MySQL SHOW TRIGGERS MySQL SHOW CREATE EVENT MySQL SHOW MASTER STATUS MySQL SHOW VARIABLES MySQL SHOW CREATE FUNCTION MySQL SHOW OPEN TABLES MySQL SHOW WARNINGS MySQL SHOW CREATE PROCEDURE MySQL SHOW PLUGINS MySQL SHOW CREATE TABLE MySQL SHOW PRIVILEGES MySQL SHOW CREATE TRIGGER MySQL SHOW PROCEDURE CODE MySQL SHOW CREATE VIEW MySQL SHOW PROCEDURE STATUS MySQL SHOW DATABASE MySQL SHOW PROCESSLIST MySQL SHOW ENGINE MySQL SHOW RELAYLOG EVENTS MySQL : SHOW BINARY LOGS SHOW BINARY LOGS statement is used to list the binary log files on the server. Here is the syntax : SHOW BINARY LOGS See the following examples : mysql> SHOW BINARY LOGS; +---------------+-----------+ | Log_name | File_size | +-------------