satish_j
March 1st, 2009, 08:34 AM
I need to know how mysql manages user accounts.I have just installed mysql5 on my Hardy m/c and have password protected the root account.
Now,the root account logs in as expected,but if i type just 'mysql' at command,iam logged in to mysql,although the account can only see test and infor_schema databases.
Iam going to create a new account with my name,which is to be used as owner of a DB(I will create it first).
I just need to know why do i get mysql command prompt on typing 'mysql'.
i.e WHAT ARE THE DEFAULT ACCOUNTS CREATED BY MYSQL ON FRESH INSTALLATION.
I just need to keep only 2 accounts on my server.One will be root--which will be used to create databases,maintenance,etc and the other account should be the account which i will ccreate in my name.
Pls help me in this regard....
Now,the root account logs in as expected,but if i type just 'mysql' at command,iam logged in to mysql,although the account can only see test and infor_schema databases.
Iam going to create a new account with my name,which is to be used as owner of a DB(I will create it first).
I just need to know why do i get mysql command prompt on typing 'mysql'.
i.e WHAT ARE THE DEFAULT ACCOUNTS CREATED BY MYSQL ON FRESH INSTALLATION.
I just need to keep only 2 accounts on my server.One will be root--which will be used to create databases,maintenance,etc and the other account should be the account which i will ccreate in my name.
Pls help me in this regard....