It works mr. Vyas Thank you.
Here the step.
1. I put skip-grant-tables into my.cnf file
2. Restart the server with " net start/stop mysql" command
3. Add user and password for root with all privileges options to 'Y'
4. Issue FLUSH PRIVILEGES command
5. Edit my.cnf file again and marked skip-grant-tables.
6. Restart again the server.
7. Log in as root and it works.


Thank you.
Regards,
Anthon


On Mon, 24 Mar 2003 23:45:16 -0500 Bhavin Vyas <[EMAIL PROTECTED]> wrote:
restart the server with the --skip-grant-tables option and then add users.
----- Original Message -----
From: "Anthon Tagor" <[EMAIL PROTECTED]>
To: "Bhavin Vyas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 11:31 PM
Subject: Re: ERROR 1130



Mr. Vyas

But sir, i cannot log in to mysql server. How can i apply
GRANT command..?


On Mon, 24 Mar 2003 23:05:27 -0500
Bhavin Vyas <[EMAIL PROTECTED]> wrote:
>You don't have permissions. Look up GRANT on
>www.mysql.com.
>----- Original Message -----
>From: "Anthon Tagor" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, March 24, 2003 10:30 PM
>Subject: ERROR 1130
>
>
>> Hi all..
>> I am beginner in mysql. I had install mysql in winnt4.
>> I accidently delete all users in mysql database so i
>> cannot connect to mysql server, the message is :
>>
>> ERROR 1130: Host 'localhost' is not allowed to connect
>>to
>> this MySQL server
>>
>> Does anybody give solution to my problem
>>
>> regards
>> Anthon
>>


===========================================================================
=
>===============
>> Malas antri buat mendapatkan print-out tagihan telepon ?
>>Klik aja
>http://billinfo2.plasa.com
>> Gratis Perpanjangan dan Pendaftaran Nama Domain
>>http://idc.plasa.com
>khusus di bulan Maret !
>>


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



============================================================================
===============
Malas antri buat mendapatkan print-out tagihan telepon ? Klik aja
http://billinfo2.plasa.com
Gratis Perpanjangan dan Pendaftaran Nama Domain http://idc.plasa.com
khusus di bulan Maret !

============================================================================
===============

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




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



=========================================================================================== Malas antri buat mendapatkan print-out tagihan telepon ? Klik aja http://billinfo2.plasa.com Gratis Perpanjangan dan Pendaftaran Nama Domain http://idc.plasa.com khusus di bulan Maret ! ===========================================================================================

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



Reply via email to