[SPTUsers] "SPT--Config.php" configuration problem

Ming zzm at ns.lzb.ac.cn
Fri Oct 24 10:07:36 CDT 2003


   Those exampling steps below may help you to solve the problem:
   
   [1]login to Mysql as root,check to see if there exist a correct database and
      a user needed to run SPT.To solve the pproblem quickly,you may try to create
      a new database and a new user,for example,database named "DB_SPT" and a user
      named "SPT_USER" on it:
         mysql>CREATE DATABASE DB_SPT;
         mysql>GRANT ALL TO SPT_USER ON DB_SPT IDENTIFIED BY 'your_user_password'
         mysql>WITH GRANT OPTION;
         mysql>GRANT ALL TO SPT_USER at localhost ON DB_SPT IDENTIFIED BY 'your_user_password'
         mysql>WITH GRANT OPTION;
         mysql>QUIT;
   [2]Then modify the configuration file as follows:
       $DBUserName = "SPT_USER";   
       $DBPassword = "your_user_password";    
       $DBHost = "localhost";    
       $DBName = "DB_SPT";  
       .......
   
  
 



   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://scout.wisc.edu/pipermail/sptusers/attachments/20031024/a01d2581/attachment.htm


More information about the SPTUsers mailing list