Did you run /usr/bin/mysql_install_db ???
:b!
Brian D. McGrew { brian@xxxxxxxxxxxxx || brian@xxxxxxxxxxxxxxxxxxx }
--
> 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@xxxxxxxxxx
[mailto:fedora-list-bounces@xxxxxxxxxx] On Behalf Of Kaushal Shriyan
Sent: Wednesday, June 07, 2006 7:17 AM
To: For users of Fedora Core releases
Subject: Re: MySQL
On 6/7/06, Brian D. McGrew <brian@xxxxxxxxxxxxx> wrote:
> As root, run /usr/bin/mysql_install_db and that should recreate
> everything. Your exact path may vary!
>
> :b!
>
> Brian D. McGrew { brian@xxxxxxxxxxxxx || brian@xxxxxxxxxxxxxxxxxxx }
> --
> > 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@xxxxxxxxxx
> [mailto:fedora-list-bounces@xxxxxxxxxx] On Behalf Of Kaushal Shriyan
> Sent: Wednesday, June 07, 2006 7:06 AM
> To: For users of Fedora Core releases
> Subject: MySQL
>
> Hi ALL
>
> I have RHL 9.0 installed on my box, and I have installed
> mysql-3.23.54a-11.i386.rpm mysql-server-3.23.54a-11.i386.rpm,
> due to some reason i deleted the folders from /var/lib/mysql, I mean
> mysql and test folder located under /var/lib/mysql
>
> I have re-installed the package mysql and mysql-server package but i
> am not able to see the test and mysql database which comes by default
> while installing
> mysql and mysql-server package.
>
> How do i recover the default database mysql and test
>
> Any help will be really appreciated
>
> Thanks
>
> Kaushal
>
> --
> fedora-list mailing list
> fedora-list@xxxxxxxxxx
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>
> --
> fedora-list mailing list
> fedora-list@xxxxxxxxxx
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>
Thanks Brian
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
Kaushal
--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
