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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]