***BOGO*** Re: Anybody know how to use mysql_secure_installation on remote host?

["Moon's Father" <yueliangdao0608@xxxxxxxxx>]

Could you tell me what is exact step?
Since there are no other options for me to choice.
Here is my test.
[root@localhost ~]# /usr/local/mysql-maria/bin/mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Notice: It can connect mysql with default port and  socket .

Enter current password for root (enter for none):
OK, successfully used password, moving on...


On Tue, May 27, 2008 at 4:29 PM, Krishna Chandra Prajapati <
prajapatikc@xxxxxxxxx> wrote:

> Connect to mysql using the port (3307,3308)
> Manually execute all the step performed by mysql_secure_installation.
>
>
> On Tue, May 27, 2008 at 1:19 PM, Moon's Father <yueliangdao0608@xxxxxxxxx>
> wrote:
>
>> Thanks for your reply.
>> But I want to know  how to apply the security to the  other instance
>> without default port ?
>> i.e.3307,3308?
>>
>>
>> On Tue, May 27, 2008 at 3:02 PM, Krishna Chandra Prajapati <
>> prajapatikc@xxxxxxxxx> wrote:
>>
>>> Hi,
>>>
>>> mysql_secure_installation is a script for making new mysql installation
>>> more secured.
>>> It should be executed after every new mysql installation.
>>>
>>> This tool can remove the user password for remote root users. Only the
>>> localhost user should have the root preveliges
>>>
>>>
>>> On Tue, May 27, 2008 at 11:57 AM, Moon's Father <
>>> yueliangdao0608@xxxxxxxxx> wrote:
>>>
>>>> This tool gives us to improve the security of the new mysql
>>>> installation.
>>>> But I found it can only  effect default port and default database.
>>>>
>>>> How could I do when I want to configurate the other instance with this
>>>> tool?
>>>>
>>>> Here is its introduction.
>>>> http://dev.mysql.com/doc/refman/5.1/en/mysql-secure-installation.html
>>>>
>>>> --
>>>> I'm a mysql DBA in china.
>>>> More about me just visit here:
>>>> http://yueliangdao0608.cublog.cn
>>>>
>>>
>>>
>>>
>>> --
>>> Krishna Chandra Prajapati
>>> MySQL DBA,
>>> Ed Ventures e-Learning Pvt.Ltd.
>>> 1-8-303/48/15, Sindhi Colony
>>> P.G.Road, Secunderabad.
>>> Pin Code: 500003
>>> Office Number: 040-66489771
>>> Mob: 9912924044
>>> URL: ed-ventures-online.com
>>> Email-id: prajapatikc@xxxxxxxxx
>>
>>
>>
>>
>> --
>> I'm a mysql DBA in china.
>> More about me just visit here:
>> http://yueliangdao0608.cublog.cn
>>
>
>
>
> --
> Krishna Chandra Prajapati
> MySQL DBA,
> Ed Ventures e-Learning Pvt.Ltd.
> 1-8-303/48/15, Sindhi Colony
> P.G.Road, Secunderabad.
> Pin Code: 500003
> Office Number: 040-66489771
> Mob: 9912924044
> URL: ed-ventures-online.com
> Email-id: prajapatikc@xxxxxxxxx
>



-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn