Ok !!!!
The problem are that I have checked this command but
after I insert the root (unix root) and not the db
root.
Thanks you very much !!!!!
Emiliano
--- Sheena Sidhu <[EMAIL PROTECTED]> wrote:
> emiliano ,
> the reason you cannot use mysql to connect to
> use mysql database but can
> use test is because you do not have permissions to
> use mysql database. try
> connecting as mysql -u root -p
> when prompted enter the root password. after being
> connected, look into the
> users and db table of mysql database. this will give
> you clues why you
> cannot do somethings that you mentioned in ur mail.
>
> Sheena.
>
> -----Original Message-----
> From: emiliano [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 06, 2001 12:55 PM
> To: [EMAIL PROTECTED]
> Subject: Re: create database problem
>
>
>
> Hi !!!
> Scuse me if before I insert few data to analize the
> problem :-)
> Now ....
> at the shell I insert the command 'mysql' then at
> the prompt of mysql if I
> insert the command 'connect test' this work and I
> can use sql command to
> work
> on the database. If I else insert 'connect mysql'
> (the other db created by
> the script mysql_install_db) the result is this
> error
>
> ERROR 1044: Access denied for user: '@localhost' to
> database 'mysql'
>
> If I launch mysql and when appear me the prompt
> 'mysql>' insert the command
> 'CREATE DATABASE pippo;' the result is
>
> ERROR 1044: Access denied for user: '@localhost' to
> database 'pippo'
>
> This problem exist using all user on the system
> (root included).
> Thanks in advance for your interesting
>
> Emiliano
>
> On Thursday 06 September 2001 17:05, you wrote:
> > Show us what you type, and what error message you
> get.
> >
> > Emiliano Carlesi wrote:
> > > Hi !!!
> > > I'm new in this ml.
> > > I've installed MySQL on my linux box follow the
> > > instruction ... I have :
> > >
> > > create user mysql
> > > create group mysql
> > > compiled mysql
> > > exec the script install_db
> > > changed permission
> > > etc ...
> > >
> > > all this operation are doing by root user.
> > >
> > > I can connect to the db 'test' without problem,
> but if
> > > I want to connect the 'mysql' db (with any user,
> root,
> > > mysql, etc) mysql give me the error 1004 say me
> that
> > > the user @locahost have no the permission to do
> this.
> > > This error appear me if I want create a new
> database.
> > > In the db 'test' I can create/delete and use
> table.
> > > I search on line and I see more people have this
> > > problem ... but I don't find the solution. I
> search on
> > > the documentation but this don't solve this
> problem.
> > > Excuse me if this is a stupid problem ....
> > >
> > > Thanks in advance at all
> > >
> > > Emiliano
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Get email alerts & NEW webcam video instant
> messaging with Yahoo!
> > > Messenger http://im.yahoo.com
> > >
> > >
>
---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the
> manual)
> > > http://lists.mysql.com/ (the list
> archive)
> > >
> > > To request this thread, e-mail
> <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > >
>
<[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list
> archive)
>
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
