I've been struggling since 1 am with this thing and I am quite fed up by now. It's 6 am.|
First of all hello all, and a quick note of congratulations to everyone at Xampp for an excellent package that saves me the hassle of configuring apache.
My problem is with SQL though.
I've read and searched every possible post regarding th MySQL installation part of Xampp. I read all manuals and faq's (which are contradictory in places but you can get the meaning OK I guess)
So here it is.
Installed everything and it looks smooth besides MySQL. I followed all security related issues regarding MySQL (couldn't figure out yet where to alter the SAFE MODE ON this is required because that's the environment the production server is running on the ISP) and I cannot login with the root user+password I have defined in cookie mode in the config.inc.php file. Tried everypossible combination of host names to avail either.
Well I thought I'd try to enter with pma user and that worked but this user is not given grants to create new databases nor tables anywhere. not even in the existing two databases. phpmyadmin and information_schema.
I couldn't also find the mysql database everybody's speaking of and I am very surprised that lots of people were able to create databases and one them even said he created users from inside the phpmyadmin interface????
How? What is wrong with my installation????
thnx in advance