Gecko [ www.75571699-36-20220316152901.webstarterz.com ]

Name	Size	Permission
SELinux	[ DIR ]	drwxr-xr-x
bulgarian	[ DIR ]	drwxr-xr-x
charsets	[ DIR ]	drwxr-xr-x
czech	[ DIR ]	drwxr-xr-x
danish	[ DIR ]	drwxr-xr-x
dutch	[ DIR ]	drwxr-xr-x
english	[ DIR ]	drwxr-xr-x
estonian	[ DIR ]	drwxr-xr-x
french	[ DIR ]	drwxr-xr-x
german	[ DIR ]	drwxr-xr-x
greek	[ DIR ]	drwxr-xr-x
hungarian	[ DIR ]	drwxr-xr-x
italian	[ DIR ]	drwxr-xr-x
japanese	[ DIR ]	drwxr-xr-x
korean	[ DIR ]	drwxr-xr-x
norwegian	[ DIR ]	drwxr-xr-x
norwegian-ny	[ DIR ]	drwxr-xr-x
polish	[ DIR ]	drwxr-xr-x
portuguese	[ DIR ]	drwxr-xr-x
romanian	[ DIR ]	drwxr-xr-x
russian	[ DIR ]	drwxr-xr-x
serbian	[ DIR ]	drwxr-xr-x
slovak	[ DIR ]	drwxr-xr-x
spanish	[ DIR ]	drwxr-xr-x
swedish	[ DIR ]	drwxr-xr-x
ukrainian	[ DIR ]	drwxr-xr-x
binary-configure	1.13 KB	-rwxr-xr-x
dictionary.txt	24.98 KB	-rwxr-xr-x
errmsg-utf8.txt	495 KB	-rwxr-xr-x
fill_help_tables.sql	875.74 KB	-rwxr-xr-x
innodb_memcached_config.sql	3.87 KB	-rwxr-xr-x
magic	773 B	-rwxr-xr-x
my-default.cnf	1.1 KB	-rwxr-xr-x
mysql-log-rotate	844 B	-rwxr-xr-x
mysql.server	10.84 KB	-rwxr-xr-x
mysql_security_commands.sql	2.07 KB	-rwxr-xr-x
mysql_system_tables.sql	91.47 KB	-rwxr-xr-x
mysql_system_tables_data.sql	3.88 KB	-rwxr-xr-x
mysql_test_data_timezone.sql	10.58 KB	-rwxr-xr-x
mysqld_multi.server	1.04 KB	-rwxr-xr-x

Code Editor : mysql_security_commands.sql

-- Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License, version 2.0,
-- as published by the Free Software Foundation.
--
-- This program is also distributed with certain software (including
-- but not limited to OpenSSL) that is licensed under separate terms,
-- as designated in a particular file or component or in included license
-- documentation.  The authors of MySQL hereby grant you an additional
-- permission to link the program and your derivative works with the
-- separately licensed software that they have included with MySQL.
--
-- This program 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, version 2.0, for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA

# This set of commands will modify the predefined accounts of a MySQL installation
# to increase security.

# 1) Set passwords for the root account.
# Note that the password 'ABC123xyz' will be replaced by a random string
# when these commands are transferred to the server.
SET @@old_passwords=1; 
UPDATE mysql.user SET Password=PASSWORD('ABC123xyz') WHERE User='root' and plugin='mysql_old_password';
SET @@old_passwords=0; 
UPDATE mysql.user SET Password=PASSWORD('ABC123xyz') WHERE User='root' and plugin in ('', 'mysql_native_password');
SET @@old_passwords=2; 
UPDATE mysql.user SET authentication_string=PASSWORD('ABC123xyz') WHERE User='root' and plugin='sha256_password';

# 2) Drop the anonymous account.
DELETE FROM mysql.user WHERE User='';

# 3) Force the root user to change the password on first connect.
UPDATE mysql.user SET Password_expired='Y' WHERE User='root';

# In case this file is sent to a running server.
FLUSH PRIVILEGES;

${this.title}

Code Editor : mysql_security_commands.sql