Connection Error
When I connect to the MySQL server (4.0.16 on Linux) using mysql and let the
tool sit for a couple of minutes, I get the following error.
mysql> use mysql;
No connection. Trying to reconnect...
Connection id: 50791
Current database: *** NONE ***
Database changed
mysql> use mysql;
Database changed
mysql>
The Java programs are displaying a similar error --> "java.sql.SQLException:
Communication link failure: java.io.EOFException, underlying cause: null"
No errors in the MySQL logs.
The max_connections are set to 1000. Why am I losing my connection to the
database?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Connection Error
I am currently running two servers one with Tomcat and the other with MySQL. They are both in different Windows domains and on different network segments. I have the following users on the MySQL server: user@localhost user@% I am getting a VERRRY SLOOOW connection between the two machines so I thought I'd add a user just for the Tomcat server. The IP address of the Tomcat server is 172.22.0.1 so naturally the user would be 'user@172.22.0.1' When I added this user I got the following error Access denied for user: 'user@172.22.0.1' (Using password: YES) Any ideas on what I can do to remedy the situation?
Error In Connection
2003 - Can't connect to MySQL server on 'localhost' (10061) I get this error
No Connection Error
When I connect to the MySQL server (4.0.16 on Linux) using mysql and let the tool sit for a couple of minutes, I get the following error. mysql> use mysql; No connection. Trying to reconnect... Connection id: 50791 Current database: *** NONE *** Database changed mysql> use mysql; Database changed mysql> The Java programs are displaying a similar error --> "java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null" No errors in the MySQL logs. The max_connections are set to 1000. Why am I losing my connection to the database? How can this be fixed?
Connection Error
I've a db named "controlloscatole" on my PC which has IP: 192.168.50.195 I've created a user which hasn't generic privileges but he has only SELECT privilege to "controlloscatole": GRANT USAGE ON * . * TO "rep_ammin"@ "%"IDENTIFIED BY "***************"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; REVOKE ALL PRIVILEGES ON `controlloscatole` . * FROM "rep_ammin"@ "%"; REVOKE GRANT OPTION ON `controlloscatole` . * FROM "rep_ammin"@ "%"; GRANT SELECT ON `controlloscatole` . * TO "rep_ammin"@ "%"; If i try to access to controlloscatole as rep_ammin: * via MysqlCC *host: localhostall is ok. *host: 192.168.50.195ERROR 2003: Can't connect on 192.168.50.195 (10061) * via phpmyadmin *http://localhost/mysql/all is ok *http://192.168.50.195/mysql/ALL IS OK!! * via ODBC *host: localhostall is ok. *host: 192.168.50.195ERROR 2003: Can't connect on 192.168.50.195 (10061) So if i try to connect to my db as rep_ammin from my PC i've no problem. On the contrary nobody in my office can do that... via Access (ODBC) or MysqlCC.
Connection Error
There seems to be a problem with the MySQL server, sorry for the inconvenience. So I start the MYSql server by the command: mysqld --skip-grant-tables and I can get in fine from the webside but once i get it out of this mode i can't hit it from the webside BUT i can hit it with MYSql GUI tools to setup users/db/grants/etc. All idea why and what i need to do?
Connection ERROR
I have been setting up a sever on one of my PC's using Apache and have installed MYSQL to work off it. Now i am getting error : CONNECTION FAILES: 2003 - Can't connect to MYSQL server on Localhost (10061) Now i have previously set this up and it has usually worked but i dont know what i have doen this time for it not to work? Has anyone got any ideas what i can do?
How To Solve This Connection Error?
I have this connection error in my windows application which is using .net connector. The error is "Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host" ? Can some one please help me on this?
MySQL Connection Error
I am trying to put together this PHP script using the database for IPB. I just can't get this one part of the script to work. It is supposed to access the members database, and it just can't find the members database. I get the error Quote: Unable to view external table, ipf_members. Table 'username_ipb.ipf_members' doesn't exist. username would be my MySQL username, but I won't post that. I know the username works, because all other MySQL connections using that same username work. I took the piece of code that wasn't working out of the file and tried putting it in its own little test file, and it still wouldn't work. PHP <?php$wgIPB_MySQL_Host = 'sql1.byethost7.com' // ipB MySQL Host Name.$wgIPB_MySQL_Username = 'username' // ipB MySQL Username.$wgIPB_MySQL_Password = 'k1tens' // ipB MySQL Password.$wgIPB_MySQL_Database = 'username_ipb' // ipB MySQL Database Name.$wgIPB_UserTB = 'ipf_members' // Name of your IPB user table. (i.e. ipb_members)$wgIPB_UserConvergeTB = 'ibf_members_converge' // Name of your IPB users converge table (i.e. ibp_members_converge)$wgIPB_GroupsTB = 'ibf_groups' // Name of your IPB groups table. (i.e. ipb_groups)$wgIPB_User_GroupTB = 'ibf_groups' // Name of your IPB user_group table. (i.e. ipb_groups)$username = "chris"; $connection = mysql_connect($GLOBALS['wgIPB_MySQL_Host'],$GLOBALS['wgIPB_MySQL_Username'],$GLOBALS['wgIPB_MySQL_Password']) or die ("Couldn't connect to server"); $db = mysql_select_db($GLOBALS['wgIPB_MySQL_Database'],$connection) or die ("Couldn't select database"); $getuserinfo = "SELECT `name` FROM " . $GLOBALS['wgIPB_UserTB'] . " WHERE `name` = "" . $username . """; // Query Database. $userResult = mysql_query($getuserinfo) or die("Unable to view external table " . $GLOBALS['wgIPB_UserTB'] . " " . mysql_error()); $userinfo = mysql_fetch_array($userResult); echo $userinfo['name'];?> I normally would use the $GLOBAL['variable'] if the variable was defined in the same file like the code above, but I just wanted to see if I could get this block of code to work. I know for a fact that ibf_members exists. Here is a screenshot from phpMyAdmin. I just don't know how to fix this problem! The table exists. I have tried repairing the table. I have tried reinstalling IPB. Nothing works!
Connection Error - Errno 4
I have a clients-server application that is using (the server) mysql. Time to time, I'm getting the error : Can't connect to MySQL server on 'x.x.x.x' (4) (mysql_errno = 2003). Mysql is 4.0.18. It's on a debian with 2.4.20. 4 is so the errno, wich here is : [color=blue] >Error code 4: Interrupted system call[/color] Is there a way to prevent mysql from beeing interrupted in its connection phase ?
Ado Connection String Error Through Vb
I'm using mysql-5.0.1-alpha-snapshot-win & VB 6.0 I'm having trouble connecting to the database server over a lan. When I use the following connection string from the server it works fine. - adoCon.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=MyDatabase;uid=root;" When I use the the following connection string from another computer I get this error - adoCon.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};SERVER=192.168.0.2;DATABASE=MyDatabase;uid=Tom;pwd=X12;" Run-time error '-2147467259(80004005)' [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '192.168.0.2' (10060) Also when I try the last connection from the database server and in vb (not compiled) I get the following error - Run-time error '-2147467259(80004005)' [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client In MySQL CC under users - Username = Tom Host = % Password=X12 Global privileges and MyDatabase are checked with All Privileges
MySQL Connection Error
I have my web server on a Linux machine. Apache 2.0, MySQL 5 and PHP 5 I have a utility (phpmaker) that helps me administer my databases. When I went to set it up I get this connection error. "Error on connect: Host 10.1.1.10 is not allowed to connect to this MySQL Server" Where do I enable so this ip (host) is allowed?
Connection Error Err Nr 1045
I am trying to set up MySQL 4.1 on windows 2003 web server. I have installed mysql and when configuring i get the Err Nr 1045 Access denied for user root@local host (using password: No) when trying to apply the security settings. I have running a linksys rooter. I have configured the rooter to allow access to port 3306 and forwarded to the web server.
Connection Error (2013) Using TCP/IP
When I try to connect to a remote MySQL server with following command: >mysql -h myhost.com -u mysql -p I'll occasionally get an error message saying: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 104 This is quite often when I using a remote client, but never happens if I use the local client on the MySQL server. Is this a known bug or anyone knows a solution to this problem? Code:
MySQL Connection Error
Using MySQL server config wizard, I created a database 'polls' and set passwd as 'admin'. I used the following PHP code to connect this db: $host = "localhost:3036"; $user = "polls"; $pass = "admin"; $conn = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); mysql_select_db($user) or die ("Unable to select database!"); and I got the following error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'polls'@'localhost' (using password: YES) in C:ServerApache2 htdocsPollsuser.php on line 17 Unable to connect! and BTW, what is the difference between the user name and db name? when I try to connect the db from DOS, it just prompted for password only, not username.
Dreamweaver Connection Error
I have set ODBC connection up through the data source administrator and get a connection just fine. However, in Dreamweaver I now get the 400 bad request error.
ODBC Connection Error
I am trying to configure an ODBC connection to a MySQL database, 5.0.12 Beta-nt. We testing the connection I get the following error; [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query If I try to connect via cmd prompt the following message is displayed; ERROR 2013 (HY000) : Lost connection to MySQL server during query The strange thing is if I disable Norton Internet Security all works fine. The Windows Xp firewall is turned off and Norton has been configured to allow MySQL.
Host Connection Error
I am getting an error, when I try to connect to the MySQL Administrator, I put in the computer IP and my username/password, but when I try to connect I get an error. The error reads... Error: Host "X.X.X.X" is not allowed to connect to... and then the rest of the error i can't read, it's been cut off. I did ping the host and it was fine, so there is not a network problem, or so i think... If someone could please tell me what is going on that wold be great.
Mysql Tcp Connection Error
The configuration of MySQL on my linux box is somehow set that I cannot use TCP to connect to it When I try to logon from the CLi/telnet, it says: Quote: [root@chrislinux chris]# mysql ERROR 1045 (00000): Access denied for user: 'root@localhost' (Using password: NO) If I try to use a connection within a program like Zend IDE, it says: Quote: Server connection failure during transaction. Due to underlying exception: 'null, message from server: "Host chris.linux is not allowed to connect to this MySQL server". I did have skip-networking uncommented but that just produced a pipe error. I have restarted mysql everytime I have made a change to my.cnf as well. Can anyone point me where to look to possibly find the cause of this? Thanks for any help anyone can give.
Remote Connection Error
I have been using a database on localhost for a while succesfuly. I am now, however going to be using this same database remotely. Whenever I attempt to connect to the database remotley I am given the error message: Warning: mysql_connect(): Can't connect to MySQL server on 'my ip' (10060) in C:OpenSAApache2htdocsindex.php on line 9 I have removed the bind-address line from the my.ini file in C:Windows as I read in a previous post you should do, and restarted mysql, but the error still remains. Does anyone know what i'm doing wrong?
MySQL Connection Error
I am new to remote mySQL connections. I am getting an error when I know the hostname for the connection is correct... please help ERROR Warning: Host 'oltws002.gaa.aro.allied.com' is not allowed to connect to this MySQL server in d:platformheader.php on line 231 Warning: MySQL Connection Failed: Host 'hoster.com' is not allowed to connect to this MySQL server in d:platformheader.php on line 231 Connection with MySQL server could not be made! Host 'hoster.com' is not allowed to connect to this MySQL server Contact Matt at matt@hoster.com if this problem persists.
Error 2003 On Remote Connection
I have a WinXP Home Edition where I have installed MySQL 4.x I can use MySQL Administrator on my server, but when I try to connect to my server by entering my WAN-IP, I get the error: "Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on xx.xx.xx.xx (10061)".
MySQL Start Up And Connection Error
I m new to mysql and recently installed 5.0.24a on my XP SP2 machine. Server ran fine for a coupla days.I then noticed that mysql admin client can't connect (error 10061). MySQL windows service has stopped for some reason, can't restart from windows services. Restart fails with the following error (from Windows event viewer) Event ID - 100 Description - listen() on TCP/IP failed with error 6
Error Establishing A Database Connection
I'm trying to use MySQL on my computer to design and test a WordPress blog locally, but I keep getting the message, "Error establishing a database connection." This isn't limited to WordPress; if I run a simple MySQL test script I get the same problem. I'm using MySQL 4.0.21 (I installed this old version after getting the same results with a couple of newer versions, so I don't think this is the problem). I'm on OS X 10.4.8. Using MySQL Administrator, I'm able to connect to the server as root. I created my wordpress schema and assigned all available connection privileges to root on localhost, [computername].local, and %. I'm used to creating a database and assigning a user to it using cPanel. I suspect the solution is simple and I'm overlooking something obvious because of my newbie status when it comes to MySQL.
Client Side Connection Error
I'm getting this error message: "Cannot connect to database. Client does not support authentication protocol requested by server; consider upgrading MySQL client" When attempting to connect with: $mysql = mysql_connect( 'localhost', 'root', 'password' ); MySQL Version: 4.1.8-nt via TCP/IP Client: 5.0.11 OS: Windows XP I believe that I have the latest client. What should I do and how should I ensure that none of the visitors to my site has the same problem?
UNION Causes Lost Connection ERROR 2013
I wrote a for loop to build several select statements that are combined with a UNION. When I execute one of the queries separately, it works, but when I execute the query with a UNION it returns: ERROR 2013 (HY000): Lost connection to MySQL server during query I am able to run additional queries after I get the error, so the connection is not lost. I have tried running the query with the union on MySQL Query Browser and also on the command prompt and I get the same results. Here is my query:
MYSql Windows 2003 - Connection Error
I installed MYSql/PHP/Apache on my Windows 2003 server. I created my database, added users and granted FULL perrmissions to all my uses but when i go to connect i get: There seems to be a problem with the MySQL server, sorry for the inconvenience. So I start the MYSql server by the command: mysqld --skip-grant-tables and I can get in fine from the webside but once i get it out of this mode i can't hit it from the webside BUT i can hit it with MYSql GUI tools to setup users/db/grants/etc.
ERROR 2013: Lost Connection To MySQL Server During Query
I have recently installed suse 9.0 linux which has MySQL 4.0.15 as part of the distribution. After I set up my users I was able to use mysqldump and pipe it into mysql on my windows machine running 4.0.16 to dump a database to the linux box. However, now when I try to login to the linux box from another machine on the network I get a query timed out error immediately after I enter the command line to start the mysql client. mysql -h 192.168.1.2 -u cdw -pxxxxxx ERROR 2013: Lost connection to MySQL server during query The error happens with in a small fraction of a second after I type in the command. I can login from the linux machine just fine though.
Error 2013: Lost Connection To MySQL Server During Query
I have MySQL 4.1.10 running successfully on an office XP machine, but when I try to set up similar XP box at home I continually get this error: "Error 2013: Lost connection to MySQL server during query". The install went fine, and Windows XP is recognizing it as a running service. But whenever I try to connect via one of my GUI applications (e.g., MySQLFront), the error appears. I have scoured this forum and Google looking for this error, but haven't found anything helpful so far. This post ... (http://forums.mysql.com/read.php?11,10684,10684) seemed similar, but my service does not stop when I hit the error. I've lost a couple days to this problem, and I've uninstalled and reinstalled the app several times. I don't know where to go next. I need to have 4.1 running because we need the Unions and Subqueries.
Network Problem - ERROR 2013 (HY000): Lost Connection ....
I'm having problems with my MySQL server when I do queries that return a lot of data over the network. It's fine if I connect via the local UNIX socket > mysql -u root -p > SELECT * FROM users limit 100; returns 100 rows in a few seconds >SELECT * FROM users limit 1000; returns 1000 rows in a few seconds But when I try the same thing but connecting to the network port I get > mysql -u root -p -h 127.0.0.1 -P 3306 > SELECT * FROM users limit 100; returns 100 rows in a few seconds > SELECT * FROM users limit 1000; sits there for about 15 minutes and then I get the following message ERROR 2013 (HY000): Lost connection to MySQL server during query If I watch the traffic with tcpdump it sends a few packets right at the start and then doesn't appear to be sending anything for the next 15 minutes until the error appears. I'm using 5.0.27-standard-log community edition.
Error 2013: Lost Connection To MySQL Server During Query
I have MySQL 4.1.10 running successfully on an office XP machine, but when I try to set up similar XP box at home I continually get this error: "Error 2013: Lost connection to MySQL server during query". The install went fine, and Windows XP says it has started and is running as a service. But whenever I try to connect via one of my GUI applications (e.g., MySQLFront), the error appears. I have scoured this forum and Google looking for this error, but haven't found anything helpful so far. I've lost a couple days to this problem, and I've uninstalled and reinstalled the app several times. I don't know where to go next. I need to have 4.1 running because we need the Unions and Subqueries.
Error 2013: Lost Connection To MySQL Server During Query
I get this message instantly (< 1 second) when I try to connect to the MySQL server from a remote host. I am using "mysql" at the remote client. Does not matter where the remote client is: on Solaris, on RH 7.2, on Fedora. Same thing every time. I am using the the mysqld as it comes out of the box on Red Hat Linux 8.0. I tried a google search on Error 2013, and there are a lot of responses:
SQL Execution Error # 2013. Response From Database: Lost Connection To MySQL Server
I'm upgrading to v4.1 from v3.2 on a Windows XP box; I did an uninstall on the previous version, but Windows services did not remove it as a service (v4.1 was logged as a new service, MySQL4). I breezed through the install process, but I get an error when I try to launch the .exe file from the command line. It says ... "ERROR 2013 (HY000): Lost connection to MySQL server during query." MySQL4 is now an automatically started service under Windows and mysqld-nt is operating in the Task Manager as a process. When I try to connect via MySQLFront, I get the following error message: "SQL execution error # 2013. Response from database: Lost connection to MySQL server during query."
User-defined Function: ERROR 2013 (HY000): Lost Connection To MySQL Server During Query
With mysql-4.1.1-alpha, using any User Defined Function ( UDF) at the query execution stage, on Linux 2.6, gave me the following error: "ERROR 2013 (HY000): Lost connection to MySQL server during query" However, upgrading to mysql-4.1.2-alpha seemed to solve the problem. Both versions were configured exactly as follows ../configure --with-openssl --enable-thread-safe-client --with-mysqld-ldflags =-rdynamic The only way I could solve this was by upgrading to 4.1.2-alpha-log. Then, recompiling the functions, drop the old UDF functions, then, recreate. So far so good. Anyway, if you run into this problem, or just want more detail on the sample User Defined Functions that come with MySQL ( /sql/udf_example.cc), I've put my notes in the following link ( TIP 27 )
Lost Connection To MySQL Server During Query Socket Error On Read. WSAGetLastError Return 10054($2746)
We just migrated our MySQL database from a NetWare server running version 5.0.21 to a openSUSE box running version 5.0.45. Everything ran fine for a couple of days, then clients began losing their connections and creating new ones without the old threads being terminated. This behavior is the same for the Delphi client we use to access our database as well as the MySQL Administrator tool. I've tried adjusting connection_timeout, but overall the settings for this server are the same as the previous one that ran without issues for a year.
Encountering 2013 Error ("Lost Connection To MySQL Server...")
I have a nightly job that performs backups on my MySQL servers. There are three production MySQL instances on different machines. My backups have been running successfully for months (until now). However, on last night's backups for one instance, a couple of database/schemas (appear to have) backed up successfully, but the larger schemas failed, as follows: ======================================= Backup of schema dhunt was successful in 0 seconds Backup of schema mysql was successful in 0 seconds Backup of schema support_appl was successful in 0 seconds Error: Backup of schema support_dict was not successful (1115 seconds): mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server Error: Backup of schema test was not successful (0 seconds): mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect ======================================= I re-ran the backup cron job with the same results. Does anyone have any troubleshooting suggestions?
Changes Made In One Connection Does Not Reveal In Another Connection At Once.
I use many connection and the same as many threads in my server app to gain performance on a multicpu machine. Firstlly i call "set autocommit=0" and wrap every statements with "start transaction " and "commit". i use mysql_stmt_execute for every statement rather than mysql_real_execute except those that can't be prepared. The version of mysql is 4.1.11 under Debian linux. In one connection of one THREAD i insert a row into a table. After i got the sucess code and the last insert id, i then do a "select" from another connection in another THREAD with the "last insert id" return by the previous insert . I expect the select can fetch the row that i have just insert , but some time it does and some time it doesn't. is there any funtion like "mysql_....flush...cache.." to make the changes from one connection to be reveal to the global at once?
Create Table Error. #1064 - You Have An Error In Your SQL Syntax; Check The Manual That Corresponds
I have been trying to create two tables with the SQL below. I have the SQL in file and tried to import it to PhpMysqlAdmin in my control panel. The wierd thing is that the first table gets created while the second one is not created and error is thrown instead. The error message is #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ....
ERROR 1010 (HY000): Error Dropping Database (can't Rmdir '.a', Errno: 41)
I am using MySql 5.0.21-community Edition for widows XP. I can successfully connect to the MySql Server as a root and create a database 'a'. Which creates a directory 'a' under my mysqldata directory with a single file 'db.opt'. Now dropping the database 'a' gives the following error ERROR 1010 (HY000): Error dropping database (can't rmdir '.a', errno: 41) The directory mysqldataa does not have any other files or hidden files. The commands I have executed are: ------------ Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 6 to server version: 5.0.21-community-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> create database a; Query OK, 1 row affected (0.09 sec) mysql> drop database a; ERROR 1010 (HY000): Error dropping database (can't rmdir '.a', errno: 41) mysql> --------- I have searched web, lists, bugs and could not find any.
Error 1064 Restoring PhpMyAdmin Dump (error On Foreign Key Clause)
I am getting an Error 1064 when I try to restore a dump I created using phpMyAdmin from an online database into a newly created database on my home system. The error points to a section of the dump file that adds foreign key constraints. I've already disabled the foreign key checks. The problem seems to occur only with tables in which I have more than one foreign key. The dump file foreign key constraint section looks very odd to me because multiple ALTER TABLE statements to add foreign keys are separated only by commas, not semi-colons, and even weirder, each time a new statement to add a foreign key constraint is created, it is then repeated in the creation of the next foreign key constraint. Code:
I Get This Error Error: Libmysqlclient.so.10: Cannot Open Shared Object File:
I have moced an app from one server to another and I am testinga python module that will extract lead from a database and send them to our email vendor. However, In running the script as a test, I get this error: Import Error: libmysqlclient.so.10: cannot open shared object file: What doe sit mean and is there an easy way to fix it?
Got Error 134 From Storage Engine. Error Number 1030
Sometimes when I execute a query on a database, I get the following error from MySQL: Got error 134 from storage engine. Error number 1030 Does anyone know what this mean? What does error 1030 mean and can I get other values for error 134? I heard people saying that this is an indication that a table got corrupted, but I want to hear more about this problem.
Mysqldump, Getting Error Error #1016, Can't Open *.ibd File
So we have a MySQL database that suddenly started reporting "can't open *.ibd file" errors on InnoDB tables in phpMyAdmin. (MyISAM are fine). To recover the data is all I want at this point -- so one suggestion I came across was to try and dump using mysqldump like this: mysqldump -u root -p mydatabase databasedump.sql Enter password: ******************* mysqldump: Got error: 1016: Can't open file: 'access.ibd' (errno: 1) when using LOCK TABLES Is there a way to run this dump so that it will export the database tables and ignore the *.ibd error? I had read that removing *.frm files might help, but our testing suggests that it isn't effective either.
New Error 1146 Error And Behavior With Mysqlcc + Mysql-5.0.15
I have just switched from mysql-4.1.14 on a FreeBSD-4.11 box to mysql-5.0.15 on a FreeBSD-6.0 box. In both environments I use mysqlcc to select, insert and update tables. On the 4.1.14 machine, using mysqlcc, I could double click in a field and change its value; only if I had selected all the fields. I couls not do this if I had selected a subset of the fields. The number of rows returned didn't matter, as long as I did "select * from..." I could directly edit a field value in mysqlcc. Now, under mysql-5.0.15, I cannot edit fields at all, whether I "select * from..." or not. And every select I do gives me this error in mysqlcc's explain pane: [mymachine] ERROR 1146: Table 'tablename.1' doesn't exist Well it certainly does exist, and I can edit its values using the mysql client or phpmyadmin (ugh, clumsy). There are lots of posts on the net about error 1146 and various apps and various versions of mysql and even mysqlcc. mysqlcc had this problem with an earlier version of mysql than 5.x but this supposedly was fixed with release 0.94. Can anyone give me some insight on what's going on here, or a workaround? Or another gui client that works as well as mysqlcc?
|
TRACKER
