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 ajahttp://billinfo2.plasa.comGratis Perpanjangan dan Pendaftaran Nama Domain http://idc.plasa.comkhusus 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]