RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 15 rows in set (0.00 sec) mysql select host,user,password from mysql.user; +---+--+---+ | host | user | password | +---+--+---+ | localhost | root | *Exxx5D8x37183xxx5EBADF2A | | localhost | yannick| | | localhost | xxx| *Ex | +---+--+---+ 1 row in set (0.00 sec) have you tried an update ? mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass') WHERE User='yannick' AND Host='localhost'; mysql FLUSH PRIVILEGES; Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, I would love to do it but this is the answer : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test'); ERROR 1133: Can't find any matching row in the user table mysql I also succeeded to enter with mysqladministrator. (Without password !) The strange thing is that when I go to user admin he tells me: could not retrieve user privilege info . It looks like there is not file for username and passwords. If I try to add a user, the program shut. Where should I check if there is such user file file ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 12:36 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Since you can connect as yannick without password, just set it after login : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass'); see http://dev.mysql.com/doc/mysql/en/set-password.html for more details. I advice to set it to another password than your yannick linux one. Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, Did what you asked : [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 134 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works only if I put NO password. If I put the password of yannick it doesn't work. But here as well, I must confuse the username yannick in mysql and the user yannick in linux. I can not ask the administrator what password he put because I am the administrator of this computer !! :)) Also, I have just installed MysqlAdministrator and here as well, I can not access the server... Same error messages. How can I add set the root password ? How can I flush the privilidges ? Thanks Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 12:01 AM À : Mathias Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Another thing : fujitsu:/home/yannick # mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/home/yannick # is normal: try fujitsu:/home/yannick # mysql -u yannick -p Mathias Selon Mathias [EMAIL PROTECTED]: Hi , You did a confusion between root for mysql (wihich is SA or DBA group) and the root of the OS. have you ever installed mysql in windows. there is a root user even in windows. What you must do is to ask the person who installed for the Mysql root password and check the users created in the database. If the root password haven't been set, do it and flush privileges. Selon Yannick [EMAIL PROTECTED]: Nils, Thanks for your support but still not working. All I need is to have MYSQL installed with a root password. For exemple, I can never login when I am a root user. I always need to be a user like yannick I can also not make any request other the localhost as when I add -h fujitsu, he makes re request on fujitsu.local. How can I check the 4 databases to see what host has been used for
Re: SQL help
On 6/26/05, 2wsxdr5 wrote: Can someone tell me why this query works... SELECT UserKey FROM( SELECT UserKey, Count(GiftKey) Gifts FROM Gift Group BY UserKey ) GC WHERE GC.Gifts = 3 Why this construction and not simply: SELECT UserKey FROM Gift GROUP BY UserKey HAVING Count(GiftKey) = 3 And this one doesn't? SELECT UserKey, UserID, FROM User WHERE UserKey IN (SELECT UserKey FROM( SELECT UserKey, Count(GiftKey) Gifts FROM Gift Group BY UserKey ) GC WHERE GC.Gifts = 3 ) How do you mean doesn't work? Does it give an unexpected result or an error? User info about the users UserKey is the key Gift list of gifts each user has on their wish list foreign key is UserKey Event ---gift giving events for users. foreign key is UserKey Emails email addresses users have sent a message to about their wish list. UserKey is the foreign key here too. The relationship between user and the other 3 tables is a 1 to many. I have the following query that I need to adjust some. SELECT u.UserKey, UserID, Count(distinct g.GiftKey) gifts, Count(distinct ev.EventKey) events, Count(distinct e.Email) Emails FROM User u NATURAL LEFT JOIN Gift g LEFT JOIN Emails e ON e.Userkey = u.UserKey LEFT JOIN GiftGivingEvent ev ON ev.UserKey = u.UserKey GROUP BY UserID What I really want is only the users where the gifts count is 3, the Event count is 1, the Emails count is 5 and and only count emails if e.Verified is = 1 I think you mean the following: SELECT * FROM User INNER JOIN ( SELECT UserKey, Count(UserKey) AS gifts FROM Gift GROUP BY UserKey HAVING Count(UserKey) 3 ) USING (Userkey) INNER JOIN ( SELECT UserKey, Count(UserKey) AS events FROM Event GROUP BY UserKey HAVING Count(UserKey) 1 ) USING (Userkey) INNER JOIN ( SELECT UserKey, Count(UserKey) AS emails FROM Emails WHERE Verified = 1 GROUP BY UserKey HAVING Count(UserKey) 5 ) USING (Userkey) Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CHECK constraint
Hi, your enum canbe NULL and is not indexed. So you can insert values not in enum, replaced by NULL. a solution is to UNIQUE index the enum column, and insert a unique bad value in it. Any value not in enum can not then be inseted : mysql create table enum_test(id int, name enum('test1','test2') NOT NULL, UNIQUE KEY(name)); Query OK, 0 rows affected (0.06 sec) mysql desc enum_test; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | id| int(11) | YES | | NULL| | | name | enum('test1','test2') | | PRI | test1 | | +---+---+--+-+-+---+ 2 rows in set (0.00 sec) mysql INSERT INTO enum_test VALUES (0,'test3'); Query OK, 1 row affected, 1 warning (0.02 sec) mysql INSERT INTO enum_test(id) VALUES (1); Query OK, 1 row affected (0.01 sec) mysql SELECT * from enum_test; +--+---+ | id | name | +--+---+ |0 | | |1 | test1 | +--+---+ 2 rows in set (0.00 sec) mysql INSERT INTO enum_test VALUES (1,'test3'); ERROR 1062 (23000): Duplicate entry '' for key 1 Mathias Selon Michael Kruckenberg [EMAIL PROTECTED]: Hi, Use enum with a default type and let mysql do the check for you. The problem with an enum is that if you insert a value that's not in the enum, MySQL doesn't stop the insert, it leaves the column empty. This doesn't enforce data integrity like I think Chris wanted. mysql desc enum_test; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | id| int(11) | YES | | NULL| | | name | enum('test1','test2') | YES | | test2 | | +---+---+--+-+-+---+ 2 rows in set (0.25 sec) mysql INSERT INTO enum_test VALUES (1,'test3'); Query OK, 1 row affected, 1 warning (0.29 sec) mysql SELECT * from enum_test; +--+--+ | id | name | +--+--+ |1 | | +--+--+ 1 row in set (0.00 sec) Mike Kruckenberg [EMAIL PROTECTED] ProMySQL Author http://www.amazon.com/exec/obidos/ASIN/159059505X Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 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 '' at line 1 mysql quir - ; ERROR 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 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec) mysql select host,user,password from mysql.user; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql select host,user,password from mysql.test; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 8:35 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 15 rows in set (0.00 sec) mysql select host,user,password from mysql.user; +---+--+---+ | host | user | password | +---+--+---+ | localhost | root | *Exxx5D8x37183xxx5EBADF2A | | localhost | yannick| | | localhost | xxx| *Ex | +---+--+---+ 1 row in set (0.00 sec) have you tried an update ? mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass') WHERE User='yannick' AND Host='localhost'; mysql FLUSH PRIVILEGES; Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, I would love to do it but this is the answer : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test'); ERROR 1133: Can't find any matching row in the user table mysql I also succeeded to enter with mysqladministrator. (Without password !) The strange thing is that when I go to user admin he tells me: could not retrieve user privilege info . It looks like there is not file for username and passwords. If I try to add a user, the program shut. Where should I check if there is such user file file ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 12:36 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Since you can connect as yannick without password, just set it after login : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass'); see http://dev.mysql.com/doc/mysql/en/set-password.html for more details. I advice to set it to another password than your yannick linux one. Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, Did what you asked : [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 134 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works only if I put NO password. If I put the password of yannick it doesn't work. But here as well, I must confuse the username yannick in mysql and the user yannick in linux. I can not ask the administrator what password he put because I am the administrator of this computer !! :)) Also, I have just installed MysqlAdministrator and here as well, I
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 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 '' at line 1 mysql quir - ; ERROR 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 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec) mysql select host,user,password from mysql.user; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql select host,user,password from mysql.test; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 8:35 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 15 rows in set (0.00 sec) mysql select host,user,password from mysql.user; +---+--+---+ | host | user | password | +---+--+---+ | localhost | root | *Exxx5D8x37183xxx5EBADF2A | | localhost | yannick| | | localhost | xxx| *Ex | +---+--+---+ 1 row in set (0.00 sec) have you tried an update ? mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass') WHERE User='yannick' AND Host='localhost'; mysql FLUSH PRIVILEGES; Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, I would love to do it but this is the answer : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test'); ERROR 1133: Can't find any matching row in the user table mysql I also succeeded to enter with mysqladministrator. (Without password !) The strange thing is that when I go to user admin he tells me: could not retrieve user privilege info . It looks like there is not file for username and passwords. If I try to add a user, the program shut. Where should I check if there is such user file file ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 12:36 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Since you can connect as yannick without password, just set it after login : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass'); see http://dev.mysql.com/doc/mysql/en/set-password.html for more details. I advice to set it to another password than your yannick linux one. Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, Did what you asked : [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 134 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works only if I put NO password. If I put the password of yannick it
Fwd: [mysql 11629] 6月号のニュースレター
Zen Kishimoto [EMAIL PROTECTED] wrote: Subject: [mysql 11629] 6月号のニュースレター Date: Fri, 24 Jun 2005 17:40:50 -0700 From: Zen Kishimoto [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] 岸本@大阪です。6月号のニュースレターを お届けします。 ー ハイライト MySQL 5.0 のQAのプロセスを助けるために、5.0をテストして くれるユーザを求めています。特に、キーな機能の stored procedure, view, triggerなどです。これに関しては 以下の記事をご参照ください。 http://dev.mysql.com/tech-resources/articles/evaluating-mysql-5.0.html 5.0のテストに貢献のあった人や間接的に他のユーザ に5.0のことを知らしめた人には、クールなスタッフ(T-shirts, マグや本) を提供します。 bugs.mysql.comでのバグレポート。関連するforums.mysql.comでの一番 助けになった人々。一番良いMySQL 5.0 関連の記事(紙とオンライン)や ウエブサイト。MySQL 5.0 に関するブログ。 ブログや記事、URLに関してはここに 紹介を書いてください。 http://www.mysql.com/company/contact/?topic=community MySQLは世界規模でMySQL 5.0のトレーニングのワークショップを展開 5月末、MySQLは2日間のトレーニングのワークショップを発表。 これは開発者とDBAに新しいエンタープライズの機能を 紹介するためのものです。ワークショップは San Francisco, Washington DC, Toronto, Munich, London and Parisで 開催されます。 詳細は http://www.mysql.com/training/workshops/mysql-5-in-depth.html MySQLはエンジニアリング、コンサルとQA部門で社員を募集中 詳細は http://www.mysql.com/company/jobs/ 製品 MySQL (5.0.7 Beta)のリリース これは5.0ベータの4番目です。Stored Procedure, View, Trigger, Information Schema (Data Dictionary), XA とその他を含みます。追加機能は: オプティマイザーを改善しindexed_col NOT IN (val1, val2, ...) とindexed_col NOT BETWEEN val1 AND val2..の形式の エクスプレッションにインデクスを使用することを可能にした。 (バグ番号 #10561 http://bugs.mysql.com/10561) --with-big-tablesのコンパイルのオプションをコンフィギュレーション 用に追加した。 stored function内からInnoDBテーブルにアクセスした際に サーバーがクラッシュする問題を修正。 stored functionまたは triggersはっきりとしたコミットやロールバックを行うステートメント の禁止(バグ番号 10015 http://bugs.mysql.com/10015) Windows上でlower_case_table_names を2にセットして、ALTER TABLE を使用して大文字と小文字の混ざったMEMORYまたはInnoDBテーブル を変更する場合、誤って名前を小文字に変換してしまう。 バグ番号 9660 http://bugs.mysql.com/9660) 全ての努力は今バグ修理と安定化に注がれています。 MySQL 5.0 betaを今テストして、早い目に慣れましょう。 変更の詳細は http://lists.mysql.com/announce/289 ダウンロードは http://dev.mysql.com/downloads/mysql/5.0.html MySQLマイグレーション・ツールキット1.0.7 ベータのリリース MySQLマイグレーション・ツールキットはプロプリエタリのデータべース をMySQLにマイグレートするフレームワークです。 詳細情報は: http://www.mysql.com/products/migration-toolkit Windows用のソースとバイナリーのダウンロードはこちらから http://dev.mysql.com/downloads/migration-toolkit このはリリースでMS SQL Server からのマイグレーション をサポートし、多くのバグを修正しました。このリリース にアップデートすることをお勧めします。 新機能は - MS SQL Server 2000のサポート - 対象スキーマ・オブジェクトの名前変更 修正されたバグは - テーブルからの不完全なデータ・トランスファー - Access BYTEと BIT がunsigned データ・タイプに変換されない - Datetime コラムに時間がない - Oracle/MS Access がのデータタイプでマップされないものがある MaxDB (7.6.00.10) がリリース これは新機能とバグ修理を含むプロダクション・リリース で以下を含みます。 スキーマによって拡張されあUser/user-groupの機能 データベースのフルの状況を自動的に処理 オペレーター・ベースのjoinの実装 詳細は http://dev.mysql.com/doc/maxdb/intro_76.html ソースとバイナリのダウンロードは http://dev.mysql.com/downloads/maxdb/7.6.00.html ヒント MySQL: 完全レファレンス 14章: セキュリティ、アクセスコントロールと特権 大抵のユーザはMySQLのデータベースとテーブルに集中します。 そこが一番大切です。 しかし、あまりアクセスの特権、パスワード、 セキュリティをどのように取り扱おうか深く考えません。 それを考慮にいれて、この章はMySQLのアクセスコントロール を吟味して、MySQLのgrant テーブルに光をあててみます。 こういったテーブルは、サーバーのセキュリティのシステム の重要な部分を形成します。データベースの管理者に システムのアクセスをコントロールする際に 柔軟性を決定するのに役立ちます。 この章の完全なテキストは http://dev.mysql.com/tech-resources/articles/mysql-complete-reference-ch14.html MySQL Network用のDell ベンチマークとサイズのガイド この技術ホワイトペーパーは性能の結果、ベストプラクティスとチューニング の技術をDellとMySQLの専門家であるDave Jaffe、Todd MuirheadとPeter Zaitsev が提供します。Dell PowerEdge 2800とMySQLの認定版を使ってDVD Store のアプリを使って1分に1900のトランザクションの記録を (これは年間に直すと10億回となります。)達成しました。 MySQL Network用のDell Sizing Guideのダウンロードは http://www.dell.com/downloads/global/solutions/mysql_network_2800.pdf DELLからのDVD Store ベンチマークのアプリケーションは http://linux.dell.com/dvdstore/ 新しいディスカッション・フォーラム 性能 このフォーラムは性能のチューニング、最適化、MySQLのベンチマークに 興味のある人用です。 フォーラムに行くにはここをクリック http://forums.mysql.com/list.php?24 リプリケーション このフォーラムはMySQL のリプリケーションに興味のある人 用です。master/slaveも含みます。多量のウエブや データウエアハウスのスケール・アウトするアプリに ついて語りましょう。 フォーラムに行くにはここをクリック http://forums.mysql.com/list.php?26 クラスター このフォーラムは MySQL Clusterを使って高いアベイラビリティを 持つアプリを開発する人用です。 フォーラムに行くにはここをクリック http://forums.mysql.com/list.php?25 イベント ライブのウエブ・セミナー: データベースのクラスター: MySQL と Emic Networksを使用したSecurities Americaの成功例 2005年6月23日午前2時 データベースのクラスタリングはMySQLのアベイラビリティと スケーラビリティを改善する方法です。このウエブ・セミナーに 参加してSecurities Americaから実際の応用と成功を 学びましょう。このセミナーでは How Securities America (American Expressの子会社) MySQLのデータベースのクラスターを使用してビジネスに クリティカルなシステムをサポートしています。 いかにMySQL Cluster が安価に展開されるか。 いかにクラスタリングがMySQLの恩恵を延長して大変クリティカル で要求の多いアプリをサポートできるか。 いかに、クラスタリングが更なるアベイラビリティ、スケーラビリティ と管理性を達成できるか。 登録は http://www.emicnetworks.com/index.php?option=com_contenttask=viewid=216Itemid=88 ライブのウエブ・セミナー: MySQLを使用してデータベースのTCOを下げましょう。 Wednesday, 2005年6月22日 9:00 am London; 10:00 am Paris/Berlin; 11:00 am Helsinki データベースのTCOは最初のライセンス費だけではありません。 このウエブセミナーではLycos EuropeがいかにしてOracle からMySQLにマイグレートして85%ものコストを削減したかを 語ります。 登録は http://www.mysql.com/news-and-events/web-seminars/lycos-lowering-tco.php ウエブ・セミナーの繰り返し: 性能チューニングの5大ヒント アプリが忙しい時に遅くなりますか。性能のボトルネックを 調べるのが困難ですか。性能の問題を見つけ、解決するのに
Re: upgrade mysql 3.23.58 to 4.1
Hi, There is a lot a pain here. I downloaded the rpm packages MySQL-server-4.1.12-1.i386.rpm MySQL-shared-4.1.12-1.i386.rpm MySQL-bench-4.1.12-1.i386.rpm MySQL-shared-compat-4.1.11-0.i386.rpm MySQL-client-4.1.12-1.i386.rpm MySQL-devel-4.1.12-1.i386.rpm MySQL-embedded-4.1.12-1.i386.rpm MySQL-Max-4.1.12-1.i386.rpm Maximum RPM said: --- rpm -qp --queryformat %{defaultprefix}\n packagefile Just replace packagefile with the name of the package file you want to check out. If the package is not relocatable, you'll only see the word (none). This doesn't work. -- [EMAIL PROTECTED] MySQL]$ rpm -qp --queryformat %{defaultprefix}\n MySQL-Max-4.1.12-1.i386.rpm warning: MySQL-Max-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: incorrect format: unknown tag The MD5 check sum was OK bat Signature Checking Using RPM was not. --- My Linux experience is short so I have to read a lot for every movement. If you can gave me more help ti will be easier for me. Thanks, MT Kishore Jalleda wrote: Yes You can have both versions, infact this is the preferred way to upgrade, but the only thing is that have the new version install in /usr/local/mysql2/ or what ever you want and change the port that the newer daemon listens on instead of the default 3306, here's a good link from the doc's of mysql... http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html Hope this helps, Kishore Jalleda On 6/24/05, mm [EMAIL PROTECTED] wrote: I have on my system, Fedora core 3, MySql 3.23.58 Working with wikipedia database I get one error an one advise to upgrade to Mysql 4.xx Can I have old mySQL and the new one on my system? It is necessary to recreate databases and reload the data? What other kind of problem is suppose to find on my way during upgrade? Thanks, MT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
Selon mm [EMAIL PROTECTED]: Hi, There is a lot a pain here. I downloaded the rpm packages MySQL-server-4.1.12-1.i386.rpm MySQL-shared-4.1.12-1.i386.rpm MySQL-bench-4.1.12-1.i386.rpm MySQL-shared-compat-4.1.11-0.i386.rpm MySQL-client-4.1.12-1.i386.rpm MySQL-devel-4.1.12-1.i386.rpm MySQL-embedded-4.1.12-1.i386.rpm MySQL-Max-4.1.12-1.i386.rpm Maximum RPM said: --- rpm -qp --queryformat %{defaultprefix}\n packagefile Just replace packagefile with the name of the package file you want to check out. If the package is not relocatable, you'll only see the word (none). This doesn't work. -- [EMAIL PROTECTED] MySQL]$ rpm -qp --queryformat %{defaultprefix}\n MySQL-Max-4.1.12-1.i386.rpm warning: MySQL-Max-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: incorrect format: unknown tag The MD5 check sum was OK bat Signature Checking Using RPM was not. --- My Linux experience is short so I have to read a lot for every movement. If you can gave me more help ti will be easier for me. Thanks, MT Kishore Jalleda wrote: Yes You can have both versions, infact this is the preferred way to upgrade, but the only thing is that have the new version install in /usr/local/mysql2/ or what ever you want and change the port that the newer daemon listens on instead of the default 3306, here's a good link from the doc's of mysql... http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html Hope this helps, Kishore Jalleda On 6/24/05, mm [EMAIL PROTECTED] wrote: I have on my system, Fedora core 3, MySql 3.23.58 Working with wikipedia database I get one error an one advise to upgrade to Mysql 4.xx Can I have old mySQL and the new one on my system? It is necessary to recreate databases and reload the data? What other kind of problem is suppose to find on my way during upgrade? Thanks, MT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi, if you transfered them from windows to linux with ftp without binary, that should be the reason. just retransfer using binary mode. ELse, i can't see. have you tried an install of one of them ? Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
mm wrote: There is a lot a pain here. I downloaded the rpm packages that's where the pain starts :-) If you're trying to run multiple versions of MySQL for pre-migration testing (or whatever), *don't use rpms* -- get the tar file of the binary, and just untar it as /usr/local/mysql-4.1.12 or whatever. It will be *so* much simpler to switch between the old and new, or run them simultaneously as needed. FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about field length for integer
Hi, is there anyway that I can have more than 20 digits for integer (bigInt)? If not, what I can use for database index? - Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server ! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter mysql and to the things requested mainly because there is a security issue. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 4:03 PM À : [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, Sorry but you are not the administrator else you have the root password. So why search midday at 14 ? Just connect with root pass and see if mysql is here. Else mysql is like the other databases in /var/lib/mysql/mysql I really can't see how an administrator haven't the administrator password Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, How can I do this ? I am the admin of this pc. We've tested it before I think and it did not work. I still think it is because there is no user file. Where can I found this file ? Where is it on the pc ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 10:38 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 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 '' at line 1 mysql quir - ; ERROR 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 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec) mysql select host,user,password from mysql.user; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql select host,user,password from mysql.test; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 8:35 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 15 rows in set (0.00 sec) mysql select host,user,password from mysql.user; +---+--+---+ | host | user | password | +---+--+---+ | localhost | root | *Exxx5D8x37183xxx5EBADF2A | | localhost | yannick| | | localhost | xxx| *Ex | +---+--+---+ 1 row in set (0.00 sec) have you tried an update ? mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass') WHERE User='yannick' AND Host='localhost'; mysql FLUSH PRIVILEGES; Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, I would love to do it but this is the answer :
Re: Unable to install mysql
Hi! I'm not sure you understand the issue. I have the root in linux but not in mysql! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter mysql and to the things requested mainly because there is a security issue. hmm... when you've just installed mysql, it has only root user with no password from localhost with all privilegies and any user (for example, yannick) from localhost with no privilegies (only test database). so just login (after install) in mysql using root account with no password - can't you? -- wbr, sergey v. spivak mysql #spivak.kiev.ua zlob-uanic/eunic/ripe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
hi Yannick, This is my ultimate help. See this url, you have all in it : http://dev.mysql.com/doc/mysql/en/unix-post-installation.html And all you want is here : http://www.mysql.com/search/?q=Installation If you're root, install mysql as root. At the end, change the mysql root password to a password different from the linux root. Then create other users and databases. Mathias Selon Yannick [EMAIL PROTECTED]: Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server ! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter mysql and to the things requested mainly because there is a security issue. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 4:03 PM À : [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, Sorry but you are not the administrator else you have the root password. So why search midday at 14 ? Just connect with root pass and see if mysql is here. Else mysql is like the other databases in /var/lib/mysql/mysql I really can't see how an administrator haven't the administrator password Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, How can I do this ? I am the admin of this pc. We've tested it before I think and it did not work. I still think it is because there is no user file. Where can I found this file ? Where is it on the pc ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 10:38 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 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 '' at line 1 mysql quir - ; ERROR 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 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec) mysql select host,user,password from mysql.user; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql select host,user,password from mysql.test; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 8:35 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 15 rows in set (0.00 sec) mysql select host,user,password from mysql.user; +---+--+---+ | host | user | password |
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hey, Thanks for your help till so far but I'm still with my issue ! Is there any other support possible? FYI, I just reinstalled it with a higher version and the same issue is comming. I can not access mysql as root ! Please have a close look below : fujitsu:/home/yannick # mysql -u root--- # means I am as root on Linux. ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) fujitsu:/home/yannick # su yannick --- Here I move to a local user : yannick [EMAIL PROTECTED]:~ mysql -u root ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) [EMAIL PROTECTED]:~ --- Meaning I can not login with root --- The goal being to add a root password on mysql. as explained here : http://dev.mysql.com/doc/mysql/en/default-privileges.html However, [EMAIL PROTECTED]:~ mysql --- Now it works but with anonymous account. Low privilidges. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 4.1.12-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql This means that I just have an anonymous account. Best regards. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 6:25 PM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam hi Yannick, This is my ultimate help. See this url, you have all in it : http://dev.mysql.com/doc/mysql/en/unix-post-installation.html And all you want is here : http://www.mysql.com/search/?q=Installation If you're root, install mysql as root. At the end, change the mysql root password to a password different from the linux root. Then create other users and databases. Mathias Selon Yannick [EMAIL PROTECTED]: Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server ! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter mysql and to the things requested mainly because there is a security issue. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 4:03 PM À : [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, Sorry but you are not the administrator else you have the root password. So why search midday at 14 ? Just connect with root pass and see if mysql is here. Else mysql is like the other databases in /var/lib/mysql/mysql I really can't see how an administrator haven't the administrator password Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, How can I do this ? I am the admin of this pc. We've tested it before I think and it did not work. I still think it is because there is no user file. Where can I found this file ? Where is it on the pc ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 10:38 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 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 '' at line 1 mysql quir - ; ERROR 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 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec)
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Try : fujitsu:/home/yannick # mysql -u root -p Then ENTER fujitsu:/home/yannick # mysql -u root -h localhost -P 3306 -p Then ENTER Mathias Selon Yannick [EMAIL PROTECTED]: Hey, Thanks for your help till so far but I'm still with my issue ! Is there any other support possible? FYI, I just reinstalled it with a higher version and the same issue is comming. I can not access mysql as root ! Please have a close look below : fujitsu:/home/yannick # mysql -u root--- # means I am as root on Linux. ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) fujitsu:/home/yannick # su yannick --- Here I move to a local user : yannick [EMAIL PROTECTED]:~ mysql -u root ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) [EMAIL PROTECTED]:~ --- Meaning I can not login with root --- The goal being to add a root password on mysql. as explained here : http://dev.mysql.com/doc/mysql/en/default-privileges.html However, [EMAIL PROTECTED]:~ mysql --- Now it works but with anonymous account. Low privilidges. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 4.1.12-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql This means that I just have an anonymous account. Best regards. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 6:25 PM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam hi Yannick, This is my ultimate help. See this url, you have all in it : http://dev.mysql.com/doc/mysql/en/unix-post-installation.html And all you want is here : http://www.mysql.com/search/?q=Installation If you're root, install mysql as root. At the end, change the mysql root password to a password different from the linux root. Then create other users and databases. Mathias Selon Yannick [EMAIL PROTECTED]: Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server ! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter mysql and to the things requested mainly because there is a security issue. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 4:03 PM À : [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, Sorry but you are not the administrator else you have the root password. So why search midday at 14 ? Just connect with root pass and see if mysql is here. Else mysql is like the other databases in /var/lib/mysql/mysql I really can't see how an administrator haven't the administrator password Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, How can I do this ? I am the admin of this pc. We've tested it before I think and it did not work. I still think it is because there is no user file. Where can I found this file ? Where is it on the pc ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 10:38 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 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 '' at line 1 mysql quir - ; ERROR 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 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h'
server version: 3.23.55-max
I have PERL DBI/DBD installed. What SQL do I issue to obtain list of all tables with PK for a given database? What SQL do I issue to obtain the SQL source to (re)create all indexes for a given database? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ORDER by Question
I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER by Question
You can use: SELECT .. order by case substring(Name,1,4) when 'The ' then substring(Name,5,800) else Name end Un saludo Juan Pedro Jack Lauman wrote: I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Fwd: Re: ORDER by Question]
You can use: SELECT .. order by case substring(Name,1,4) when 'The ' then substring(Name,5,800) else Name end Un saludo Juan Pedro Jack Lauman wrote: I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER by Question
Jack Lauman wrote: SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. SELECT... ORDER BY Subscriber ASC, TRIM(LEADING The FROM Name) ASC; :: should work :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER by Question
Is The your only problem word? What about A or An and other words that are usually ignored when sorting things like book titles? I'd be surprised if there was any way to ignore specific words in an ORDER BY; I've been writing SQL for 20+ years and have never seen anything like that. I think what you'll need to do is modify your data so that words like The, A, An, etc. are at the end of the column values. I believe libraries traditionally cataloged books as illustrated in these examples: The Raven == Raven, The A Voyage to the Moon and a Trip Around It == Voyage to the Moon and a Trip Around It, An Another approach that *might* be easier - if you are using an appropriate version of MySQL - is to create a view that modifies the data for you. You'd need logic like this, which is pseudocode, NOT real SQL: create view view01 as select case when word(subscriber,1) = 'The' then substring(2nd through final words) concatenate 'The' when word(subscriber,1) = 'An' then substring(2nd through final words) concatenate 'An' else subscriber end, other-columns from ... where ... A view can't contain an ORDER BY so you'll have to put the order by in the query that uses the view but that's easy: select subscriber, ... from view01 order by subscriber Rhino - Original Message - From: Jack Lauman [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, June 26, 2005 2:06 PM Subject: ORDER by Question I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER by Question
I can see I'm going to have to review the manual pages on ORDER BY; sorry, I didn't realize that MySQL's ORDER BY allowed these sorts of expressions. I use DB2 most of the time and I was speaking on the assumption that MySQL's capabilities in the ORDER BY were very close to those of DB2, which is usually true. Not this time though! Rhino - Original Message - From: Hassan Schroeder [EMAIL PROTECTED] To: Jack Lauman [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Sunday, June 26, 2005 2:44 PM Subject: Re: ORDER by Question Jack Lauman wrote: SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. SELECT... ORDER BY Subscriber ASC, TRIM(LEADING The FROM Name) ASC; :: should work :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER by Question
Selon Jack Lauman [EMAIL PROTECTED]: I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi, this,among other answers, can be done : mysql select * from names; +--+ | name | +--+ | | | The | | | | The | | | +--+ 5 rows in set (0.02 sec) mysql select * from names order by replace(name,'The ',''); +--+ | name | +--+ | | | The | | | | | | The | +--+ 5 rows in set (0.00 sec) Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER by Question
My thanks to all that responded. I used Mathias's suggestion to solve the problem. You can see the results here. http://www.tasteofwhatcom.com/restaurants-tow/filter.jsp?field=cityvalue=Blaine Thanks again for your help. Jack Mathias wrote: Selon Jack Lauman [EMAIL PROTECTED]: I'm using a query similar to the following to get an ordered list. SELECT ORDER BY Subscriber ASC, Name ASC; How do I change this so that if the 'Name' field begins with The that the sort begins on the second word? In other words I'd like to be able to return the word The but have it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi, this,among other answers, can be done : mysql select * from names; +--+ | name | +--+ | | | The | | | | The | | | +--+ 5 rows in set (0.02 sec) mysql select * from names order by replace(name,'The ',''); +--+ | name | +--+ | | | The | | | | | | The | +--+ 5 rows in set (0.00 sec) Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1.x with php-4.3.x
I realise that this question may better be asked in a php list, but I already did that and got *no* answers. Does anyone know if there are some mysql dlls available for php-4.3.x ( I'm running 4.3.11) that are compiled against 4.1.x so I don't have to use the ugly hacks to get the old client to talk to the new server? I'm not really up to compiling things on Windows. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.x with php-4.3.x
Selon Daniel Kasak [EMAIL PROTECTED]: I realise that this question may better be asked in a php list, but I already did that and got *no* answers. Does anyone know if there are some mysql dlls available for php-4.3.x ( I'm running 4.3.11) that are compiled against 4.1.x so I don't have to use the ugly hacks to get the old client to talk to the new server? I'm not really up to compiling things on Windows. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] haven't try WAMP5 ? http://www.wampserver.com/en/ Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.x with php-4.3.x
Mathias wrote: haven't try WAMP5 ? http://www.wampserver.com/en/ I didn't know of this site, no. I'm new to Windows, at least on the server. Unfortunately they seem to be sticking with Apache-1.3, and I'd really rather go with Apache-2, since all my experience has been with it. I've read a lot about Apache-1.3 vs 2.0 and I'm fine with 2.0, especially considering all the work that's gone into Windows support. They've also made the interesting decision to move to PHP-5.0.x, whereas I'd prefer to stay with 4.3.x. I've been bitten hard by php upgrades before. I also don't really feel comfortable using such a new version of php on a production server ... especially when it's someone else's server. It would be simply lovely if I could just grab some mysql dlls ( offical if possible ), and then use them with the official MySQL PHP binaries. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.x with php-4.3.x
You have the choice between this : http://dev.mysql.com/doc/mysql/en/application-password-use.html and this : The optimal solution when migrating to MySQL 4.1+ from a previous version is to upgrade to PHP 5 (if you're not using it already) and rewrite any code accessing MySQL using the mysqli extension, which is more secure and provides a much better API. http://fr.php.net/mysql I hope someone else gives you an url for such dll. Mathias Selon Daniel Kasak [EMAIL PROTECTED]: Mathias wrote: haven't try WAMP5 ? http://www.wampserver.com/en/ I didn't know of this site, no. I'm new to Windows, at least on the server. Unfortunately they seem to be sticking with Apache-1.3, and I'd really rather go with Apache-2, since all my experience has been with it. I've read a lot about Apache-1.3 vs 2.0 and I'm fine with 2.0, especially considering all the work that's gone into Windows support. They've also made the interesting decision to move to PHP-5.0.x, whereas I'd prefer to stay with 4.3.x. I've been bitten hard by php upgrades before. I also don't really feel comfortable using such a new version of php on a production server ... especially when it's someone else's server. It would be simply lovely if I could just grab some mysql dlls ( offical if possible ), and then use them with the official MySQL PHP binaries. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.x with php-4.3.x
Mathias wrote: The optimal solution when migrating to MySQL 4.1+ from a previous version is to upgrade to PHP 5 (if you're not using it already) and rewrite any code accessing MySQL using the mysqli extension, which is more secure and provides a much better API. 'much better' API :) Perhaps. I would say, 'much better and constantly changing so as not to allow too much dust to settle'. Like I said, I've been bitten by PHP upgrades before. When you're on a good thing, change it! There are reasons other than my previously stated ones why I can't move to PHP-5. I'm relying on a number of php libraries that haven't been rewritten for PHP-5 yet. This is the decider for me - if it weren't for this, then yes I would *probably* rewrite for PHP-5 and then subscribe to the mailing lists to see what I can expect to break for PHP-6 :-P I think it's wiser to move back to MySQL-4.0.x until the client libraries are sorted out. While I'm at it, perhaps I should go all-out and move back to 3.x? Hang on while I roll my eyes towards the sky ... Thanks for your help anyway. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Calculate LONG/LAT from ZIP+4
A couple of months ago these was a discussion about ZIP code plotting on this list. Does anyone know how to calculate LONG/LAT coordinates from ZIP+4? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innodb Performance Measurement
Greetings, I am using MySQL 4.0.24 and all my tables use InnoDB as default engine. I was interested in finding out the performance of my Buffer space. How can i do it?. If I were to use MyISQM tables, I could have looked at the parameters Key_read_request key_reads to find out the hit rate but am not aware of how to do the same for Innodb hence any help would be appreciated. Cheers Manoj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calculate LONG/LAT from ZIP+4
Jack Lauman [EMAIL PROTECTED] writes: A couple of months ago these was a discussion about ZIP code plotting on this list. Does anyone know how to calculate LONG/LAT coordinates from ZIP+4? In the U.S., you can use the census data: http://www.census.gov/geo/www/gazetteer/places2k.html ScottG. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Max Connections of MySQL on Linux
Hi, everyone: I had done a test on Linux2.6. I got the max connections of 1079 when I complied the MySQL with static link. But I got the max connections of 7159 when I complied the MySQL with dynamic link. Why has so much difference between the static link and dynamic link? Has anybody know it? Best regards, leo huang 2005-06-27 _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character set on 4.1 and ujis support
Hi, Thank you very much for the reply. $dbh-do(SET character_set_results=ujis'); This works! Is there any way I can set this value on MySQL config file, so I don't need to change all my scripts? Right now my my.cnf looks like: [mysqld] default-character-set=ujis default-collation=ujis_japanese_ci [client] default-character-set=ujis [mysql] default-character-set=ujis What do your 'show' statements return when you execute them from the perl script? character_set_clientujis character_set_connectionlatin1 character_set_database ujis character_set_results latin1 character_set_serverujis character_set_systemutf8 character_sets_dir /usr/share/mysql/charsets/ Why does character_set_connection set back to latin1? I already set the ujis value in my.cnf, and if I connect using mysql client, this value is correctly set to ujis. How can I set character_set_connection so it defaults to ujis, no matter where is the connection coming from? --bk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calculate LONG/LAT from ZIP+4
You have to purchase a database. ZIP codes are not geographic, you can't calculate lat/lon from them. Here is one source: http://www.zipwise.com On Jun 26, 2005, at 6:43 PM, Scott Gifford wrote: Jack Lauman [EMAIL PROTECTED] writes: A couple of months ago these was a discussion about ZIP code plotting on this list. Does anyone know how to calculate LONG/LAT coordinates from ZIP+4? In the U.S., you can use the census data: http://www.census.gov/geo/www/gazetteer/places2k.html ScottG. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: 4.1.x with php-4.3.x
I recomend the PHP Home Edition Project at http://phphome.sourceforge.net/. It installs PHP, Apache and MySql, all configed to work together on a Windows machine. Version PHP Home 2.3.2 installs PHP v.4.3.3, Apache 2.0 and MySql 4.x (Note the latest version is 2.3.4 and includes PHP 5). I have been using 2.3.2 for several months on several machines and have had no problems at all. HTH, -- Will -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 6:25 PM To: mysql@lists.mysql.com Subject: 4.1.x with php-4.3.x I realise that this question may better be asked in a php list, but I already did that and got *no* answers. Does anyone know if there are some mysql dlls available for php-4.3.x ( I'm running 4.3.11) that are compiled against 4.1.x so I don't have to use the ugly hacks to get the old client to talk to the new server? I'm not really up to compiling things on Windows. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calculate LONG/LAT from ZIP+4
Brian Dunning [EMAIL PROTECTED] writes: You have to purchase a database. ZIP codes are not geographic, you can't calculate lat/lon from them. Here is one source: http://www.zipwise.com As I said below, you can download a free database from the US Census Bureau. Specifically, the data here: http://www.census.gov/tiger/tms/gazetteer/zcta5.txt contains ZIP codes and lat/lon information. I've not used that data, but I've used this file from 1999 with good results: http://www.census.gov/geo/www/tiger/zip1999.html Apparently that will no longer be updated, though, so the ZCTA data is probably better. ScottG. [...] On Jun 26, 2005, at 6:43 PM, Scott Gifford wrote: [...] In the U.S., you can use the census data: http://www.census.gov/geo/www/gazetteer/places2k.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calculate LONG/LAT from ZIP+4
Dude, that's more than 5 years old. On Jun 26, 2005, at 8:27 PM, Scott Gifford wrote: Brian Dunning [EMAIL PROTECTED] writes: You have to purchase a database. ZIP codes are not geographic, you can't calculate lat/lon from them. Here is one source: http://www.zipwise.com As I said below, you can download a free database from the US Census Bureau. Specifically, the data here: http://www.census.gov/tiger/tms/gazetteer/zcta5.txt contains ZIP codes and lat/lon information. I've not used that data, but I've used this file from 1999 with good results: http://www.census.gov/geo/www/tiger/zip1999.html Apparently that will no longer be updated, though, so the ZCTA data is probably better. ScottG. [...] On Jun 26, 2005, at 6:43 PM, Scott Gifford wrote: [...] In the U.S., you can use the census data: http://www.census.gov/geo/www/gazetteer/places2k.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]