Glad you got things working
mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Akonadi, Amarok, Mythtv, etc all the same, you had permission problems, hence the link I gave you
it also helps to know the names of the databases.
I've never used phpMyadmin, looks nice, might try it, I do everything command line.
Mythtv uses mythconverge for database (or anything you name it)
mysql -u mythtv --password=mythtv -p -h 10.10.10.3 mythconverg
grant all privileges on *.* to 'mythtv'@'10.10.10.3' with grant option;
flush privileges;
select user,host from user where user='root';
select user,host from user where user='username';
+--------+------------+
| user | host |
+--------+------------+
| mythtv | % |
| mythtv | 10.10.10.3 |
| mythtv | localhost |
| root | localhost |
+--------+------------+
4 rows in set (0.00 sec)
Some packages/databases need to load time zones on systems that have a zoneinfo database to load the time zone tables
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
I usually bind an IP address in /etc/mysql/mariadb.conf.d/50-server.cnf makes this easier also.
If there is no database, you have to create one
create database nameofdatabase;
You can erase an existing database and start fresh or just erase one you don't need anymore
DROP DATABASE IF EXISTS nameofdatabase;
I don't know a whole lot, but mythtv forces you to learn a little