MyPHPadmin question

[Kysmiley]

On my shared hosting server when creating anew db it asks for name and passward. On my laptop Dev server when using MyPHPadmin and creating a database it does not ask for a password. Is this part of somthing I need to set in the config file or somthing. If i'm going to learn to use a database and upload information to it i would like it to ack like one on-line fore testing purposes. Every PHP/Mysql script i see has a place where you connect to the databass and include the psswrd for connection.
Hope my ramblin makes scence, PAT

[bubone2]

Is it possible that you have logged in to it once already, and the computer is logging you in automatically when you visit the site?

Josh

[Kysmiley]

Nope, this is just my DEV. server and not on line so it never asks me to login or to set passwords when creating databases. I like the question though it teaches me how to think while learning.

[Salsa]

/* I was just closing up myriad browser windows and found this thing that I evidently keyed up yesterday and didn't send because I got interupted or something. Anyway, I'm not sure if it's relevant to the problem, but it can't hurt to check out. */

I don't know much about phpMyAdmin, and I'm just guessing here, but is it possible that you haven't added a password for your local MySQL root user, and phpMyAdmin doesn't bother to ask for a password if it isn't necessary? Fresh installations of MySQL usually don't have a password set for the root user, and it's usually one of the first things to do after installation.

You're absolutely right that it's a good idea to set up your local machine as near as possible to your remote one. In addition to setting a password for the local root, I'd set up all local MySQL user(s) and password(s) to be identical to those on your remote server.

I hope this helps.