MYSQL_SECURE_INST(1) MySQL Database System MYSQL_SECURE_INST(1)NAME
mysql_secure_installation - improve MySQL installation security
SYNOPSIS
mysql_secure_installation
DESCRIPTION
This program enables you to improve the security of your MySQL installation in the following ways:
o You can set a password for root accounts.
o You can remove root accounts that are accessible from outside the local host.
o You can remove anonymous-user accounts.
o You can remove the test database, which by default can be accessed by anonymous users.
Invoke mysql_secure_installation without arguments:
shell> mysql_secure_installation
The script will prompt you to determine which actions to perform.
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQL_SECURE_INST(1)
Check Out this Related Man Page
RESOLVEIP(1) MySQL Database System RESOLVEIP(1)NAME
resolveip - resolve host name to IP address or vice versa
SYNOPSIS
resolveip [options] {host_name|ip-addr} ...
DESCRIPTION
The resolveip utility resolves host names to IP addresses and vice versa.
Invoke resolveip like this:
shell> resolveip [options] {host_name|ip-addr} ...
resolveip supports the following options.
o --help, --info, -?, -I
Display a help message and exit.
o --silent, -s
Silent mode. Produce less output.
o --version, -V
Display version information and exit.
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 RESOLVEIP(1)
i am a newbie to unix admin stuff so bare with me. -- i get this message when executing mysql_install_db during the installation of mysql. what is the cause of this and how can it be fixed. btw - i have tried installing as root and other accounts also.
scripts/mysql_install_db:... (6 Replies)
I am needing to "un-block" port 3306 so that I can access MySQL from another PC.
When I installed Mandrake 8.1, I set the security level to high because it is going to be a web server. I believe I have to allow access to my ports now and I do not know the commands to do that.
If anyone... (4 Replies)
Hi! I have a website, and it's been down for a long time now, because MySQL died (www.3dkingdom.org). I need someone who can get me the root password of the server (I will find someone to take care of the MySQL database, because there is about 20 sites there and none of them have MySQL databases... (6 Replies)
i'm following the, "How to setup and secure Snort, MySQL and Acid on FreeBSD 4.6 Release" off of the snort.org website.
in the documentation it says snort should be installed through the following:
-----
make -DWITH_MYSQL -DWITH_FLEXRESP ; make install
-----
later it says to do the... (13 Replies)
People that are interested in Unix security and the like might want to check out my site http://dusty.b33r.net/ Im offering free shell accounts, web hosting as well as that I am setting up some wargames similar to those over at http://www.pulltheplug.org/ infact im hosting blackhole for them. At... (4 Replies)
Hi,
I'm facing troubles in installing MySQL on AIX 5.3. After I run make it's getting errors and exiting, few of the errors are pasted below. Please help me to install it succesfully.
ld: 0711-235 WARNING: Archive member ../mysys/libmysys.a is not
an object file or an import list.... (2 Replies)
Hi all,
It's been a long week and my brain is clearly not functioning right so hopefully someone can help me out here.
I've got a function in a script which just checks if a MySQL database directory exists or not. Code is as follows:
dbCheck2() {
if ;
then {
:
# carry... (4 Replies)
Hi all,
I have developed an application in linux that uses MySQL and unixODBC. Now I am making a small installer for this application that configures environment for this application.
What I need is the way to check if MySQL and unixODBC is installed on the system before I start installing my... (3 Replies)
Hi,
I have installed MySql version 5.0.67 in RedHat LINUX version 5. The installation completed successfully.
When I am trying to start the service an error occured the error shown below
".......Manager of pid-file quit without updating file"
Can anyone help me to fix the problem.... (4 Replies)
Hi
I have file like this:
Sun Jan 24 03:00:00 2010: *** Weekly Process - get_ens_files.pl START ***
Sun Jan 24 03:00:00 2010: *** ***
Sun Jan 24 03:00:00 2010: ***************************************************
Sun Jan 24 03:00:11 2010: ... (2 Replies)
I'm trying to set an admin password for MySQL using the following command:
$ /usr/local/mysql/bin/mysqladmin -u root -p new_password
But, I get the following error message?
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user... (2 Replies)
Hi,
I tried installing MySql in my Ubuntu OS in my Laptop with the help of the information in below link
How to Install MySQL in Ubuntu 10.04
The download of required files happened but I dont know there is installation happened or not. Because as mentioned in the above link there is no... (3 Replies)
Can someone tell me the syntax to run a shell script from within MySQL? I know there is a way to do it, but I can't remember the syntax. I thought it was something like:
mysql> \. /user/myscript;
but I get this error:
Failed to open file '/user/myscript;', error: 2
Please help!... (4 Replies)
Please help me identify these user accounts..
bin, lp, nuucp, smbnull, mysql, tftp
Can we remove these user or disable these users?We have to apply the security policy about the user identification.Since it was settup by our vendor long time ago. We do not have these informations about these... (3 Replies)
I followed the directions here
Free Twitter Source Code ? Twitter Database Server: Install
and created a php script that enters twitter keyword searches into a MySQL DB.
When you execute the files outlined in the above link, a script starts indefinitely.
I've noticed that the scripts... (6 Replies)