View Single Post
  #2  
Old 03-05-2004, 09:33 AM
samandhi's Avatar
samandhi
Demi-God
 
Join Date: Aug 2003
Posts: 1,056
Default

Quote:
DB Query Error #2006: MySQL server has gone away
That is your problem. You need to close down MySQL and open up windows explorer/my computer, and find the file my.ini in c:\windows. Delete it. Run winmysqladmin.exe from the MySQL/bin folder. This will allow you to put in whatever UN/PW you want... Then, open up a cmd prompt and type the following, replacing username with the one you used in winmysqladmin.exe, and password with the one from winmysqladmin.exe:

Code:
mysql -u root mysql
GRANT ALL PRIVILEGES ON *.* TO <your username>@localhost IDENTIFIED BY '<your password>' WITH GRANT OPTION;
quit
NOTE the ' key (apostrophe) has to enclose your password, but NOT your username..
__________________

Quote:
Analysis paralysis will keep you from failing, but it will also keep you from succeeding.
  • L.L. CoolJ