Hi Vinay,
1. information_schema and mysql
2. do "use <your database name>;" and then do a "show tables;"
3. if you want to see all of the users you have created, then run
"SELECT user from mysql.user;"
But if you just want to see which users are logged in and what they
are currently doing then run "show processlist;"
4. root should work with no password right out of the box. How did you
install mysql? If you can't even log in none of my advice for 1-3 will
be too helpful.
"does not prompt for "Enter Password" and after this if I type a ";" then it
gives following errors." , you do not need to type the ";" while
logging in, you only need that after you already logged into the mysql
server.
On Wed, Jun 24, 2009 at 5:42 PM, Vinay Nagrik<vnagrik@stripped> wrote:
> 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
>
--
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the biggest scourge on plain text email discussions?
