Find the answer to your Linux question:
Results 1 to 2 of 2

Thread: MySQL Corrupted

Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    MySQL Corrupted

    I've spent a good week working to set up MythTV on my Fedora Core 7 computer, but I am still unable to set up the MySQL server correctly. I've followed the following instructions over and over again, and I've also reinstalled MySQL and MythTV, but still no success. Could someone tell me how to delete every trace of MySQL and start from scratch? Here are the instructions I followed--

    12. Set up MySQL

    We'll need to enable MySQL to load at startup, set some passwords, and create the MythTV database, which we'll populate shortly. The population of this database is handled by mythtvsetup in the next step, and all MythTV add-on module database additions must be done AFTER running mythtvsetup at least one time.
    # /sbin/chkconfig mysqld on
    # /sbin/service mysqld start

    Set the mysql root password, replacing ROOT_PWD with your chosen administrator password:
    # mysql -u root mysql
    mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
    mysql> quit

    Now we create the mythtv database (called mythconverg) to get us started:
    $ mysql -u root -p < /usr/share/doc/mythtv-0.20/database/mc.sql
    (enter the password you just set above when prompted)
    I continually run into this error--

    [MythTV@localhost ~]$ mysql -u root mysql -poodle
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    I'd deeply appreciate any help. Thanks a million!

  2. #2
    If you installed MySQL via yum, then:

    yum remove mysql*

    Should remove all traces of it; but you probably don't need to do that.

    I have had much success using -p<password> with the mysql cli. Maybe try:

    mysql -u root -p

    instead, and then enter the password when prompted.

    IIRC, --password=<password> did work for me, eg:

    mysql -u root --password=something

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts