In MySql execute the GRANT command to give the necessary permissions to
user@nthost, something like as follows (change the command per your needs,
for different options, look up documentation on mysql.com )
GRANT all on *.* to 'username'@'hostname' identified by 'password'.
You can use IP too,
* Mysql, after reading the query, decides wether using an index would be
better than just a table row scan. Hence, it's MySql's decision
* You can force MySql to use indexes using the 'using index' option with the
select query.(MySql 'might' still reject the force, not sure of the
Yes, regarding the $PATH my bad... putting it in /usr/lib should have
resolved it(since it's generally in LD_LIBRARY_PATH). Besides that, as Ritu
suggested, it should be in LD_LIBRARY_PATH variable in the environment not
$PATH. Not familiar with /etc/ld.conf, that might work too.
Bhavin.
-
No, there is no way to trigger an insert automatically when you are doing a
LOAD DATA (bulk load). You will need another flat file with the appropriate
info and load that in as well...just as you have thought of.
- Original Message -
From: Dion Wickander [EMAIL PROTECTED]
To: MySQL Help
or aalternatively, u can also do a echo $PATH and put the library in one of
those path. eg: /usr/lib or someplave OR
do PATH=$PATH:/usr/lib/mysql, if it work, put that command in your
'.profile' so that it loads every time you log in.
- Original Message -
From: Chris Knipe [EMAIL