Quote:
Originally Posted by LordV27
I tried the suggested method.. the list did not include fpdb and when I said to drop fpdb it clearly stated that the database did not exist.. I am still having the same problem as before clearly am at my wits end..
OK, the installer is not making an fpdb database for you. Later today I will look at that code and do some more testing on it.
You just need to create the fpdb database and set its permissions. So get back in to the mysql client like you did before. Then do:
CREATE DATABASE fpdb;
SHOW DATABASES;
my output looks like this:
Code:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| fpdb |
| fpdbTEST |
| fpdb_test |
| mythconverg |
| test |
| tester |
+--------------------+
8 rows in set (0.01 sec)
You will have fewer databases, but you should have one named fpdb.
Now set the password for fpdb with these 2 commands:
GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
OK, let's see if that worked. Now type this command:
SHOW GRANTS for fpdb@localhost;
Failure looks like this:
Code:
mysql> show grants for mythtv@'192.168.1.100';
ERROR 1141 (42000): There is no such grant defined for user 'mythtv' on host '192.168.1.100'
and success looks something (but not exactly) like this:
Code:
show grants for mythtv@localhost;
+-----------------------------------------------------------------------------------------------------------------+
| Grants for mythtv@localhost |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY PASSWORD '0476fc026afffe24' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
If that all worked you should be ready to run fpdb.