View Single Post
  #56  
Old 02-26-2006, 06:00 AM
MarCrush
Fire Beetle
 
Join Date: Feb 2005
Posts: 15
Exclamation

I noticed something wrong with your batch while you automacilly sourcing in your DB. You need to put a -p in the command (prompts for password) in the mysql command in your batch file otherwise it fails to source the database when root has a wrong password (i.e. blank password when a password exists). People that don't have a password for the root user just press enter.

Visual Example of what I am talking about:

You current have the batch file without the -p parameter.
Code:
@echo off
echo Please wait several minutes while your database is sourced...
mysql -u root < db.txt
You need to add the -p to the command so users can type in their passwords (most people set passwords to the root account because of security reasons).
Code:
@echo off
echo Please wait several minutes while your database is sourced...
mysql -u root -p < db.txt
Adding the -p parameter will being something like this:
Code:
Please wait several minutes while your database is sourced...
Enter Password:
After the user enters the password it will then be source into the database.

This is one problem I found in your Server Pack setup and can be easily fixed.
Reply With Quote