Gecko [ theprintave.ca ]

Name	Size	Permission	Date
bulgarian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
charsets	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
czech	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
danish	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
docs	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
dutch	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
english	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
estonian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
french	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
german	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
greek	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
hungarian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
italian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
japanese	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
korean	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
norwegian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
norwegian-ny	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
polish	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
portuguese	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
romanian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
russian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
serbian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
slovak	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
spanish	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
swedish	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
ukrainian	[ DIR ]	drwxr-xr-x	2025-05-06 06:30
debian_create_root_user.sql	1.79 KB	-rw-r--r--	2025-04-25 17:19
dictionary.txt	24.98 KB	-rw-r--r--	2025-03-31 08:19
echo_stderr	27 B	-rwxr-xr-x	2025-04-25 17:19
innodb_memcached_config.sql	3.91 KB	-rw-r--r--	2025-03-31 08:19
install_rewriter.sql	2.21 KB	-rw-r--r--	2025-04-25 17:19
mysql-log-rotate	1.98 KB	-rw-r--r--	2025-04-25 17:19
mysql-systemd-start	2.09 KB	-rwxr-xr-x	2023-06-14 19:23
mysqld_multi.server	1.04 KB	-rwxr-xr-x	2025-03-31 08:19
uninstall_rewriter.sql	1.27 KB	-rw-r--r--	2025-04-25 17:19

Rename

-- Get the hostname, if the hostname has any wildcard character like "_" or "%"
-- add escape character in front of wildcard character to convert "_" or "%" to
-- a plain character
SET @get_hostname= @@hostname;
SELECT REPLACE((SELECT REPLACE(@get_hostname,'_','\_')),'%','\%') INTO @current_hostname;

-- Fill "user" table with default users allowing root access
-- from local machine if "user" table didn't exist before
CREATE TEMPORARY TABLE tmp_user LIKE user;
INSERT INTO tmp_user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N');
REPLACE INTO tmp_user SELECT @current_hostname,'root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N' FROM dual WHERE LOWER( @current_hostname) != 'localhost';
REPLACE INTO tmp_user VALUES ('127.0.0.1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N');
REPLACE INTO tmp_user VALUES ('::1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N');
INSERT INTO user SELECT * FROM tmp_user WHERE @had_user_table=0;
DROP TABLE tmp_user;

CREATE TEMPORARY TABLE tmp_proxies_priv LIKE proxies_priv;
INSERT INTO tmp_proxies_priv VALUES ('localhost', 'root', '', '', TRUE, '', now());
REPLACE INTO tmp_proxies_priv SELECT @current_hostname, 'root', '', '', TRUE, '', now() FROM DUAL WHERE LOWER (@current_hostname) != 'localhost';
INSERT INTO  proxies_priv SELECT * FROM tmp_proxies_priv WHERE @had_proxies_priv_table=0;
DROP TABLE tmp_proxies_priv;
FLUSH PRIVILEGES;