MySQL

[Kaushal Shriyan]

On 6/7/06, Brian D. McGrew <brian at visionpro.com> wrote:
> > I am getting [root at saabworld default]# mysql Welcome to the MySQL
> > monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 14 to server version: 3.23.54
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> use mysql
> > ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> > mysql>
> >
> > How do i rectify this
> ----
> [root at saabworld default]# mysql -u root -p <cr>
>
> Now MySQL should prompt you for the root password.
>
>
> :b!
>
> Brian D. McGrew { brian at visionpro.com || brian at doubledimension.com }
> --
> > This is a test.  This is only a test!
>  Had this been an actual emergency, you would have been
>  told to cancel this test and seek professional assistance!
>
>
> --
> fedora-list mailing list
> fedora-list at redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>

Hi Brian

I accidently deleted root user pointing to localhost entry from user
table in the mysql table

How do i set it back again

Now I get

[root at bdc31096e default]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql> exit
Bye
[root at bdc31096e default]#

Thanks Again

Kaushal