[EMAIL PROTECTED] wrote:
> 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 ' ';
User 'root'@'localhost' by default has all privileges.
>
> i got the result as:
>
> Access denied for user: @'localhost' to database 'genome_db'
>
> dont know what to do:( confused!!!!
>
You are connected as anonymous user. Use -u option of mysql client to specify username
and connect to the MySQL server as a root:
mysql -uroot
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
