Well I thought I was doing things right.
Here's the story, I had my server up and running and working fine, but my motherboard died so I had to buy a new one with new CPU (just to upgrade) and then reinstalled Win2k Pro.
Now I'm starting from square one. I had learned a lot about the install and configure of Perl and MySQL from last time and I thought I was doing everything fine except I've run into a road block.
Problem is the SQL 2006 error from world.exe.
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
I have done the following things:
- Fresh install of MySQL 4.1.x
- Done everything Maveren has written.
- Mysql service is running, winMysqlAdmin is running
- DB.ini file has been rewritten with user/pass making sure there are no spaces or caps. (username and pass are in all lowercase)
- DB.ini file's user/pass match what is in my.ini
- One thing, whenever I do the Grant command, it always, ALWAYS, says 0 lines changed.
- I have granted access to eqk.* and even *.*
- I get no errors doing the Grant command, and the permission works when i try something like mysql -u administrator -p (when it asks for pass, i put it in and everything works)
So, from what I can troubleshoot, my db.ini file is ok, mysql permissions have been granted and have been tested to be working. I can use MySQL-Front from another computer on LAN and connect to EQK DB with the permissions. winmysqladmin and the mysqld-nt service are running.
I can't think of what I am over looking or where my problem might be coming from. I may have fogotten to put in some info here, if so, ask me and i'll post when I'm at home. Any one have any ideas?
Thanks[/list]
|