Hi,
Following will help you to do this.
Ø create user root identified by ‘password’
Ø grant select ON *.* TO root@'%'; --selected grants
Ø GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; -- all privileges
when you install mysql freshly it will not create root by default .One has
to create root user by its own.
hope this info become useful to you.
Regards
On Thu, Jun 25, 2009 at 3:36 AM, Darryle Steplight <dsteplight@stripped>wrote:
> 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?
>
> --
> MySQL PHP Mailing List
> For list archives: http://lists.mysql.com/php
> To unsubscribe: http://lists.mysql.com/php?unsub=1
>
>
