mySQL PHP and Apache

Yes, again..sorry but...

[jimbob]

Hello!
Apologies in advance as I know this has been dealt with before, but previous answers don't seem to be working. If I try to access my 'http://localhost/phpmyadmin/index.php' file WITH a password it won't play - but if I leave the password blank it lets me in?
It gives me a warning in big red letters telling me.. 'Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.'

I have entered the password in every config file everywhere I can think of, but obviously to no avail. I've been on this for 2 days and am going to cry soon!

Any ideas? Please?
Jim

[jatar_k]

it sounds like you need to update the root password in MySQL itself. The initial root password upon install is blank and must be changed post installation.

5.5.2 Securing the Initial MySQL Accounts [dev.mysql.com]

[jimbob]

thanks Jatar - I'm trying that now, but if I try to connect to the mysql server from the command line to change tthe password, it won't let me connect:

c:\mysql\bin\mysql test

Also - I can't remember how you get to

shell>

sorry to be so dense.

cheers
Jim

[Smoove3]

you have to update your permissions for the mysql database

[Timotheos]

On the first phpmyadmin screen you'll see a 'permissions' link. Click on that and then either delete the users or change passwords. Once you've done that then phpmyadmin won't work anymore and you'll have to open the config.inc.php file and change the user and password variables.

If you are using this locally for development I wouldn't worry changing the permissions. On the production server it will be critical.

[jimbob]

Thanks people - I got it going in the end...more by luck than judgement!

My next problem is how to upload it to a server....where does the mysql part go?