new to mysql. 2 questions

[pembed2003]

Hi All,
I am new to mySQL and I have 2 questions:

1. Everytime I login to mySQL:

machine 21:06:32 ~ $ mysql -u root -p
Enter password:

It asks me for password. Since I didn't set a password for root when I
installed mySQL, I can just hit Enter and I will be login. This seems
silly so is there a way to disable the prompt so I am automatically
login without hitting Enter?

2. I want to create a user account with only SELECT privilege from
everywhere (like from other hosts). How can I do that? Will the
following work:

GRANT SELECT PRIVILEGES ON mydb.* TO 'readonly'@'*' IDENTIFIED by
'password'

Do I need to create the 'readonly' user first? Or will the above
automatically create the 'readonly' user if it does not already
exists?

Thanks!

[pekka]

pembed2003 wrote:

Hi All,
I am new to mySQL and I have 2 questions:

1. Everytime I login to mySQL:

machine 21:06:32 ~ $ mysql -u root -p
Enter password:

It asks me for password. Since I didn't set a password for root when I
installed mySQL, I can just hit Enter and I will be login. This seems
silly so is there a way to disable the prompt so I am automatically
login without hitting Enter?

you can give your password also in command line, but i think you have to
have the password set

$ mysql --user root --password=mysql --database=dbase $*

--
pekka

Outoa, kaikki älykkäät ihmiset ovat samaa mieltä kanssani.

[Aggro]

pembed2003 wrote:

machine 21:06:32 ~ $ mysql -u root -p
Try this:
machine 21:06:32 ~ $ mysql -u root
2. I want to create a user account with only SELECT privilege from
everywhere (like from other hosts). How can I do that? Will the
following work:

GRANT SELECT PRIVILEGES ON mydb.* TO 'readonly'@'*' IDENTIFIED by
'password'
Looks correct, except the username and address should look like this:
'readonly'@'%'
Do I need to create the 'readonly' user first? Or will the above
automatically create the 'readonly' user if it does not already
exists?

Yes, it will create the user also.