Find the answer to your Linux question:
Results 1 to 2 of 2
Hola, 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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined! TheBirdMan's Avatar
    Join Date
    Jun 2007
    Posts
    29

    MySQL Corrupted


    Hola,
    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> FLUSH PRIVILEGES;
    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
    Just Joined!
    Join Date
    Dec 2006
    Posts
    24
    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
  •