mysql_install_db.sh 7.43 KB
Newer Older
unknown's avatar
unknown committed
1
#!/bin/sh
unknown's avatar
unknown committed
2
# Copyright (C) 2002-2003 MySQL AB
3
# For a more info consult the file COPYRIGHT distributed with this file.
unknown's avatar
unknown committed
4 5 6 7

# This scripts creates the privilege tables db, host, user, tables_priv,
# columns_priv in the mysql database, as well as the func table.
#
8
# All unrecognized arguments to this script are passed to mysqld.
unknown's avatar
unknown committed
9

10
in_rpm=0
11
case "$1" in
12 13
    --rpm)
      in_rpm="1"; shift
14 15
      ;;
esac
16 17
windows=0
case "$1" in
18
    --windows)
19 20 21
      windows="1"; shift
      ;;
esac
unknown's avatar
unknown committed
22
defaults=
23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
case "$1" in
    --no-defaults|--defaults-file=*|--defaults-extra-file=*)
      defaults="$1"; shift
      ;;
esac

parse_arguments() {
  # We only need to pass arguments through to the server if we don't
  # handle them here.  So, we collect unrecognized options (passed on
  # the command line) into the args variable.
  pick_args=
  if test "$1" = PICK-ARGS-FROM-ARGV
  then
    pick_args=1
    shift
  fi
unknown's avatar
unknown committed
39

40 41 42 43 44 45
  for arg do
    case "$arg" in
      --force) force=1 ;;
      --basedir=*) basedir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
      --ldata=*|--datadir=*) ldata=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
      --user=*) user=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
unknown's avatar
unknown committed
46
      --verbose) verbose=1 ;;
47 48 49 50 51 52 53 54 55 56
      *)
        if test -n "$pick_args"
        then
          # This sed command makes sure that any special chars are quoted,
          # so the arg gets passed exactly to the server.
          args="$args "`echo "$arg" | sed -e 's,\([^a-zA-Z0-9_.-]\),\\\\\1,g'`
        fi
        ;;
    esac
  done
unknown's avatar
unknown committed
57 58
}

59 60 61 62 63 64 65 66 67 68 69 70 71 72
# Get first arguments from the my.cfg file, groups [mysqld] and
# [mysql_install_db], and then merge with the command line arguments
if test -x ./bin/my_print_defaults
then
  print_defaults="./bin/my_print_defaults"
elif test -x @bindir@/my_print_defaults
then
  print_defaults="@bindir@/my_print_defaults"
elif test -x @bindir@/mysql_print_defaults
then
  print_defaults="@bindir@/mysql_print_defaults"
else
  print_defaults="my_print_defaults"
fi
unknown's avatar
unknown committed
73

74 75 76 77 78 79
args=
ldata=
execdir=
bindir=
basedir=
force=0
unknown's avatar
unknown committed
80 81
verbose=0
fill_help_tables=""
82 83
parse_arguments `$print_defaults $defaults mysqld mysql_install_db`
parse_arguments PICK-ARGS-FROM-ARGV "$@"
unknown's avatar
unknown committed
84

85 86 87 88 89
test -z "$ldata" && ldata=@localstatedir@
if test -z "$basedir"
then
  basedir=@prefix@
  bindir=@bindir@
unknown's avatar
unknown committed
90
  execdir=@libexecdir@
unknown's avatar
unknown committed
91
  pkgdatadir=@pkgdatadir@
92
else
93
  bindir="$basedir/bin"
unknown's avatar
unknown committed
94 95 96 97 98 99 100 101 102 103 104
  if test -x "$basedir/libexec/mysqld"
  then
    execdir="$basedir/libexec"
  elif test -x "@libexecdir@/mysqld"
  then
    execdir="@libexecdir@"
  else
    execdir="$basedir/bin"
  fi
fi

unknown's avatar
unknown committed
105 106 107 108 109 110 111 112 113
# find fill_help_tables.sh
for i in $basedir/support-files $basedir/share $basedir/share/mysql $basedir/scripts `pwd` @pkgdatadir@
do
  if test -f $i/fill_help_tables.sql
  then
    pkgdatadir=$i
  fi
done

unknown's avatar
unknown committed
114
if test -f $pkgdatadir/fill_help_tables.sql
unknown's avatar
unknown committed
115
then
unknown's avatar
unknown committed
116
  fill_help_tables=$pkgdatadir/fill_help_tables.sql
117
else
unknown's avatar
unknown committed
118 119
  if test $verbose -eq 1
  then
unknown's avatar
unknown committed
120
    echo "Could not find help file 'fill_help_tables.sql' ;$pkgdatadir; ;$basedir;".
unknown's avatar
unknown committed
121
  fi
122
fi
unknown's avatar
unknown committed
123 124 125

mdata=$ldata/mysql

126
if test "$windows" -eq 0 -a ! -x $execdir/mysqld
unknown's avatar
unknown committed
127
then
128
  if test "$in_rpm" -eq 1
unknown's avatar
unknown committed
129 130 131 132 133 134 135 136 137 138
  then
    echo "FATAL ERROR $execdir/mysqld not found!"
    exit 1
  else
    echo "Didn't find $execdir/mysqld"
    echo "You should do a 'make install' before executing this script"
    exit 1
  fi
fi

139
hostname=`@HOSTNAME@`		# Install this too in the user table
unknown's avatar
unknown committed
140 141

# Check if hostname is valid
142
if test "$windows" -eq 0 -a "$in_rpm" -eq 0 -a $force -eq 0
unknown's avatar
unknown committed
143 144 145 146 147 148 149
then
  resolved=`$bindir/resolveip $hostname 2>&1`
  if [ $? -ne 0 ]
  then
    resolved=`$bindir/resolveip localhost 2>&1`
    if [ $? -eq 0 ]
    then
150 151
      echo "Neither host '$hostname' and 'localhost' could not be looked up with"
      echo "$bindir/resolveip"
unknown's avatar
unknown committed
152 153 154 155 156
      echo "Please configure the 'hostname' command to return a correct hostname."
      echo "If you want to solve this at a later stage, restart this script with"
      echo "the --force option"
      exit 1
    fi
unknown's avatar
unknown committed
157 158 159 160 161 162
    echo "WARNING: The host '$hostname' could not be looked up with resolveip."
    echo "This probably means that your libc libraries are not 100 % compatible"
    echo "with this binary MySQL version. The MySQL deamon, mysqld, should work"
    echo "normally with the exception that host name resolving will not work."
    echo "This means that you should use IP addresses instead of hostnames"
    echo "when specifying MySQL privileges !"
unknown's avatar
unknown committed
163 164 165 166
  fi
fi

# Create database directories mysql & test
unknown's avatar
unknown committed
167

unknown's avatar
unknown committed
168 169 170 171 172 173 174 175 176
  if test ! -d $ldata; then mkdir $ldata; chmod 700 $ldata ; fi
  if test ! -d $ldata/mysql; then mkdir $ldata/mysql;  chmod 700 $ldata/mysql ; fi
  if test ! -d $ldata/test; then mkdir $ldata/test;  chmod 700 $ldata/test ; fi
  if test -w / -a ! -z "$user"; then
    chown $user $ldata $ldata/mysql $ldata/test;
  fi

if test ! -f $mdata/db.frm
then
unknown's avatar
unknown committed
177
  c_d="yes"
unknown's avatar
unknown committed
178 179
fi

unknown's avatar
unknown committed
180
if test $verbose -eq 1
unknown's avatar
unknown committed
181
then
unknown's avatar
unknown committed
182 183 184
  create_option="verbose"
else
  create_option="real"
unknown's avatar
unknown committed
185 186
fi

unknown's avatar
unknown committed
187
echo "Installing all prepared tables"
unknown's avatar
unknown committed
188
if (
189
   ./mysql_create_system_tables $create_option $mdata $hostname $windows 
unknown's avatar
unknown committed
190 191 192 193
   if test -n "$fill_help_tables"
   then
     cat $fill_help_tables
   fi
unknown's avatar
unknown committed
194 195
) | eval "$execdir/mysqld $defaults --bootstrap --skip-grant-tables \
         --basedir=$basedir --datadir=$ldata --skip-innodb --skip-bdb $args" 
unknown's avatar
unknown committed
196 197
then
  echo ""
198
  if test "$in_rpm" -eq 0 || "$windows" -eq 0
unknown's avatar
unknown committed
199 200 201 202 203 204 205
  then
    echo "To start mysqld at boot time you have to copy support-files/mysql.server"
    echo "to the right place for your system"
    echo
  fi
  echo "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !"
  echo "This is done with:"
unknown's avatar
unknown committed
206 207
  echo "$bindir/mysqladmin -u root password 'new-password'"
  echo "$bindir/mysqladmin -u root -h $hostname password 'new-password'"
unknown's avatar
unknown committed
208 209 210 211 212 213 214 215 216 217 218
  echo "See the manual for more instructions."
  #
  # Print message about upgrading unless we have created a new db table.
  if test -z "$c_d"
  then
    echo
    echo "NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run"
    echo "the $bindir/mysql_fix_privilege_tables. Otherwise you will not be"
    echo "able to use the new GRANT command!"
  fi
  echo
219
  if test "$in_rpm" -eq 0 -a "$windows" -eq 0
unknown's avatar
unknown committed
220
  then
unknown's avatar
unknown committed
221
    echo "You can start the MySQL daemon with:"
unknown's avatar
unknown committed
222
    echo "cd @prefix@ ; $bindir/mysqld_safe &"
unknown's avatar
unknown committed
223
    echo
unknown's avatar
unknown committed
224
    echo "You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:"
unknown's avatar
unknown committed
225
    echo "cd sql-bench ; perl run-all-tests"
unknown's avatar
unknown committed
226 227 228 229 230 231
    echo
  fi
  echo "Please report any problems with the @scriptdir@/mysqlbug script!"
  echo
  echo "The latest information about MySQL is available on the web at"
  echo "http://www.mysql.com"
232
  echo "Support MySQL by buying support/licenses at https://order.mysql.com"
unknown's avatar
unknown committed
233 234 235 236 237
  exit 0
else
  echo "Installation of grant tables failed!"
  echo
  echo "Examine the logs in $ldata for more information."
unknown's avatar
unknown committed
238
  echo "You can also try to start the mysqld daemon with:"
unknown's avatar
unknown committed
239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258
  echo "$execdir/mysqld --skip-grant &"
  echo "You can use the command line tool"
  echo "$bindir/mysql to connect to the mysql"
  echo "database and look at the grant tables:"
  echo
  echo "shell> $bindir/mysql -u root mysql"
  echo "mysql> show tables"
  echo
  echo "Try 'mysqld --help' if you have problems with paths. Using --log"
  echo "gives you a log in $ldata that may be helpful."
  echo
  echo "The latest information about MySQL is available on the web at"
  echo "http://www.mysql.com"
  echo "Please consult the MySQL manual section: 'Problems running mysql_install_db',"
  echo "and the manual section that describes problems on your OS."
  echo "Another information source is the MySQL email archive."
  echo "Please check all of the above before mailing us!"
  echo "And if you do mail us, you MUST use the @scriptdir@/mysqlbug script!"
  exit 1
fi