List:MySQL and PHP« Previous MessageNext Message »
From:Vinay Nagrik Date:June 24 2009 11:42pm
Subject:Mysql: Need a kick start on admin commands
View as plain text  
Dear Group,

I worked with other databases including Oracle, and Informix.  And can find
my way there.  However, the admin commands in mysql db are different.

I have downloaded and installed mysql db on my personal machine running
Windows XP.  The prompts never asked me to create any account not even that
of root.  And thus I did not create any default account.

I understand each db must have a "root" account, and mysql must have one
too.  But I find it difficult to navigate the db.

The "show user" command does not work in mysql.  When I start mysql, it
appears I am logged on as an empty username user; like ' '.

Typing

mysql -u root -p

does not prompt for "Enter Password" and after this if I type a ";" then it
gives following errors.

############
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
corresponds to your MySQL server version for the right syntax to use near
'mysql
 -u root -p' at line 1

#############

Could some guru from mysql tell me the following basic answers, and can also
direct me to a accessible manual, where I can read about basic admin
commands of mysql.

1.  When downloaded, which default db, mysql gets installed?
2.  What are default tables does it come with?
3.  How to find in logged in users something like "show user" in Oracle.
4.  How to log in as user "root", because for me the following command did
not work

'mysql -u root -p'

I will really appreciate all the help.  I hope I can take over the rein
after I clear my head about these basic questions.

Thanks in advance.

-- 
Thanks

Nagrik

Thread
Mysql: Need a kick start on admin commandsVinay Nagrik24 Jun 2009
  • Re: Mysql: Need a kick start on admin commandsDarryle Steplight25 Jun 2009
    • Re: Mysql: Need a kick start on admin commandsPriti Solanki26 Jun 2009