dansta wrote
I followed your tutorials to the letter and that was why it wasn't working. In the mysql tute you say "if it is your first installation of mysql you may be prompted for a password - press cancel" It was my first install so I pressed cancel and all I had in the my.ini file when I checked was;
[WinMySqladmin]
Server=C:/mysql/bin/mysqld-nt.exe
and nothing else.
To get the other lines I had to reinstall then input a user and password press ok then delete it in the my.ini file as in the other part of your tutorial.
A minor point but others may experience the same problem I did.
All is now working well.
Thanks for the tute.
Only if they don't understand the concept of what TrustPunk is saying. If you don't enter a username and password, OF COURSE the my.ini file is going to be empty. If you read the manual, you will see that there are MANY things you can put in that file (my.ini) to control how MySQL behaves on your PC. That file is just a DEFAULT setup. There are other possible versions of the "my.ini" file in the MySQL folder named "my-huge", "my-large", "my-medium", and "my-small". If you want, you can rename one of those to "my.ini" and use it instead. Make sure you backup your original "my.ini" file in case you screw up (been there - done that).
For future reference, all you had to do was right-click on the little traffic light in your system tray and open the MySQL Admin program, edit the "my.ini" file to include a username and password, and SAVE the changes.
As long as the login info is the same in "my.ini" and in the phpMyAdmin config file, you shouldn't have a problem logging in. You can also change, add, or delete users/passwords from the command line (if you know the syntax). :wink: