SM0 She11

Path: / / usr / share / mysql

Full Path (server): /usr/share/mysql

Create Fil3

Upl04d Fil3

• 📄 binary-configure [E] [D]
  [R]
• 📁 charsets Open [D]
  [R]
• 📁 czech Open [D]
  [R]
• 📁 danish Open [D]
  [R]
• 📁 dutch Open [D]
  [R]
• 📁 english Open [D]
  [R]
• 📄 errmsg-utf8.txt [E] [D]
  [R]
• 📁 estonian Open [D]
  [R]
• 📄 fill_help_tables.sql [E] [D]
  [R]
• 📁 french Open [D]
  [R]
• 📁 german Open [D]
  [R]
• 📁 greek Open [D]
  [R]
• 📁 hungarian Open [D]
  [R]
• 📄 install_spider.sql [E] [D]
  [R]
• 📁 italian Open [D]
  [R]
• 📁 japanese Open [D]
  [R]
• 📁 korean Open [D]
  [R]
• 📄 magic [E] [D]
  [R]
• 📄 maria_add_gis_sp.sql [E] [D]
  [R]
• 📄 maria_add_gis_sp_bootstrap.sql [E] [D]
  [R]
• 📄 my-huge.cnf [E] [D]
  [R]
• 📄 my-innodb-heavy-4G.cnf [E] [D]
  [R]
• 📄 my-large.cnf [E] [D]
  [R]
• 📄 my-medium.cnf [E] [D]
  [R]
• 📄 my-small.cnf [E] [D]
  [R]
• 📄 mysql-log-rotate [E] [D]
  [R]
• 📄 mysql.server [E] [D]
  [R]
• 📄 mysql_performance_tables.sql [E] [D]
  [R]
• 📄 mysql_system_tables.sql [E] [D]
  [R]
• 📄 mysql_system_tables_data.sql [E] [D]
  [R]
• 📄 mysql_test_data_timezone.sql [E] [D]
  [R]
• 📄 mysql_to_mariadb.sql [E] [D]
  [R]
• 📄 mysqld_multi.server [E] [D]
  [R]
• 📁 norwegian Open [D]
  [R]
• 📁 norwegian-ny Open [D]
  [R]
• 📁 policy Open [D]
  [R]
• 📁 polish Open [D]
  [R]
• 📁 portuguese Open [D]
  [R]
• 📁 romanian Open [D]
  [R]
• 📁 russian Open [D]
  [R]
• 📁 serbian Open [D]
  [R]
• 📁 slovak Open [D]
  [R]
• 📁 spanish Open [D]
  [R]
• 📁 swedish Open [D]
  [R]
• 📁 systemd Open [D]
  [R]
• 📁 ukrainian Open [D]
  [R]
• 📄 wsrep.cnf [E] [D]
  [R]
• 📄 wsrep_notify [E] [D]
  [R]

Editing: mysql_to_mariadb.sql

-- Script that changes MySQL 5.7 privilege tables to MariaDB 10.x -- This should be run first with -- mysql --force mysql < mysql_to_mariadb.sql -- It's ok to ignore any errors, as these usually means that the tables are -- already fixed. -- After this script s run, one should run at least: -- mysql_upgrade --upgrade-system-tables -- to get the other tables in the mysql database fixed. -- Drop not existing columnms alter table mysql.user drop column `password_last_changed`, drop column `password_lifetime`, drop column `account_locked`; -- Change existing columns alter table mysql.user change column `authentication_string` `auth_string` text COLLATE utf8_bin NOT NULL; -- Add new columns alter table mysql.user add column `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '' after `user`, add column `is_role` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N' after `auth_string`; alter table mysql.user add column `default_role` char(80) COLLATE utf8_bin NOT NULL DEFAULT '', add column `max_statement_time` decimal(12,6) NOT NULL DEFAULT '0.000000'; -- Fix passwords update mysql.user set `password`=`auth_string`, plugin='' where plugin="mysql_native_password";
Save