Creating datbase and password simultaneously

[Awestruck]

Is there a way of creating a database in phpMyinfo or using SQL commands so that I can simultaneously create the password and username. I am a raw newbie, so please explain using nursery English. Regards. Awestruck

[bradgrafelman]

You're missing a bit of information there... what password and username? Do you mean login credentials used to access a MySQL server? (And second, are you even talking about a MySQL server? I'm assuming that "phpMyinfo" was supposed to be "phpMyAdmin" .. ?) If so, what kind of privileges should that new account have? What hosts should be allowed to use that account?

Making a bunch of assumptions to the above unanswered questions, here's one example:

CREATE DATABASE foo;

GRANT ALL
ON foo.*
TO 'foo_user'@'localhost'
IDENTIFIED BY 'foo_user_password';

[Awestruck]

Sorry about that. Yes I did mean phpMyAdmin. It's tricky getting my head round all the new names and jargon. Your suggested solution is very helpful. I was thinking of two cases. One with just the administrator able to change things. and one where a member of a club or blog can loginin and/or register with username and password. I want to create and secure the database and not use the default root and empty password. many thanks for replying so promptly. Awestruck