1
by brian
clean slate |
1 |
# This part converts any old privilege tables to privilege tables suitable |
2 |
# for current version of MySQL |
|
3 |
||
4 |
# You can safely ignore all 'Duplicate column' and 'Unknown column' errors |
|
5 |
# because these just mean that your tables are already up to date. |
|
6 |
# This script is safe to run even if your tables are already up to date! |
|
7 |
||
8 |
# On unix, you should use the mysql_fix_privilege_tables script to execute |
|
9 |
# this sql script. |
|
10 |
# On windows you should do 'mysql --force mysql < mysql_fix_privilege_tables.sql' |
|
11 |
||
12 |
set storage_engine=MyISAM; |
|
13 |
||
14 |
||
15 |
# Activate the new, possible modified privilege tables |
|
16 |
# This should not be needed, but gives us some extra testing that the above |
|
17 |
# changes was correct |
|
18 |
||
19 |
flush privileges; |