Posts by soulman

thanks guys. i finally unistall old mysql version by removing mysql from task manager. otherwise it would not allow me to delete the directory. And have just installed mysql new verion 4.1. this time i will be carefull not to play around with priviligies.
all i want to do is to add password to root username. as it is its just root and no password.

many thanks to all of you again. cheers

ok well i did find the entry in add/remove and did remove it. then i downloaded the msi file of mysql4.1.12a. ran configuration wizard and i think in one of the last screens the processing configuration it was not able to start service. message said 'Cannot create windows service for Mysql. Error:0'

to install service is like this ight; mysql-nt --install. but we have not installed it completely yet so how do we start the service.

i'm sure this should be a piece of cake for you. cheers.

well i couldn't see any way to delete it in add/remove control panel but just deleted the whole folder. and reinstalled.

however, still same problem after reinstall. ie no priviligies. i have 2 utilities. in mysqladministrator i see on server connections this 'mysql error number 1044. Access denied for user: '@localhost' to database 'mysql'

and in mysql control centre for ex i tried shutting down the message i got was ERROR 1227: access denied. You need the shutdown privilige for this operation.

can you giver me a command to make new user with proper priviligies although i tried that from mysql control centre without success.

so once again more food for thought.

Thanks.
I will try out your valuable advice. I will delete phpmyadmin, then uninstall mysql. i suppose deleting mysql would be to delete mysql folder and also look at add/remove in control panel right. and then re-install both. And yes all tables/databases gone. but nothing to worry about for me cause all apps were used like mambo, oscommerce, phpnuke, etc were used for test purposes.

will keep you updated on the progress. cheers.

in response to Troy.

I am using mysql 4.0.24 on windows 2000 pro. ansd in my config.ic file i've specified root as the user. i think i might have played around with phpmyadmin when this happened, ex i added new user for test but then deleted it. then it went like as it is.

effectively i have limited myself of using phpmyadmin. i had other stuff on my apache folder that can now not be run. cause it also deleted all databases except test that i think comes as default.

and finally i did try re-installing with new phpmyadmin version 2.6.3-pl1. and i have tried your code. All in all still same problem faced.

look i appreciated your feedback but would appreciate you have any new ideas. thanks once again.

also i took out old phpmyadmin and reinstalled new version 2.6.3-pl1 . but still NO PRIVILIGIES is displayed. how can i make this work back to normal as before when i played around with it.

issue is how do i restore priviligies. does anyone know about mysql command for it.
i agree with you that installation is very easy.

on the index.php page under create new database listed is no Priviligies. How can i correct this.

it seem to be working fine but then i think i played around with priviligies to get mamboserver working. after that all my databases were gone and i can't seem to add new databases as NO PRIVILIGIES is stopping me doing it.
Thanks in advance.

wow! after spending days on it the last advice on entering
PHPIniDir "C:/php" seem to have done the trick. I can finally see the username/password screen and then see phpmyadmin index page. Thank you.

I am having same problem, just want to try your last advice. My question is where do you put this line in apache2 httpd.conf.

Much appreciated. Thanks.

For those who tried all the above, but still have no succes:

Open httpd.conf (the Apache configuration file) in a text editor and add the following line:

PHPIniDir "C:/php"

Replace 'C:/php' with the path to the directory where your php.ini file is residing.

Save the file and restart Apache.

This did the trick for me.