[mythtv-users] Password error on optimize_mythdb.pl

[Don Brett]

On 2/25/2018 4:09 PM, Peter Bennett wrote:
>
>
> On 02/24/2018 11:49 PM, Don Brett wrote:
>> Not sure where this leaves us....
>>
>> -All of the /home and config.xml issues you mentioned appear to be 
>> setup correctly.  It's using the same name/password/database name as 
>> the contrib example has, so it's pretty standard.
>>
>> Anything else to try?
>>
>> Don
>>
>> PS - Thanks for  the  help.
>>
>>
> What user id are you logged in as when running mythdb.pl?
> Make sure that user has a $HOME/.mythtv directory with the correct 
> config.xml.
> Get rid of mysql.txt, you should not use that any more.
> Test from the user that is running mythdb.pl whether you can connect 
> to mysql with the user id and password that are in the 
> $HOME/.mythtv/config.xml file
> For example
> mysql -u mythtv -p9uKbDz3G -h localhost mythconverg
>
>
I use Putty to log in as 'don' from a windows box, and  usually run it 
as don.  I moved  mysql.txt out of the way and su'd to the mythtv user.  
Same result...

don at nick:~$ sudo -i -u mythtv
$ whoami
mythtv
$ /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
DBI 
connect('database=mythconverg:host=localhost;port=3306','mythtv',...) 
failed: Access denied for user 'mythtv'@'localhost' (using password: 
YES) at /usr/share/perl5/MythTV.pm line 373.
Cannot connect to database:
$

I'm still wondering about the password field missing from the mysql 
datebase, so I checked the older box (mythbuntu 12.04).  It has both 
password and authentication_ string.

mysql>
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>
mysql> describe user;
+------------------------+-----------------------------------+------+-----+---------+-------+
| Field                  | Type                              | Null | 
Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+---------+-------+
| Host                   | char(60)                          | NO | PRI 
|         |       |
| User                   | char(16)                          | NO | PRI 
|         |       |
| Password               | char(41)                          | NO |     
|         |       |
| Select_priv            | enum('N','Y')                     | NO |     
| N       |       |
| Insert_priv            | enum('N','Y')                     | NO |     
| N       |       |
| Update_priv            | enum('N','Y')                     | NO |     
| N       |       |
| Delete_priv            | enum('N','Y')                     | NO |     
| N       |       |
| Create_priv            | enum('N','Y')                     | NO |     
| N       |       |
| Drop_priv              | enum('N','Y')                     | NO |     
| N       |       |
| Reload_priv            | enum('N','Y')                     | NO |     
| N       |       |
| Shutdown_priv          | enum('N','Y')                     | NO |     
| N       |       |
| Process_priv           | enum('N','Y')                     | NO |     
| N       |       |
| File_priv              | enum('N','Y')                     | NO |     
| N       |       |
| Grant_priv             | enum('N','Y')                     | NO |     
| N       |       |
| References_priv        | enum('N','Y')                     | NO |     
| N       |       |
| Index_priv             | enum('N','Y')                     | NO |     
| N       |       |
| Alter_priv             | enum('N','Y')                     | NO |     
| N       |       |
| Show_db_priv           | enum('N','Y')                     | NO |     
| N       |       |
| Super_priv             | enum('N','Y')                     | NO |     
| N       |       |
| Create_tmp_table_priv  | enum('N','Y')                     | NO |     
| N       |       |
| Lock_tables_priv       | enum('N','Y')                     | NO |     
| N       |       |
| Execute_priv           | enum('N','Y')                     | NO |     
| N       |       |
| Repl_slave_priv        | enum('N','Y')                     | NO |     
| N       |       |
| Repl_client_priv       | enum('N','Y')                     | NO |     
| N       |       |
| Create_view_priv       | enum('N','Y')                     | NO |     
| N       |       |
| Show_view_priv         | enum('N','Y')                     | NO |     
| N       |       |
| Create_routine_priv    | enum('N','Y')                     | NO |     
| N       |       |
| Alter_routine_priv     | enum('N','Y')                     | NO |     
| N       |       |
| Create_user_priv       | enum('N','Y')                     | NO |     
| N       |       |
| Event_priv             | enum('N','Y')                     | NO |     
| N       |       |
| Trigger_priv           | enum('N','Y')                     | NO |     
| N       |       |
| Create_tablespace_priv | enum('N','Y')                     | NO |     
| N       |       |
| ssl_type               | enum('','ANY','X509','SPECIFIED') | NO |     
|         |       |
| ssl_cipher             | blob                              | NO |     
| NULL    |       |
| x509_issuer            | blob                              | NO |     
| NULL    |       |
| x509_subject           | blob                              | NO |     
| NULL    |       |
| max_questions          | int(11) unsigned                  | NO |     
| 0       |       |
| max_updates            | int(11) unsigned                  | NO |     
| 0       |       |
| max_connections        | int(11) unsigned                  | NO |     
| 0       |       |
| max_user_connections   | int(11) unsigned                  | NO |     
| 0       |       |
| plugin                 | char(64)                          | YES |     
|         |       |
| authentication_string  | text                              | YES |     
| NULL    |       |
+------------------------+-----------------------------------+------+-----+---------+-------+
42 rows in set (0.00 sec)
mysql>

  Can someone check your working instance?



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus