patratel

Hi, I've dropped XAMPP and I've installed Apache 2.4.4, PHP 5.4.16, MySQL 5.6 and phpMyAdmin 4.0.3 (after I formatted my pc ). It seams it works fine for now, I'll test further, hope to be ok. Thanks

Hi, I have xampp 1.8.1 on win xp sp3. I got this error when I try to connect with mysql Client (cmd C:\xampp\mysql\bin\mysql -u root -p) "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" I can connect with "mysql -u root" (without password) but if I try something, I get access denied. If I try "mysql -u root -p mysql", I get "ERROR 1049 (4200): Unknown database 'mysql'". I can connect from phpMyAdmin, and I can do anything there. But in command prompt, when I tried mysqladmin flush privileges (or something else), it says "unknown command" or other errors. I tried from SQL console in phpMyAdmin to add for root hosts 'root'@'localhost' , 'root'@'127.0.0.1' , 'root'@'::1', 'root'@'%' with CREATE USER 'root'@'localhost' IDENTIFIED BY 'some_pass'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; For 127.0.0.1 I got "#1396 - Operation CREATE USER failed for 'root'@'127.0.0.1' ", for the others worked. There are few days since I struggle with this thing, I can really use some help. Thanks.

Hi Muddy, I've installed XAMPP, indeed very easy task. No complication, just few minutes at all setting users and password. It looks fine, I'll stay with it. Thanks again.

Ok man, thanks for help. I'll try it, I hope it will work. As I said, I don't need much functionalities from it, just basic. Thanks again.

Can you give me an adress of a good tutorial for install and configure, and what is the XAMP version working on win xp sp3 32 bit. I'll try that if you say it's good.

Not necessary. Few years ago I've tried xamp wamp or something, and as i can remember I had some trobles. So I found a good tutorial and I've istalled it separately. But this time it didn't worked . I using it for virtual hosting on my pc and for a litle php thing (simple things like php include, contact forms, rss reader). So I am looking for simple solution. Right now the simplest solution seems to solve my problem, if someone can tell me how.

I'm struggling to install those things for few days and I've reached madness threshold. I have Windows XP sp 3. I've installed: - apache_2.2.4 no ssl (apache_2.2.4-win32-x86-no_ssl.msi) - php-5.2.17 (Thread Safe) sourse files on C:\php (php-5.2.17-Win32-VC6-x86) - mysql-5.1.62-win32.msi - phpMyAdmin-3.5.0-all-languages, I've put it in Apache.... \htdocs. I've installed, configurated. Untill phpMyAdmin all it seems fine (for me, at least). The "IT WORKS" thing, the php info. When I've put phpMyAdmin, troubles... When I am trying to connect, I got either "#1045 Can't connect to MySQL server", either, when it seems to connect (but it remains still), I got error message "Apache HTTP Server has encountered a problem and needs to close. We are sorry for the inconvenience." (At 'details' says thomething about httpd.exe). And I must restart the pc, because it's hanging with cpu 100% (I have no ideea what he is @#%^# working so hard). I've tried in config.inc.php at 'Authentication type' either with 'cookie' and without user, either with 'config' with user and pass, I've tried with 'AllowNoPassword' true or false. And 'extension' mysql or mysqli. And etc. In php.ini I've uncommented exthensions: php_bz2.dll, php_gd2.dll, php_mbstring.dll, php_mcrypt.dll, php_mysql.dll, php_mysqli.dll, php_zip.dll. I've tried MySQL from the console, it seems to work (as far as I can tell ). It asked for password and it looked fine. As I said, I am at nerves limits, if someone can help, I'll be very grateful. Thanks