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 met

Re: Using posix users

rk 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]

Using posix users

hanges 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.co

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 key

Re: Double indexes on one field

d 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

Double indexes on one field

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/[

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

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

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,

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

e_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

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 passwo

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 ; o

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

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

o 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 m

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

* 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 fu

Unable to install mysql

' 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-

Re: Bulk addition of users and databases

#x27;.$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 permis

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 contai

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

Re: Mysql and errno 13 on RedHat

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

Mysql and errno 13 on RedHat

ay 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: 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 w

DBI and Mysql error 2006

#x27;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

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 database

Lots of databases...how wrong is it?

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]

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 Gener

socks

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