search for: hy000

Hi; It's been a while since I controlled my own server and I'm rusty. Trying to install mysql yum install mysql All looks well. Here's what happens: [root at 13gems www]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root at 13gems www]# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) There's no mysqld in the ps...

Hi, Fedora 14, wine version 1.3.18 when i try to connect to linux mysql server with command line: wine mysql.exe -h localhost -u root -p i got this error: ERROR 2005 (HY000): Unknown MySQL server host 'localhost' (10093) with this command line is all ok. wine mysql.exe -h 127.0.0.1 -u root -p linus hosts file /etc/hosts: 127.0.0.1 localhost 127.0.0.1 localhost.localdomain SQLyog is working fine with both "localhost" and "127.0.0.1&qu...

Romeo Petruca wrote: > wine mysql.exe -h localhost -u root -p First of all, why are you using windows' version or 'mysql' client and not native Linux version? Romeo Petruca wrote: > i got this error: > ERROR 2005 (HY000): Unknown MySQL server host 'localhost' (10093) Most likely it's trying to use pipe and fails of course. Add '--protocol=TCP' option.

I''m resending this with additional information, as I''ve had no response. I''ve been trying to use the fixture_references plugin, and I seem to be getting lots of: 1) Error: test_truth(DeviceTest): ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field ''description_id'' doesn ''t have a default value: INSERT INTO devices (`id`) VALUES (2) /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection _adapters/abstract_adapter.rb:128:in `log'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.1...

...) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") > sqlClear(xlsx,"newsheet2",errors=TRUE) [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "HY000?Þêÿÿ\003 -5410 [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM." > sqlClear(xlsx,"newsheet2",errors=TRUE) [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "HY000?Þêÿÿ\003 -5410 [Microsoft][ODBC Excel Driver] Deleting dat...

When I run # mysql I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) What do I need to do? The install of MySQL was done as part of the Centos setup. Todd

...Further testing revealed that at the moment MySQL can not create temporary files in /tmp. It is same for ANY database! SELinux is disabled. I logged to mysql as root and error is same. Command used is: CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE bak_menu; Error is: ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_0.frm' (errno: 9) What could be the problem, any idea how to proceed? I do not think I edited any MySQL setting. -- Ljubomir Ljubojevic (Love is in the Air) PL Computers Serbia, Europe StarOS, Mikrotik and CentOS/RHEL/Linux consultant

Hi, I recently upgraded to the latest MySQL 5.0.95 package as part of the CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for performance testing. However, if I try to use any of the profiling functionality I get this error: ERROR 1289 (HY000): The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-profiling' to have it working Oddly enough, profiling is enabled in the MySQL package bundled with CentOS 6.2, and was enabled in the package before on CentOS 5 (5.0.77 I think) I'm assuming this is...

...somehow phpmyadmin messed things up when I was trying to modify a table. The table disappeared, and now it's impossible to re-create it: MariaDB [time]> create table etikettend_metainfo (userID integer(6) unsigned, stationsnummer integer(4) unsigned, primary key (userID)); ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo` (errno: 150 "Foreign key constraint is incorrectly formed") MariaDB [time]> show tables like 'etikettend%'; +------------------------------+ | Tables_in_time (etikettend%) | +------------------------------+ | etikettend_eti...

...Distrib 5.0.95, for redhat-linux-gnu (i386) using readline 5.1 Connection id: 2 Current database: Current user: root at localhost SSL: Cipher in use is DHE-RSA-AES256-SHA The error with the new libssl looks like this: [root at hostname ~]# mysql ERROR 2026 (HY000): SSL connection error Has anyone else come across this? Is it a bug in SSL? Or a new restriction? Do I need to regenerate my certificates using the new openssl? Cheers Tony -- Tony Mountifield Work: tony at softins.co.uk - http://www.softins.co.uk Play: tony at mountifield.org - http://tony.mou...

Hi all, I've got a new server up, but it's not staying up.... After a day or so, it segfaults with: [Mar 22 23:17:49] WARNING[12177]: res_odbc.c:1406 _ast_odbc_request_obj2: SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.2(a) Driver]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 '7' at line 1 I'm using ODBC for sip and voice mail configuration. I'm running Asterisk 11.20.0-rc3. I've been...

...    <NA> 4 D:\\R files\\TestData        <NA> '31032008$'      TABLE    <NA> 5 D:\\R files\\TestData        <NA> '31032009$'      TABLE    <NA> > query = paste("SELECT * FROM", tables$TABLE_NAME[1]) > sqlQuery(connection,query) [1] "HY000 -3003 [Microsoft][ODBC Excel Driver] Syntax error in query.  Incomplete query clause." [2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM '30092007$''"        Thanks, Regards, Han Chin __________________________________________________ [[alternative HTML...

...ysql data from /var/lib/mysql to my new volume and ran both chown -R mysql:mysql * and chmod -R 660 * in order to setup correct ownership and rights for the data. It was working for a few days until today upon going into mysql and typing show databases, I receive the following error: ERROR 1018 (HY000): Can't read dir of '.' (errno: 24). I quickly double checked my rights and found them to be correct, then I restarted mysqld and this has fixed it for now. Has anyone else run into this problem? I am concerned that it will happen again if the actual cause is not corrected. I am run...

With my new Centos installation, I get the following error when I type in # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have Googled the error, but the results do not appear to be helpful Todd -- Ariste Software Petaluma, CA 94952 http://www.aristesoftware.com -------------- next part -------------- An HTML atta...

...have admin access. I can't figure out how to set up odbcConnect. For local access I set up a dsn via the windows admin interface. I have tried to set up dsn for access to our web server by providing the IP address and user id and passwords but get the error below. "Connection failed: [HY000] [MySQL] [ODBC 5.1 Driver]Host 'host86-180-150-32.range86-180.btcentralplus.com' is not allowed to connect to this MySQL server" Thanks Brett ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud servic...

hey guys My macbook pro 17 had to be taken back to apple beuase of a dud screen, so have had to install from macports again. When i attempt to create a mysql database with this: mysql5 -u root depot_development i get this: ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/opt/local/var/run/mysql5/mysqld.sock'' (2) any ideas? cheers! Adam -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscri...

...d I am not able to change them. That's not a problem, when I quote the table name: > sqlQuery(channel2, 'SELECT * FROM "anmeldung-alt"') Btw, if I swap ' and " it does not work: > sqlQuery(channel2, "SELECT * FROM 'anmeldung-alt'") [1] "HY000 -3003 [Microsoft][ODBC Paradox Driver] Syntaxfehler in Abfrage. Die Abfrage ist unvollst?ndig." [2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM 'anmeldung-alt''" It gets nasty, when I try to build a function and to substitute the 'SELECT * FROM &quo...

I get the following errors when attempting an ODBC connection to a MySQL db. 1: [RODBC] ERROR: state HY000, Code 0, message [MySQL] [ODBC 3.51 Driver] Could not determine the driver name so could not lookup setup library. 2: ODBCConnection failed in: odbcDriverConnect(st, case=case, believeNRows=believeNRows). Win XP sp2 MySQL 4.1.8 My SQLODBC 3.51.10 Package RODBC (latest) is installed. LibMySQL.dll...

...the common solution is to just create a symlink ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock The issue for me is I don''t have the file I am trying to symlink to (/var/run/mysqld/mysqld.sock) If I try to start mysql manually (mysql start) I get the error: # mysql start ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2) Thanks for any help. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Googl...

...ction id: 2 >> Current database: >> Current user: root at localhost >> SSL: Cipher in use is DHE-RSA-AES256-SHA >> >> The error with the new libssl looks like this: >> >> [root at hostname ~]# mysql >> ERROR 2026 (HY000): SSL connection error >> >> Has anyone else come across this? Is it a bug in SSL? Or a new restriction? >> Do I need to regenerate my certificates using the new openssl? >> >> Cheers >> Tony >> > > You should now be using mysql55 on CentOS-5, not my...