MySQL

[Kaushal Shriyan]

On 6/7/06, Brian D. McGrew <brian at visionpro.com> wrote:
> If you don't have any data in your database that you care about right
> now, I would move /var/lib/mysql to /var/lib/mysql-old and then re-run
> /usr/bin/mysql_install_db and let it start over.
>
>
>
> :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!
>
> -----Original Message-----
> From: fedora-list-bounces at redhat.com
> [mailto:fedora-list-bounces at redhat.com] On Behalf Of Kaushal Shriyan
> Sent: Wednesday, June 07, 2006 7:42 AM
> To: For users of Fedora Core releases
> Subject: Re: MySQL
>
> 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
>
> --
> fedora-list mailing list
> fedora-list at redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>
> --
> fedora-list mailing list
> fedora-list at redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>
Hi Brian

Hi ALL

[root at saabworld mysql]# mysql -u root -h saabworld.com -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20 to server version: 3.23.54

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

mysql> use mysql;
Can't read dir of './mysql/' (Errcode: 13)
Database changed
mysql> show tables;
ERROR 12: Can't read dir of './mysql/' (Errcode: 13)
mysql>

Kaushal