Search
Search titles only
By:
Search titles only
By:
Forums
New posts
Search forums
What's new
New posts
Latest activity
Feedback
View Statistics
Members
Current visitors
Buy Sell Trade
WTB
Log in
Register
Search
Search titles only
By:
Search titles only
By:
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Forums
Technology
Programming
Any MySQL DB experts here ?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="KiD0M4N" data-source="post: 185188" data-attributes="member: 929"><p>ok i hv come accross this issue before hand and you wont beleive what was causing this.</p><p></p><p>a previous installation in the same location.</p><p></p><p>i had selected InnoDB as my storage engine and it creates transaction logs (files basically which store the transaction data since InnoDB is a Transaction enabled DBMS) which persisted through to my next installation.</p><p></p><p>And I got these errors + many more (like authentication error, et cetera.)</p><p></p><p>My first line of attack towards this issue would be a uninstallation followed by deletion of the directory in which MySQL was installed. Then download latest version of MySQL from <a href="http://www.mysql.com" target="_blank">MySQL AB :: The world's most popular open source database</a> and install it (i believe its 5.1, much better and scalable compared to 4.x and has support for triggers, stored procedures and many more)</p><p></p><p>However, if this is not the issue, I beleive you dont have read access to the "sys" tables. As "METADATA" about the tables you create (like information about the columns, the datatypes, the primary + foreign keys, indices etc) also need to be stored in some table, the problem could be manifesting itself because the engine (same as the MySQL backend) is unable to create the requisite meta data to describe the table and thus you are not able to create the tables.</p><p></p><p>Any ways, try boh approaches and report back.</p></blockquote><p></p>
[QUOTE="KiD0M4N, post: 185188, member: 929"] ok i hv come accross this issue before hand and you wont beleive what was causing this. a previous installation in the same location. i had selected InnoDB as my storage engine and it creates transaction logs (files basically which store the transaction data since InnoDB is a Transaction enabled DBMS) which persisted through to my next installation. And I got these errors + many more (like authentication error, et cetera.) My first line of attack towards this issue would be a uninstallation followed by deletion of the directory in which MySQL was installed. Then download latest version of MySQL from [url=http://www.mysql.com]MySQL AB :: The world's most popular open source database[/url] and install it (i believe its 5.1, much better and scalable compared to 4.x and has support for triggers, stored procedures and many more) However, if this is not the issue, I beleive you dont have read access to the "sys" tables. As "METADATA" about the tables you create (like information about the columns, the datatypes, the primary + foreign keys, indices etc) also need to be stored in some table, the problem could be manifesting itself because the engine (same as the MySQL backend) is unable to create the requisite meta data to describe the table and thus you are not able to create the tables. Any ways, try boh approaches and report back. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Technology
Programming
Any MySQL DB experts here ?
Top
Bottom