Stored procedure permission error

[Leandro Chapuis]

Hi all,

I'm receiving an error when trying to invoke a procedure from a 
[EMAIL PROTECTED] which is not the definer. I created the procedure with the 
statement 'SQL SECURITY INVOKER' but is still not working. Does anyone 
know why? The MySQL version is 5.0.36.


Both users [EMAIL PROTECTED] and [EMAIL PROTECTED] have all privs on the database and 
also execute privs on the procedure.


Thanks in advance.

Regards,


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with character set and connection collation

[Leandro Chapuis]

Hi Sulo,

Open the file you are importing as it is probably that it contains 
references of another character set in the table creation. If so replace 
that character set for '' or 'utf8'.


I hope it helps,

Leandro


sulochan acharya wrote:

Hello all,
here is my problem:

I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:

mysql charset: utf-8 unicode

when i make a new database:
mysql connection collation is utf8-general-ci
and my new database collation is also utf-general-ci

i import tables into this database using mysql command : source /path to
file

when i browse the tables in this database i dont see nepali world instead it
seems like mysql cant read the characters;

please help!!


best,
sulo

  


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]