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
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
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: [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
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
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
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
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
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
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
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
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
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
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
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 rpertoire de ce type
[1] 16599
[1] Exit 127bin/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
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 127bin/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 x
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
xx
mysqladmin: connect to server at '192.168.234.2' failed
error: 'Host '192.168.234.2' is not allowed to connect to this MySQL
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
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 127bin/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
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 x 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 xx 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 version10 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-x1 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 lrwxrwxrwx1 root root 20 2005-02-22 14:05 /usr/lib/libc-client.so - libc-client.so.2002d -rwxr-xr-x1 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
