I am trying to set up a LAMP server that will double as a development machine. Basically, I am an ASP developer coming from 5 years at a Microsoft shop and I am wanting to expand into Apache/MySQL and PHP.

So far, here is where I am at. I am running SUSE 10.1 and it is installed and working. I am running Apache 2.2, I have it up and working. I am running PHP 5.1 and it is up and working. I can log into this machine across the network and view a simple PHP page.

MySQL is where I run into problems. I have it installed and it is working, however, I am having a devil of a time configuring the correct permissions. I have initially installed phpMyAdmin, however I cannot get the permissions set to where I can create a database or tables.

I have also installed MySQL GUI Tools and I run into the same issue, apparently, permissions aren't quite what they need to be.

I have followed the instructions on the MySQL manual page and still cannot seem to create any databases. I am not sure what I am missing, but I seriously need help in getting this configured as I really want to start banging out some code.

Can anyone help me step through some troubleshooting techniques to determine what the problem may be?