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

["Krishna Chandra Prajapati" <prajapatikc@xxxxxxxxx>]

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