Besoin d'aide urgent
Je viens au pres de vous solliciter une aide en ce qui concerne le demarrage du serveur mysql. J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-win Je constate qu'il n'y a pas un racourcie pour la source graphique. J'ai tente de demarrer le server en ligne de commande en me mettant sur: C:\mysql\bin puis en entrant la commande suivante: mysqld-nt.exe mais celui ci ne se lance pas. Existe t'il une autre maniere d'aborder la situation??? Je vous remercie d'avance pour avoir une solution a ce probleme et j'aimerai savoir s'il existe un mode graphique pour cette version de mysql???. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using posix users
Hi, I have a computer lab where students learn bioinformatics. The courses include a crash course on database and we want to use MySQL since it is a popular engine for bioinformatics. No one like to remember multiple passwords and since want each student to have its own MySQL user and database I wanted to make a mapping between the database users and the posix users. Unfortunately I can't find how to do that. Let's to be a bit more explicit on what I want to do, I would like the user foo in MySQL to be authenticated though pam on the posix user foo. That way if foo changes his password with passwd, he will automatically change his MySQL password. This is what happens with Postgresql with the shell command createuser foo Is it possible to do the same with MySQL? -- Yannick Gingras -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using posix users
Dan Nelson [EMAIL PROTECTED] writes: Is it possible to do the same with MySQL? Not yet, Argh! but it being looked at: http://bugs.mysql.com/bug.php?id=4703 http://forge.mysql.com/wiki/PluggableAuthenticationSupport Very good! Keep up the good work guys. I guess our students will have to learn that in real life you need to remember at lest 23 passwords... ; ) -- Yannick Gingras -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Double indexes on one field
Hi all, Using PhpMyAdmin, I seldom get the warning message: PRIMARY and INDEX keys should not both be set for column `ID` I understand its meaning, but I was wondering to what extent having a field indexed AND being a primary key might slow down/speed up my queries. Is that gonna take twice the time if I am searching on the ID field, just because there are two indexes? I'd like to have a rough idea of how serioulsy I need to avoid these. Thank you, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Double indexes on one field
Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit : Using PhpMyAdmin, I seldom get the warning message: PRIMARY and INDEX keys should not both be set for column `ID` I understand its meaning, but I was wondering to what extent having a field indexed AND being a primary key might slow down/speed up my queries. Is that gonna take twice the time if I am searching on the ID field, just because there are two indexes? I'd like to have a rough idea of how serioulsy I need to avoid these. Creating a PRIMARY KEY will automatically create an index. Why would you create a second index for that field? I'm asking myself the same question. I am working on someone else's database. Thanks both, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Double indexes on one field
Le lundi 03 octobre 2005 à 16:24 +0200, Bastian Balthazar Bux a écrit : Yannick Warnier wrote: Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit : Using PhpMyAdmin, I seldom get the warning message: PRIMARY and INDEX keys should not both be set for column `ID` I understand its meaning, but I was wondering to what extent having a field indexed AND being a primary key might slow down/speed up my queries. Is that gonna take twice the time if I am searching on the ID field, just because there are two indexes? I'd like to have a rough idea of how serioulsy I need to avoid these. Creating a PRIMARY KEY will automatically create an index. Why would you create a second index for that field? I'm asking myself the same question. I am working on someone else's database. Thanks both, Yannick Is it a multi-field index ? some versions of phpmyadmin show that messages also if only one field is duplicated. example: CREATE TABLE `tab_sint` ( `id_cns` tinyint(3) unsigned NOT NULL default '0', `anno_dep` smallint(4) unsigned zerofill NOT NULL default '', `data_dep` smallint(4) unsigned zerofill NOT NULL default '', `particolare` mediumint(8) unsigned NOT NULL default '0', `generale` mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY `idx_cns_gen_anno` (`anno_dep`,`id_cns`,`generale`,`particolare`), UNIQUE KEY `idx_cns_par_anno` (`id_cns`,`anno_dep`,`tipo`,`particolare`,`bis`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=87189031 ; This schema issue the warning on 'id_cns' but really make sense having 2 indices here since they serves different kind of querys and constraints. No, no, it's just a dumb double index :-) I am pretty sure it is completely useless. Actually I have already removed it. Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql quir - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec) mysql select host,user,password from mysql.user; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql select host,user,password from mysql.test; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 8:35 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 15 rows in set (0.00 sec) mysql select host,user,password from mysql.user; +---+--+---+ | host | user | password | +---+--+---+ | localhost | root | *Exxx5D8x37183xxx5EBADF2A | | localhost | yannick| | | localhost | xxx| *Ex | +---+--+---+ 1 row in set (0.00 sec) have you tried an update ? mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass') WHERE User='yannick' AND Host='localhost'; mysql FLUSH PRIVILEGES; Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, I would love to do it but this is the answer : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test'); ERROR 1133: Can't find any matching row in the user table mysql I also succeeded to enter with mysqladministrator. (Without password !) The strange thing is that when I go to user admin he tells me: could not retrieve user privilege info . It looks like there is not file for username and passwords. If I try to add a user, the program shut. Where should I check if there is such user file file ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 12:36 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Since you can connect as yannick without password, just set it after login : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass'); see http://dev.mysql.com/doc/mysql/en/set-password.html for more details. I advice to set it to another password than your yannick linux one. Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, Did what you asked : [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 134 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works only if I put NO password. If I put the password of yannick it doesn't work. But here as well, I must confuse the username yannick in mysql and the user yannick in linux. I can not ask the administrator what password he put because I am the administrator of this computer !! :)) Also, I have just installed MysqlAdministrator and here as well, I
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
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
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
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
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
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
Unable to install mysql
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-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
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: Bulk addition of users and databases
Le mar 07/09/2004 à 11:24, Rob Keeling a écrit : Having googled extensively, I can`t seem to find a way to do the following. I have a mysql table, with around 1200 usernames in it. What I want to do is programmatically add each user, and create a database of the same name that that user has access to. (This is for a school web server, we want to allow students to try out mysql querys with phpmyadm etc) Any suggestions? I recently tried Perl::DBI to create a lot of databases and found it crashes after 100 databases because it doesn't close properly its handler. So I would suggest not to do that. Now I think the best way (not the cleanest) is to use a PHP script with 'exec' command to call: mysqladmin -u user --password=pass create tablename I've done that in Perl so if you're more comfortable with Perl, go ahead. Also, I have a shell script creating databases by calling mysqladmin, but it's based on a file containing all databases names (which you need to output from mysql client first). The best thing I would suggest is to do it in PHP or Perl in a loop fetching all students name. You will also need to give the students sufficient permissions on their own database so you will have to create 1200 mysql users, otherwise they will all have access to the other's databases. With PHP this would be something like: $admin = 'adminuser'; # this is the username allowed to create databases $pass = 'pass'; # this is his password $query = SELECT username from user; $result = mysql_query($query); foreach($row = mysql_fetch_array($result)){ exec('mysqladmin -u '.$admin.' --password='.$pass.' create '.$row['username']) || die Could not create database .$row['username'].: .mysql_last_error(); exec(...something that will give the right to that user on that database...) || die Could not grant permissions to .$row['username'].: .mysql_last_error(); } Cheers, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Forcing case sensitivity in queries
Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHERE field = 'd'; I get all records containing 'd' or 'D'. How do I enable case-sensitivity? Thanks, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Forcing case sensitivity in queries
Le dim 05/09/2004 à 00:14, Yannick Warnier a écrit : Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHERE field = 'd'; I get all records containing 'd' or 'D'. How do I enable case-sensitivity? OK sorry, I found that using 'binary' solves the problem. SELECT * FROM mytable WHERE field = binary 'd'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql and errno 13 on RedHat
Hi there, I need to install a database on a RedHat system. Although I'm pretty at ease with Debian, I feel a little unconfortable and cannot find why I get an Error: errno 13 (Permission Denied) when I try to create a new database. Is there some place to look at first? I cannot find any way to do this easily. There is no strace installed on the system (nor any possibility to do so easily). Any idea? Thanks, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql and errno 13 on RedHat
Le mar 31/08/2004 à 16:21, Dobromir Velev a écrit : Hi, Make sure that the mysql user have permissions to write into the folder /var/lib/mysql (or whatever your data folder is) . Thanks Eric and Dobromir. This was a problem of permissions on /var/lib/mysql indeed. Although it did not work immediatly after a change, I saw (how awful) that the mysql version was a 3.23 or something and replaced by the recommended version 4. Now it all works perfectly (although mysqld is now divided in ten different processes, but I don't know why and I don't mind as long as it works). Thanks, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DBI and Mysql error 2006
Le ven 27/08/2004 à 00:37, Yannick Warnier a écrit : Hi there, I'm having a problem with MySQL within a Perl::DBI usage. I've turned it upside-down and cannot find what it's related to. My Perl script creates multiple databases and populates them with tables. The problem appears when creating the second database (in the foreach statement): # # Get a database connection to use to create new databases # my $tempDSN = 'DBI:mysql:database=test:host=localhost'; our $tempDBH =DBI-connect($tempDSN,$login,$password) || die Could not connect to test database: $! ; # # Go through a list of databases and create them one by one # foreach my $db ( keys(%$list_of_DBs) ) { # # Create a DB with the handler we have # my $create = $tempDBH-func('createdb',$db,'admin') ||die Could not create database $db : $!; # # Connect to the newly created database # my $dbDSN = DBI:mysql:database=$db:host=localhost; my $dbDBH = DBI-connect($dbDSN,$login,$password) || die Could not connect to database $db : $!; # # Create a set of tables in this database # foreach my $table ( keys(%$list_of_tables) ) { $dbDBH-do(CREATE TABLE ... ); } # # Disconnect from the newly created database # $dbDBH-disconnect() || die ...; } # # Disconnect from the temporary database connection # $tempDBH-disconnect(); So the first database is created with all it's table, but when I get to the second, I get this error: Could not create database ... And when asking more detail with $DBI::errstr: ERROR: 2006 'MySQL server has gone away' I've really searched this down in my doc, on the net, and with DBI-trace(5) but the only thing I figured out is that somehow the temporary database connection is shut down by something without asking. But I'm not sure... How could I? Anyway, if somebody has any idea what this might come from or has come to something similar in the past, please give me a hint. I've taken another path and decided to execute mysqladmin to create my databases. I find it awful but it works, so... Thanks anyway, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DBI and Mysql error 2006
Hi there, I'm having a problem with MySQL within a Perl::DBI usage. I've turned it upside-down and cannot find what it's related to. My Perl script creates multiple databases and populates them with tables. The problem appears when creating the second database (in the foreach statement): # # Get a database connection to use to create new databases # my $tempDSN = 'DBI:mysql:database=test:host=localhost'; our $tempDBH =DBI-connect($tempDSN,$login,$password) || die Could not connect to test database: $! ; # # Go through a list of databases and create them one by one # foreach my $db ( keys(%$list_of_DBs) ) { # # Create a DB with the handler we have # my $create = $tempDBH-func('createdb',$db,'admin') ||die Could not create database $db : $!; # # Connect to the newly created database # my $dbDSN = DBI:mysql:database=$db:host=localhost; my $dbDBH = DBI-connect($dbDSN,$login,$password) || die Could not connect to database $db : $!; # # Create a set of tables in this database # foreach my $table ( keys(%$list_of_tables) ) { $dbDBH-do(CREATE TABLE ... ); } # # Disconnect from the newly created database # $dbDBH-disconnect() || die ...; } # # Disconnect from the temporary database connection # $tempDBH-disconnect(); So the first database is created with all it's table, but when I get to the second, I get this error: Could not create database ... And when asking more detail with $DBI::errstr: ERROR: 2006 'MySQL server has gone away' I've really searched this down in my doc, on the net, and with DBI-trace(5) but the only thing I figured out is that somehow the temporary database connection is shut down by something without asking. But I'm not sure... How could I? Anyway, if somebody has any idea what this might come from or has come to something similar in the past, please give me a hint. Thanks, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lots of databases...how wrong is it?
Hi there, I am using a mysql server at the moment which contains 2800 different databases. phpmyadmin is really slow listing them, but that's not really a big deal. The thing is my view on this set of databases (every database contains about 20 tables) is it is really bad, because actually there's no real need of so many databases. In fact, every batch of 20 databases could be one database only, with more tables (but no the total number of tables by batch of 20 databases as it is now). Now my problem is to justify this is a wrong technique. So I have some questions about it which, I think, could help in determining whether the server would hugely benefit from such a change or not... Here are the questions. I hope all of you can answer them all... - how many databases can a MySQL server 3.23 (let's say on a good pentium 3, 512MB RAM) handle? or where to find such info...? - how wrong is creating 20 databases (total 400 tables) when you know you could create just one (total around 200 tables)? - what does MySQL handle better? Databases or tables? - could a slowdown problem causing me to have a show databases query answered in 42.50 seconds (more often being 0.02 sec) be bound to too many databases? Any answer is welcome as I am not quite used to MySQL benchmarking or improvement... Thanks, Yannick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lots of databases...how wrong is it?
Le sam 29/05/2004 à 15:28, Ryan Fox a écrit : It depends on the table type, but I'll gear my answers toward myisam. MySQL uses the os's filesystem calls to list directories. Slowdowns / limits to the number of myisam databases will be caused by the filesystem. - how many databases can a MySQL server 3.23 (let's say on a good pentium 3, 512MB RAM) handle? or where to find such info... Depends on the platform/file system. Unix RedHat (don't know version) - how wrong is creating 20 databases (total 400 tables) when you know you could create just one (total around 200 tables)? For linux ext2, I'd rather have 20db 20table than 1db 200 table. Neither approach practical limits tho. Well... hopefully it doesn't. - what does MySQL handle better? Databases or tables? Depends on filesystem/table type. For myisam, databases. Each database creates 1 directory entry, each table creates 3 file entries. Ext2 / MyIsam, so I guess that makes 2800 directories with 60 files each or something similar - could a slowdown problem causing me to have a show databases query answered in 42.50 seconds (more often being 0.02 sec) be bound to too many databases? That's it. :) Ryan Fox Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql multi-thread
Bonjour, je viens d'installer mysql-4.0.3 , or je m'apercois que pour chaque nouvelle connection, un nouveau processus aparait dans ma liste ps, est-il possible de configurer mysql pour qu'il utilise des threads plutot que des fork ? Cordialement Yannick GUENET -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
socks
Hi, when I visit my php pages they give an error: Warning: MySQL connection Failed: Can't connect to local MySQL server trhough socket /var/lib/mysql/mysql.sock (111) in /var/www/html/index.php the file 'mysql.sock is in the right dir (/var/lib/mysql/) Someone told me that Apache don't get access to the mysql db, if that is the problem, how can I solve it?? conf: Linux :RedHat 7.1 , apache webserver, mysql server thanks in advance Yannick _ Meld je aan bij de grootste e-mailservice ter wereld met MSN Hotmail: http://www.hotmail.com/nl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php