Gecko [ gandhischool.edu.np ]

Name	Size	Permission
bulgarian	[ DIR ]	drwxr-xr-x
charsets	[ DIR ]	drwxr-xr-x
czech	[ DIR ]	drwxr-xr-x
danish	[ DIR ]	drwxr-xr-x
docs	[ 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
debian_create_root_user.sql	1.79 KB	-rw-r--r--
dictionary.txt	24.98 KB	-rw-r--r--
echo_stderr	27 B	-rwxr-xr-x
innodb_memcached_config.sql	3.91 KB	-rw-r--r--
install_rewriter.sql	2.21 KB	-rw-r--r--
mysql-log-rotate	1.98 KB	-rw-r--r--
mysql-systemd-start	2.09 KB	-rwxr-xr-x
mysqld_multi.server	1.04 KB	-rwxr-xr-x
uninstall_rewriter.sql	1.27 KB	-rw-r--r--

Code Editor : debian_create_root_user.sql

-- 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;

${this.title}

Code Editor : debian_create_root_user.sql