-- 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;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
bulgarian | Folder | 0755 |
|
|
charsets | Folder | 0755 |
|
|
czech | Folder | 0755 |
|
|
danish | Folder | 0755 |
|
|
docs | Folder | 0755 |
|
|
dutch | Folder | 0755 |
|
|
english | Folder | 0755 |
|
|
estonian | Folder | 0755 |
|
|
french | Folder | 0755 |
|
|
german | Folder | 0755 |
|
|
greek | Folder | 0755 |
|
|
hungarian | Folder | 0755 |
|
|
italian | Folder | 0755 |
|
|
japanese | Folder | 0755 |
|
|
korean | Folder | 0755 |
|
|
norwegian | Folder | 0755 |
|
|
norwegian-ny | Folder | 0755 |
|
|
polish | Folder | 0755 |
|
|
portuguese | Folder | 0755 |
|
|
romanian | Folder | 0755 |
|
|
russian | Folder | 0755 |
|
|
serbian | Folder | 0755 |
|
|
slovak | Folder | 0755 |
|
|
spanish | Folder | 0755 |
|
|
swedish | Folder | 0755 |
|
|
ukrainian | Folder | 0755 |
|
|
debian_create_root_user.sql | File | 1.79 KB | 0644 |
|
dictionary.txt | File | 24.98 KB | 0644 |
|
echo_stderr | File | 27 B | 0755 |
|
errmsg-utf8.txt | File | 518.77 KB | 0644 |
|
fill_help_tables.sql | File | 1.03 MB | 0644 |
|
innodb_memcached_config.sql | File | 3.91 KB | 0644 |
|
install_rewriter.sql | File | 2.17 KB | 0644 |
|
magic | File | 773 B | 0644 |
|
mysql-log-rotate | File | 844 B | 0644 |
|
mysql-systemd-start | File | 1.91 KB | 0755 |
|
mysql_security_commands.sql | File | 2.12 KB | 0644 |
|
mysql_sys_schema.sql | File | 281.58 KB | 0644 |
|
mysql_system_tables.sql | File | 151.8 KB | 0644 |
|
mysql_system_tables_data.sql | File | 1.19 KB | 0644 |
|
mysql_test_data_timezone.sql | File | 10.61 KB | 0644 |
|
mysqld_multi.server | File | 1.04 KB | 0755 |
|
uninstall_rewriter.sql | File | 1.21 KB | 0644 |
|