Need help with username/password

[jsgoober]

Hi all,

I am new with MySQL and really need your help.

Questions:
1. How to create a new database
I used: %>mysqladmin create mytestdbs?

2. How to grant a username/pw to that database?
I used:
GRANT select,insert,delete,update on mytestdbs.*
to newuser@123.456.789.0 identified by 'password';

3. How to login in using the new username/pw to that
new database.
NO IDEA!

I used: mysql -u username -p password
but still prompts for password, why?

Really appreciate it if someone can help!

Jay

 

[ToeShot]

Are you putting the password on the same line?

mysql -u username -p password

If you do it like this MySql does not want a space between -p and password. it should look like this

mysql -u username -ppassword


HTH Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait