hi,
I am having problems with mysql.
1. I downloaded mysql on to my system.
2.installed it
3. ran the server using the command prompt
C:\mysql\bin\mysqld --console
it gave me the results that i could start using the service.
4. i started mysql on another command prompt.
what i am trying to do is i have to enter a huge genome sequence into a field.
In order to do tht i have to change the global and session variables in mysql.
i can change the session variables but i am not able to change the global
variables.
I gave the command:
set global max_allowed_packet=400000000;
it said:
Access denied. You need the SUPER privilege for this operation.
Then i created a database genome_db .
then at the command promp i typed
>grant all privileges on genome_db.* to root@"localhost" identified by ' ';
i got the result as:
Access denied for user: @'localhost' to database 'genome_db'
dont know what to do:( confused!!!!
plzzz help!!!!
Liz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
