Robert,
`mysqladmin ping` will print "mysqld is alive" if the server is running,
or error message in any other case.
Peter
On Wed, 20 Feb 2002, Li, Robert wrote:
> Hi, all mysql team
>
> As we know, use safe_mysqld or mysql.server
> we can startup Mysql instance.
> But how can i know when all
In this case you have to omit GROUP BY from your query.
Peter
On Tue, 19 Feb 2002, CreaCtion wrote:
> At 19.02.2002 10:20, you wrote:
> >What would you expect the database to return
> Thanks to all so far,
> The query should give the smallest price MIN(preis) and the according "lfd"
> num
Philip,
you should explicitly specify host/password in the GRANT statement, like
this:
GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
This way the user will only granted access from the specified host, you
don't need to manually INSERT into the user table.
Oliver,
>
> select min(preis),lfd from database where marke='marke'
> and typ not like 'R%'
> and typ not like 'X%'
> and typ not like 'C%'
> group by preis
>
> this doesn´t bring the expected pair "preis / lfd" but all available
> "preis/lfd" grouped ascending.
>
you're grouping by the same
The ENCRYPT() function uses one-way encryption algorithm, which means the
resulting hash cannot be "decrypted". If you want to compare a not crypted
value to a crypted one, you should also use ENCRYPT(), and compare the
hashes.
HTH,
Peter
On 18 Feb 2002, Amit Dilip Lonkar wrote:
>
> Hi
>
> C
Joe,
you can find it here:
http://arglist.com/regex/
Peter
On Fri, 15 Feb 2002, Joe Polanik wrote:
> According to the online manual the regex man page contributed by Henry
> Spencer is included in the source distribution of MySQL. I'm hesitant to
> download
> and install a source distributio
Put quotes around the hostname:
grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net'
identified by 'X';
Peter
On Thu, 7 Feb 2002, Paul Faber wrote:
> Not sure if thius is supposed to go here but my version of MySQL
>
> mysql> status;
> --
> mysql Ver 11.15 Distrib 3.2
Put quotes around the hostname:
grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net'
identified by 'X';
Peter
On Thu, 7 Feb 2002, Paul Faber wrote:
> Not sure if thius is supposed to go here but my version of MySQL
>
> mysql> status;
> --
> mysql Ver 11.15 Distrib 3.2