Linux servers are superior to windows. The fact that player ghosting doesn't exist on Linux, but does on Windows is enough for any serious admin to try it.
But, Linux certainly isn't for the non-technical. It can be very complex and one minor thing can cause hours of headache.
You don't need to install mysql admininstrator or anything. As long as you follow the wiki, you can get a server running with minimal issues. Your current problem appears to be with your mysql account that you are using for the emulator. Or possibly with the access for that account in your my.cnf file.
Once you fix that, you should be good to go. You are 99% of the way done now and just need that final thing to get it working.
But, if you don't have a separate windows PC that you can use for editing your database, you are going to have a much harder time. It can all be done from the Linux PC, but you can't run any of GeorgeS tools, or the spell editors. All you can run are PHP tools (which are very limited) and Navicat or you have to edit your database manually in mysql command line. I wasn't even able to get Navicat working on my Linux box at all, and I worked on it for a while. Though, I do have it running on my windows PC and able to connect to my Linux server to manage my database.
If you only have 1 PC to devote to this, you would be better off just using Windows. But, if you do have a spare PC you can run windows on to manage your database, then by all means, keep trying to get Linux working. You are so close and once you have it running, there isn't much more to it. Try googling your problems. You can find alot that way. Between that, the wikis and posts here, I got mine running with minimal help.
|