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 | *Exxx5D8xxxxxxxxxxxxxxxxx37183xxx5EBADF2A | > > | localhost | yannick| | > > | localhost | xxxxxxx| *Exxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | > > +-----------+------+-------------------------------------------+ > > 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 > > > which > > > > > > username ? > > > > > > If needed, I can also give you a telnet session to check what is > > going > > > > > > wrong. I have already installed it 3 times and always the same > > > result... > > > > I > > > > > > don't beleive on an installation problem but on an > authentification > > > > issue. > > > > > > > > > > > > Thanks for you support. > > > > > > > > > > > > Yannick > > > > > > > > > > > > > > > > > > See details below: > > > > > > > > > > > > [EMAIL PROTECTED]:~> mysql > > > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > > > > Your MySQL connection id is 111 to server version: 4.0.15-Max > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > mysql> > > > > > > fujitsu:/home/yannick # mysql > > > > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > password: > > > > YES) > > > > > > fujitsu:/home/yannick # > > > > > > > > > > > > => If I have no access with root, I can not create any new > database > > > .... > > > > > > That is the problem. > > > > > > > > > > > > -----Message d'origine----- > > > > > > De : Nils Valentin [mailto:[EMAIL PROTECTED] > > > > > > Envoyé : Saturday, June 18, 2005 2:57 PM > > > > > > À : mysql@lists.mysql.com; [EMAIL PROTECTED] > > > > > > Cc : [EMAIL PROTECTED] > > > > > > Objet : Re: [SPAM] - Unable to install mysql - Bayesian Filter > > > detected > > > > > > spam > > > > > > > > > > > > > > > > > > Hi yannick, > > > > > > > > > > > > Not sure if you have found the problem yet, any way there are many > > > > > tutorials > > > > > > online which explain how to proberly setup user accounts. > > > > > > > > > > > > [EMAIL PROTECTED] > > > > > > [EMAIL PROTECTED] > > > > > > [EMAIL PROTECTED] > > > > > > yannick > > > > > > > > > > > > etc. are all separate users with different rights. So the > > combination > > > of > > > > > > username, hostname and password is to be thought of as a set. > > > > > > > > > > > > have alook at below links, which I hope help you kichstart and > > > > troubleshoot > > > > > > any issues you are having. > > > > > > > > > > > > http://www.devshed.com/c/b/MySQL/ > > > > > > http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/ > > > > > > > > > http://www.php-mysql-tutorial.com/mysql-tutorial/add-new-mysql-user.php > > > > > > > > > > > > > > > > > > I hope that you find this info useful. > > > > > > > > > > > > Best regards > > > > > > > > > > > > Nils Valentin > > > > > > Tokyo / Japan > > > > > > http;//www.be-known-online.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Tuesday 14 June 2005 06:58, Yannick wrote: > > > > > > > Kevin, > > > > > > > > > > > > > > In addition to that, the ZORUM database works because when I > stop > > > > mysql, > > > > > > > the following site stops working : > > > > > > > http://www.wxy.nl/zorum_3_5/ with the database ZORUM > > > > > > > > > > > > > > > > > > > > > Here PHPadmin doesn't give me any privilege to create anything : > > > > > > > http://www.wxy.nl/phpMyAdmin/ > > > > > > > > > > > > > > > > > > > > > I beleive I'm not to far from having it working ut I still have > > this > > > > > > > priviledge issue. > > > > > > > > > > > > > > BEst regards > > > > > > > > > > > > > > Yannick > > > > > > > > > > > > > > > > > > > > > -----Message d'origine----- > > > > > > > De : Yannick [mailto:[EMAIL PROTECTED] > > > > > > > Envoyé : Monday, June 13, 2005 11:54 PM > > > > > > > À : [EMAIL PROTECTED] > > > > > > > Cc : mysql@lists.mysql.com > > > > > > > Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter > > > > detected > > > > > > > spam > > > > > > > > > > > > > > > > > > > > > Kevin, > > > > > > > > > > > > > > Thanks for your answer. See below the results : > > > > > > > * I' really wondering if there is not any missing files. > > > > > > > * The mysql.soc file is complettly empty > > > > > > > * I can only access myssql when I am not in root. > > > > > > > * I can only see 1 database test when I know there is others > like > > > > zorum > > > > > > > which is working > > > > > > > * The command Grant doesn't work. > > > > > > > The result is that I can never access any database. > > > > > > > > > > > > > > I have been folowing the installatin process but it still does > not > > > > work. > > > > > > > Do you mind to have a look at the details below and advice on > > which > > > > files > > > > > > I > > > > > > > should have a look. > > > > > > > > > > > > > > Thanks in advance. > > > > > > > > > > > > > > Yannick > > > > > > > > > > > > > > > > > > > > > fujitsu:/etc # mysql -u root > > > > > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > > password: > > > > > YES) > > > > > > > fujitsu:/etc # su mysql > > > > > > > [EMAIL PROTECTED]:/etc> mysql > > > > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > > > > > Your MySQL connection id is 9 to server version: 4.0.15-Max > > > > > > > > > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > > > > > > > > > mysql> quit > > > > > > > Bye > > > > > > > [EMAIL PROTECTED]:/etc> mysql -u root > > > > > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > > password: > > > > NO) > > > > > > > [EMAIL PROTECTED]:/etc> mysql -u mysql > > > > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > > > > > Your MySQL connection id is 11 to server version: 4.0.15-Max > > > > > > > > > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > > > > > > > > > mysql> quit > > > > > > > Bye > > > > > > > [EMAIL PROTECTED]:/etc> su > > > > > > > Password: > > > > > > > fujitsu:/etc # mysql -u mysql > > > > > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > > password: > > > > > > YES) > > > > > > > fujitsu:/etc # mysql -u yannick > > > > > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > > > password: > > > > > > > YES) > > > > > > > fujitsu:/etc # su mysql > > > > > > > [EMAIL PROTECTED]:/etc> mysql -u yannick > > > > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > > > > > Your MySQL connection id is 14 to server version: 4.0.15-Max > > > > > > > > > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > > > > > > > > > mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('Yannick'); > > > > > > > ERROR 1044: Access denied for user: '@localhost' to database > > 'mysql' > > > > > > > mysql> SET PASSWORD FOR 'yannick' = PASSWORD('Yannick'); > > > > > > > ERROR 1133: Can't find any matching row in the user table > > > > > > > mysql> > > > > > > > mysql> show databases; > > > > > > > +----------+ > > > > > > > > > > > > > > | Database | > > > > > > > > > > > > > > +----------+ > > > > > > > > > > > > > > | test | > > > > > > > > > > > > > > +----------+ > > > > > > > 1 row in set (0.00 sec) > > > > > > > > > > > > > > mysql> > > > > > > > mysql> UPDATE mysql.user SET Password = PASSWORD('Yannick') > > > > > > > -> ; > > > > > > > ERROR 1044: Access denied for user: '@localhost' to database > > 'mysql' > > > > > > > mysql> > > > > > > > fujitsu:/bin # mysqlshow > > > > > > > mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using > > password: > > > > YES) > > > > > > > fujitsu:/bin # mysql -e "SELECT Host,Db,User FROM db" mysql > > > > > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > > password: > > > > > YES) > > > > > > > fujitsu:/bin # bin/mysqld_safe --user=mysql --log & > > > > > > > bash: bin/mysqld_safe: Aucun fichier ou répertoire de ce type > > > > > > > [1] 16599 > > > > > > > [1] Exit 127 bin/mysqld_safe --user=mysql --log > > > > > > > fujitsu:/bin # mysqladmin version > > > > > > > mysqladmin: connect to server at 'localhost' failed > > > > > > > error: 'Access denied for user: '[EMAIL PROTECTED]' (Using > password: > > > > YES)' > > > > > > > fujitsu:/bin # > > > > > > > mysql> SHOW DATABASES; > > > > > > > +----------+ > > > > > > > > > > > > > > | Database | > > > > > > > > > > > > > > +----------+ > > > > > > > > > > > > > > | test | > > > > > > > > > > > > > > +----------+ > > > > > > > 1 row in set (0.00 sec) > > > > > > > > > > > > > > mysql> GRANT ALL ON menagerie.* TO 'mysql'@'localhost'; > > > > > > > ERROR 1044: Access denied for user: '@localhost' to database > > > > 'menagerie' > > > > > > > mysql> GRANT ALL ON test TO 'mysql'@'localhost'; > > > > > > > ERROR 1046: No Database Selected > > > > > > > mysql> select test; > > > > > > > ERROR 1054: Unknown column 'test' in 'field list' > > > > > > > mysql> use test > > > > > > > Database changed > > > > > > > mysql> GRANT ALL ON test TO 'mysql'@'localhost'; > > > > > > > ERROR 1044: Access denied for user: '@localhost' to database > > 'test' > > > > > > > mysql> > > > > > > > > > > > > > > -----Message d'origine----- > > > > > > > De : Kevin Struckhoff [mailto:[EMAIL PROTECTED] > > > > > > > Envoyé : Monday, June 13, 2005 9:55 PM > > > > > > > À : [EMAIL PROTECTED] > > > > > > > Cc : mysql@lists.mysql.com > > > > > > > Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter > > > > detected > > > > > > > spam > > > > > > > > > > > > > > > > > > > > > Yannick, > > > > > > > > > > > > > > MySQL is very picky in how it handles security, or at least > > > different. > > > > > > > It has an extra layer of complexity, compared to say, the > Informix > > > > > > > RDBMS, which uses the OS user/password and grant statements. > With > > > that > > > > > > > being said, have you run the post-install steps to add users to > > the > > > > > > > mysql database grant tables user & db? Refer to section 2.9 of > the > > > > MySQL > > > > > > > Reference Manual, especially section 2.9.3. Good Luck. > > > > > > > > > > > > > > Kevin Struckhoff > > > > > > > Customer Analytics Mgr. > > > > > > > NewRoads West > > > > > > > > > > > > > > Office 818.253.3819 Fax 818.834.8843 > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: Yannick [mailto:[EMAIL PROTECTED] > > > > > > > Sent: Monday, June 13, 2005 11:42 AM > > > > > > > To: mysql@lists.mysql.com > > > > > > > Subject: [SPAM] - Unable to install mysql - Bayesian Filter > > detected > > > > > > > spam > > > > > > > > > > > > > > Hey guys, > > > > > > > > > > > > > > I am not able to install properly mysql. Please see below the > > > > technical > > > > > > > details or the bug report. > > > > > > > > > > > > > > The installation goes well until I try to add the root user : > > > > > > > > > > > > > > [EMAIL PROTECTED]:/usr/bin> mysqladmin -u root -h fujitsu password > > > xxxxx > > > > > > > mysqladmin: connect to server at 'fujitsu' failed > > > > > > > error: 'Host 'fujitsu.local' is not allowed to connect to this > > MySQL > > > > > > > server' > > > > > > > [EMAIL PROTECTED]:/usr/bin> mysqladmin -u root -h 192.168.234.2 > > > password > > > > > > > xxxxxx > > > > > > > mysqladmin: connect to server at '192.168.234.2' failed > > > > > > > error: 'Host '192.168.234.2' is not allowed to connect to this > > MySQL > > > > > > > server' > > > > > > > [EMAIL PROTECTED]:/usr/bin> > > > > > > > > > > > > > > > > > > > > > Continuously, and I've tried lots of combinations, he is failing > > to > > > > > > > connect > > > > > > > to the server. > > > > > > > > > > > > > > Please give me so hints for me to be able to install it. > > > > > > > > > > > > > > Best regards > > > > > > > > > > > > > > Yannick > > > > > > > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > SEND-PR: -*- send-pr -*- > > > > > > > SEND-PR: Lines starting with `SEND-PR' will be removed > > > automatically, > > > > as > > > > > > > SEND-PR: will all comments (text enclosed in `<' and `>'). > > > > > > > SEND-PR: > > > > > > > From: yannick > > > > > > > To: mysql@lists.mysql.com > > > > > > > Subject: [50 character or so descriptive subject here (for > > > reference)] > > > > > > > > > > > > > > >Description: > > > > > > > > > > > > > > <precise description of the problem (multiple lines)> > > > > > > > > > > > > > > >How-To-Repeat: > > > > > > > > > > > > > > <code/input/activities to reproduce the problem (multiple > > > > > > > lines)> > > > > > > > > > > > > > > >Fix: > > > > > > > > > > > > > > <how to correct or work around the problem, if known (multiple > > > > > > > lines)> > > > > > > > > > > > > > > >Submitter-Id: <submitter ID> > > > > > > > >Originator: Yannick Vauloup > > > > > > > >Organization: > > > > > > > > > > > > > > <organization of PR author (multiple lines)> > > > > > > > > > > > > > > >MySQL support: [none | licence | email support | extended email > > > > support > > > > > > > > > > > > > > ] > > > > > > > > > > > > > > >Synopsis: <synopsis of the problem (one line)> > > > > > > > >Severity: <[ non-critical | serious | critical ] (one > > > > > > > >line)> > > > > > > > >Priority: <[ low | medium | high ] (one line)> > > > > > > > >Category: mysql > > > > > > > >Class: <[ sw-bug | doc-bug | change-request | support > > > > > > > >] (one > > > > > > > > > > > > > > line)> > > > > > > > > > > > > > > >Release: mysql-4.0.15 (Source distribution) > > > > > > > >Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.15, for > > > suse-linux > > > > on > > > > > > > > > > > > > > i686 > > > > > > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult > > AB > > > > > > > This software comes with ABSOLUTELY NO WARRANTY. This is free > > > > software, > > > > > > > and you are welcome to modify and redistribute it under the GPL > > > > license > > > > > > > > > > > > > > Server version 4.0.15-Max > > > > > > > Protocol version 10 > > > > > > > Connection Localhost via UNIX socket > > > > > > > UNIX socket /var/lib/mysql/mysql.sock > > > > > > > Uptime: 5 min 8 sec > > > > > > > > > > > > > > Threads: 1 Questions: 14 Slow queries: 0 Opens: 6 Flush > > tables: > > > 1 > > > > > > > Open > > > > > > > tables: 0 Queries per second avg: 0.045 > > > > > > > > > > > > > > >C compiler: gcc (GCC) 3.3.1 (SuSE Linux) > > > > > > > >C++ compiler: g++ (GCC) 3.3.1 (SuSE Linux) > > > > > > > >Environment: > > > > > > > > > > > > > > <machine, os, target, libraries (multiple lines)> > > > > > > > System: Linux fujitsu 2.4.21-286-default #1 Sat Apr 2 08:57:10 > UTC > > > > 2005 > > > > > > > i686 > > > > > > > i686 i386 GNU/Linux > > > > > > > Architecture: i686 > > > > > > > > > > > > > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake > > /usr/bin/gcc > > > > > > > /usr/bin/cc > > > > > > > GCC: Lecture des spécification à partir de > > > > > > > /usr/lib/gcc-lib/i586-suse-linux/3.3.1/specs > > > > > > > Configuré avec: > > > > > > > ../configure --enable-threads=posix --prefix=/usr > > > > > > > --with-local-prefix=/usr/l > > > > > > > > > > > > ocal --infodir=/usr/share/info --mandir=/usr/share/man --libdir=/usr/lib > > > > > > > --e > > > > > > > nable-languages=c,c++,f77,objc,java,ada --disable-checking > > > > > > > --enable-libgcj - > > > > > > > -with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib > > > > > > > --with-system-zli > > > > > > > b --enable-shared --enable-__cxa_atexit i586-suse-linux > > > > > > > Modèle de thread: posix > > > > > > > version gcc 3.3.1 (SuSE Linux) > > > > > > > Compilation info: CC='gcc' > > > > > > > > > CFLAGS='-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -DPIC -fPIC' > > > > > > > CXX='g++' > > > > > > > FLAGS='-O2 -march=i586 -mcpu=i686 -fmessage-length=0 > > > > > > > -felide-constructor > > > > > > > s -fno-exceptions > > > > > > > -fno-rtti -fPIC -DPIC' LDFLAGS='' > > > > > > > ASFLAGS='' > > > > > > > LIBC: > > > > > > > -rwxr-xr-x 1 root root 1469811 2003-09-24 01:05 > > > > > > > /lib/libc.so.6 > > > > > > > -rw-r--r-- 1 root root 13553180 2003-09-23 18:04 > > > > > > > /usr/lib/libc.a > > > > > > > -rw-r--r-- 1 root root 204 2003-09-23 18:04 > > > > > > > /usr/lib/libc.so > > > > > > > lrwxrwxrwx 1 root root 20 2005-02-22 14:05 > > > > > > > /usr/lib/libc-client.so -> libc-client.so.2002d > > > > > > > -rwxr-xr-x 1 root root 770436 2003-09-23 20:29 > > > > > > > /usr/lib/libc-client.so.2002d > > > > > > > Configure command: ./configure '--disable-shared' > > > > > > > '--enable-thread-safe-client' '--with-mysqld-ldflags=-static' > > > > > > > '--with-client-ldflags=-static' '--without-berkeley-db' > > > > > > > '--with-extra-tools' > > > > > > > '--without-innodb' '--enable-assembler' '--enable-large-files' > > > > > > > '--infodir=/usr/share/info' '--libdir=/usr/lib' > > > > '--libexecdir=/usr/sbin' > > > > > > > '--localstatedir=/var/lib/mysql' '--mandir=/usr/share/man' > > > > > > > '--prefix=/usr' > > > > > > > '--sysconfdir=/etc' '--with-mysqld-user=mysql' '--without-debug' > > > > > > > '--datadir=/usr/share' '--includedir=/usr/include' > > > > > > > '--with-extra-charsets=complex' > > > > > > > '--with-unix-socket-path=/var/lib/mysql/mysql.sock' > > '--with-libwrap' > > > > > > > > 'CFLAGS=-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -DPIC -fPIC' > > > > > > > 'CXXFLAGS=-O2 -march=i586 -mcpu=i686 -fmessage-length=0 > > > > > > > -felide-construc > > > > > > > tors -fno-exceptions > > > > > > > -fno-rtti -fPIC -DPIC' > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > MySQL General Mailing List > > > > > > > For list archives: http://lists.mysql.com/mysql > > > > > > > To unsubscribe: > > > > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > > > > > > kind regards > > > > > > > > > > > > Nils Valentin > > > > > > Tokyo/Japan > > > > > > > > > > > > http://www.be-known-online.com/mysql/ > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > MySQL General Mailing List > > > > > > For list archives: http://lists.mysql.com/mysql > > > > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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] > > > > > > > > > > > > > > > > > > > > > > > > > > Hope that helps > > > > :o) > > > > Mathias > > > > > > > > > > > > > > > > > > > > Hope that helps > > > :o) > > > Mathias > > > > > > > > > > > > > > Hope that helps > > :o) > > Mathias > > > > > > > > Hope that helps > :o) > Mathias > > 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]