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
