On 6/7/06, Brian D. McGrew <brian(a)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(a)visionpro.com || brian(a)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(a)redhat.com
[mailto:fedora-list-bounces@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(a)visionpro.com> wrote:
> > I am getting [root@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@saabworld default]# mysql -u root -p <cr>
>
> Now MySQL should prompt you for the root password.
>
>
> :b!
>
> Brian D. McGrew { brian(a)visionpro.com || brian(a)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(a)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@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@bdc31096e default]#
Thanks Again
Kaushal
--
fedora-list mailing list
fedora-list(a)redhat.com
To unsubscribe:
https://www.redhat.com/mailman/listinfo/fedora-list
--
fedora-list mailing list
fedora-list(a)redhat.com
To unsubscribe:
https://www.redhat.com/mailman/listinfo/fedora-list
Hi Brian
Hi ALL
[root@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