24 Apr
2005
24 Apr
'05
6:54 p.m.
Paul Greene wrote:
How do you create a user in MySQL? (let me reiterate I'm just as new at MySQL as I am at Drupal).
Or does MySQL use operating system level user accounts? I've tried "mysql", "dba_user", and "root" and none of them have worked. MySQL only added the "mysql" account on its own.
MySQL has it's own user database. On most standard MySQL setups the superuser is 'root' with no password initially set.
mysqladmin -u root create name_of_db
hth
Torgeir