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]