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