mysql_install_db.sh 15.5 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 90
test -z "$ldata" && ldata=@localstatedir@
if test -z "$basedir"
then
  basedir=@prefix@
  bindir=@bindir@
  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 105 106 107 108 109 110 111 112 113 114
  if test -x "$basedir/libexec/mysqld"
  then
    execdir="$basedir/libexec"
  elif test -x "@libexecdir@/mysqld"
  then
    execdir="@libexecdir@"
  else
    execdir="$basedir/bin"
  fi

  # find fill_help_tables.sh
  for i in $basedir/support-files $basedir/share $basedir/share/mysql $basedir/scripts @pkgdatadir@
  do
    if test -f $i/fill_help_tables.sql
    then
      pkgdatadir=$i
    fi
  done
fi

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 120 121
  if test $verbose -eq 1
  then
    echo "Could not find help file 'fill_help_tables.sql'".
  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 150 151 152 153 154 155
then
  resolved=`$bindir/resolveip $hostname 2>&1`
  if [ $? -ne 0 ]
  then
    resolved=`$bindir/resolveip localhost 2>&1`
    if [ $? -eq 0 ]
    then
      echo "Sorry, the host '$hostname' could not be looked up."
      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
156 157 158 159 160 161
    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
162 163 164 165
  fi
fi

# Create database directories mysql & test
166
if test "$in_rpm" -eq 0 || "$windows" -eq 0
unknown's avatar
unknown committed
167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185
then
  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
fi

# Initialize variables
c_d="" i_d=""
c_h="" i_h=""
c_u="" i_u=""
c_f="" i_f=""
c_t="" c_c=""

# Check for old tables
if test ! -f $mdata/db.frm
then
unknown's avatar
unknown committed
186 187 188
  if test $verbose -eq 1 ; then 
    echo "Preparing db table"
  fi
unknown's avatar
unknown committed
189 190
  # mysqld --bootstrap wants one command/line
  c_d="$c_d CREATE TABLE db ("
191 192 193
  c_d="$c_d   Host char(60) binary DEFAULT '' NOT NULL,"
  c_d="$c_d   Db char(64) binary DEFAULT '' NOT NULL,"
  c_d="$c_d   User char(16) binary DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
194 195 196 197 198 199 200 201 202 203
  c_d="$c_d   Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
204 205
  c_d="$c_d   Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
unknown's avatar
unknown committed
206 207 208 209 210
  c_d="$c_d PRIMARY KEY Host (Host,Db,User),"
  c_d="$c_d KEY User (User)"
  c_d="$c_d )"
  c_d="$c_d comment='Database privileges';"
  
211 212
  i_d="INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y');
  INSERT INTO db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y');"
unknown's avatar
unknown committed
213 214 215 216
fi

if test ! -f $mdata/host.frm
then
unknown's avatar
unknown committed
217 218 219
  if test $verbose -eq 1 ; then
    echo "Preparing host table"
  fi
unknown's avatar
unknown committed
220 221

  c_h="$c_h CREATE TABLE host ("
222 223
  c_h="$c_h  Host char(60) binary DEFAULT '' NOT NULL,"
  c_h="$c_h  Db char(64) binary DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
224 225 226 227 228 229 230 231 232 233
  c_h="$c_h  Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
234 235
  c_h="$c_h  Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
unknown's avatar
unknown committed
236 237 238 239 240 241 242
  c_h="$c_h  PRIMARY KEY Host (Host,Db)"
  c_h="$c_h )"
  c_h="$c_h comment='Host privileges;  Merged with database privileges';"
fi

if test ! -f $mdata/user.frm
then
unknown's avatar
unknown committed
243 244 245
  if test $verbose -eq 1 ; then
    echo "Preparing user table"
  fi
unknown's avatar
unknown committed
246 247

  c_u="$c_u CREATE TABLE user ("
248 249
  c_u="$c_u   Host char(60) binary DEFAULT '' NOT NULL,"
  c_u="$c_u   User char(16) binary DEFAULT '' NOT NULL,"
250
  c_u="$c_u   Password char(45) binary DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
251 252 253 254 255 256 257 258 259 260 261 262 263 264
  c_u="$c_u   Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Process_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   File_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
unknown's avatar
unknown committed
265 266 267 268 269 270 271 272
  c_u="$c_u   Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Super_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Execute_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Repl_slave_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
  c_u="$c_u   ssl_type enum('','ANY','X509', 'SPECIFIED') DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
273 274 275
  c_u="$c_u   ssl_cipher BLOB NOT NULL,"
  c_u="$c_u   x509_issuer BLOB NOT NULL,"
  c_u="$c_u   x509_subject BLOB NOT NULL,"
276 277 278
  c_u="$c_u   max_questions int(11) unsigned DEFAULT 0  NOT NULL,"
  c_u="$c_u   max_updates int(11) unsigned DEFAULT 0  NOT NULL,"
  c_u="$c_u   max_connections int(11) unsigned DEFAULT 0  NOT NULL,"
unknown's avatar
unknown committed
279 280 281 282
  c_u="$c_u   PRIMARY KEY Host (Host,User)"
  c_u="$c_u )"
  c_u="$c_u comment='Users and global privileges';"

unknown's avatar
unknown committed
283
  i_u="INSERT INTO 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','','','','',0,0,0);
unknown's avatar
unknown committed
284
  
unknown's avatar
unknown committed
285
  REPLACE INTO 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','','','','',0,0,0);
286
  
unknown's avatar
unknown committed
287 288
  INSERT INTO user (host,user) values ('localhost','');
"
289 290 291 292 293

  if test "$windows" -eq 0
  then
    i_u="$i_u INSERT INTO user VALUES ('$hostname','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
  
unknown's avatar
unknown committed
294
  REPLACE INTO user VALUES ('$hostname','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
unknown's avatar
unknown committed
295
  
unknown's avatar
unknown committed
296
  INSERT INTO user (host,user) values ('$hostname','');"
297
  fi
unknown's avatar
unknown committed
298 299 300 301
fi

if test ! -f $mdata/func.frm
then
unknown's avatar
unknown committed
302 303 304
  if test $verbose -eq 1 ; then
    echo "Preparing func table"
  fi
unknown's avatar
unknown committed
305 306

  c_f="$c_f CREATE TABLE func ("
307
  c_f="$c_f   name char(64) binary DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
308 309 310 311 312 313 314 315 316 317
  c_f="$c_f   ret tinyint(1) DEFAULT '0' NOT NULL,"
  c_f="$c_f   dl char(128) DEFAULT '' NOT NULL,"
  c_f="$c_f   type enum ('function','aggregate') NOT NULL,"
  c_f="$c_f   PRIMARY KEY (name)"
  c_f="$c_f )"
  c_f="$c_f   comment='User defined functions';"
fi

if test ! -f $mdata/tables_priv.frm
then
unknown's avatar
unknown committed
318 319 320
  if test $verbose -eq 1 ; then
   echo "Preparing tables_priv table"
 fi
unknown's avatar
unknown committed
321 322

  c_t="$c_t CREATE TABLE tables_priv ("
323 324 325 326
  c_t="$c_t   Host char(60) binary DEFAULT '' NOT NULL,"
  c_t="$c_t   Db char(64) binary DEFAULT '' NOT NULL,"
  c_t="$c_t   User char(16) binary DEFAULT '' NOT NULL,"
  c_t="$c_t   Table_name char(60) binary DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
327 328 329 330 331 332 333 334 335 336 337 338
  c_t="$c_t   Grantor char(77) DEFAULT '' NOT NULL,"
  c_t="$c_t   Timestamp timestamp(14),"
  c_t="$c_t   Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL,"
  c_t="$c_t   Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
  c_t="$c_t   PRIMARY KEY (Host,Db,User,Table_name),"
  c_t="$c_t   KEY Grantor (Grantor)"
  c_t="$c_t )"
  c_t="$c_t   comment='Table privileges';"
fi

if test ! -f $mdata/columns_priv.frm
then
unknown's avatar
unknown committed
339 340 341
  if test $verbose -eq 1 ; then
    echo "Preparing columns_priv table"
  fi
unknown's avatar
unknown committed
342 343

  c_c="$c_c CREATE TABLE columns_priv ("
344 345 346 347 348
  c_c="$c_c   Host char(60) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   Db char(64) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   User char(16) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   Table_name char(64) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   Column_name char(64) binary DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
349 350 351 352 353 354 355
  c_c="$c_c   Timestamp timestamp(14),"
  c_c="$c_c   Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
  c_c="$c_c   PRIMARY KEY (Host,Db,User,Table_name,Column_name)"
  c_c="$c_c )"
  c_c="$c_c   comment='Column privileges';"
fi

356 357 358 359 360 361
if test ! -f $mdata/proc.frm
then
  echo "Preparing proc table"

  c_p="$c_p CREATE TABLE proc ("
  c_p="$c_p   name char(64) binary DEFAULT '' NOT NULL,"
362
  c_p="$c_p   type enum('function','procedure') NOT NULL,"
363
  c_p="$c_p   body blob DEFAULT '' NOT NULL,"
unknown's avatar
unknown committed
364 365 366 367 368
  c_p="$c_p   creator char(77) binary DEFAULT '' NOT NULL,"
  c_p="$c_p   created timestamp,"  
  c_p="$c_p   modified timestamp,"
  c_p="$c_p   suid enum ('N', 'Y') DEFAULT 'Y' NOT NULL,"
  c_p="$c_p   comment char(64) binary DEFAULT '' NOT NULL,"
369
  c_p="$c_p   PRIMARY KEY (name,type)"
370 371 372 373
  c_p="$c_p )"
  c_p="$c_p   comment='Stored Procedures';"
fi

unknown's avatar
unknown committed
374
echo "Installing privilege tables"
unknown's avatar
unknown committed
375 376
if (
    cat << END_OF_DATA
unknown's avatar
unknown committed
377 378 379 380 381 382 383 384 385 386 387 388 389 390 391
use mysql;
$c_d
$i_d

$c_h
$i_h

$c_u
$i_u

$c_f
$i_f

$c_t
$c_c
392
$c_p
unknown's avatar
unknown committed
393
END_OF_DATA
unknown's avatar
unknown committed
394 395 396 397
   if test -n "$fill_help_tables"
   then
     cat $fill_help_tables
   fi
unknown's avatar
unknown committed
398 399
) | eval "$execdir/mysqld $defaults --bootstrap --skip-grant-tables \
         --basedir=$basedir --datadir=$ldata --skip-innodb --skip-bdb $args" 
unknown's avatar
unknown committed
400 401
then
  echo ""
402
  if test "$in_rpm" -eq 0 || "$windows" -eq 0
unknown's avatar
unknown committed
403 404 405 406 407 408 409
  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
410 411
  echo "$bindir/mysqladmin -u root password 'new-password'"
  echo "$bindir/mysqladmin -u root -h $hostname password 'new-password'"
unknown's avatar
unknown committed
412 413 414 415 416 417 418 419 420 421 422
  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
423
  if test "$in_rpm" -eq 0 -a "$windows" -eq 0
unknown's avatar
unknown committed
424
  then
unknown's avatar
unknown committed
425
    echo "You can start the MySQL daemon with:"
unknown's avatar
unknown committed
426
    echo "cd @prefix@ ; $bindir/mysqld_safe &"
unknown's avatar
unknown committed
427
    echo
unknown's avatar
unknown committed
428
    echo "You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:"
unknown's avatar
unknown committed
429
    echo "cd sql-bench ; perl run-all-tests"
unknown's avatar
unknown committed
430 431 432 433 434 435
    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"
436
  echo "Support MySQL by buying support/licenses at https://order.mysql.com"
unknown's avatar
unknown committed
437 438 439 440 441
  exit 0
else
  echo "Installation of grant tables failed!"
  echo
  echo "Examine the logs in $ldata for more information."
unknown's avatar
unknown committed
442
  echo "You can also try to start the mysqld daemon with:"
unknown's avatar
unknown committed
443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462
  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