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

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

Do you think which can be affected when I have many instance running?.
I know the step you told me,
I only want to know if there are any other options to apply the security to
other instances or not .


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

> mysql_secure_installation do the following things.
>
> 1. Create a root password if it doesn't exist.
> 2. Remove remote root login if it exist.
> 3. Remove test database it  ask you an option for that.
>
> ..... few more steps
>
> All the above things can be done manually. after connecting mysql as root
>
>
> .On Tue, May 27, 2008 at 2:09 PM, Moon's Father <yueliangdao0608@xxxxxxxxx>
> wrote:
>
>> 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
>>
>
>
>
> --
> 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