Hello Ardani,
an INSERT works only on one selected table...
You must insert the values separately for each table...
where is the problem?
Christian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
> The fact that he has logged on should not require him to specify
> password again.
This fact means: when a user is logged in, he is allowed to use the
mysql-server:
use this one:( every logged -on -user on localhost has all rights to
every base and table without pw)
GRANT USAGE ON *.*
TO "
Hello my friend,
shure its possible!
additional you can insert into the user table of mysql the encryptet
Password-Hash of your local
etc.shadow-Phile to verify the correct Password and authenticate the the
user.
Hope it helps
Christian
sachin shetty wrote:
> Hello
>
> Is it possible to auth
Hello John,
are you sure, that the user "test" with password "test1" exist in your
Grant-Tables and has rights to
INSERT ??? [;-)]
Gruß
Christian
john zie wrote:
>
>
>
> Mysql:
>
> We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It
> works fine, however when we test a
Hello Selva,
the best way to start the server is:
1. change to your mySQL-directory
and then:
2. ./bin/safe_mysqld &
starts the damon via script in the background (&)
Alles wird gut! [;-)]
Christian
Sorry ---
How about this WITHOUT SELECT:
---
INSERT INTO Table VALUES(Lamer_ID, ENCRYPT("you are
lame...!","sa"));
---
uses the unix-crypt()-function, means, i
How about this:
---
INSERT INTO Table VALUES(Lamer_ID, SELECT ENCRYPT("you are
lame...!","sa"));
---
uses the unix-crypt()-function, means, its a One-Way-Crypt!
sa must be a 2-char lo
hello kynn,
you have to :
first you must UNDERSTAND the USER-table from mysql-DB on your box.
from that point you are able to insert directly values into USERS like
values into any other MySQL-Table:
example:
INSERT INTO USER VALUES
('localhost','Testuser','PASSWORD('little
lamer'),'Y','Y',