Rich Deeming wrote:
DB dir owned by mysql not daemon...
[EMAIL PROTECTED] ~]# ls -al /var/lib/mysql
total 28
drwxr-xr-x 5 mysql mysql 4096 Jan 18 04:41 .
drwxr-xr-x 38 root root 4096 Jan 9 19:42 ..
drwx------ 2 mysql mysql 4096 Nov 27 10:44 mysql
srwxrwxrwx 1 mysql mysql 0 Jan 18 04:41 mysql.sock
drwx------ 2 mysql mysql 4096 Jan 10 10:53 mythconverg
drwx------ 2 mysql mysql 4096 Nov 27 10:44 test
Checking that SUSE starts mysql with the same args this is mine.
root 2968 1 0 Jan18 ? 00:00:00 /bin/sh
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
--pid-file=/var/run/mysqld/mysqld.pid
mysql 2997 2968 0 Jan18 ? 00:00:00 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
--user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
amd64:/home/tdec # mysqlaccess -d info
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe
Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- +
--------------------
N N N N N N N N N N N N N N N N
N N N N N ? ? ? ? 0 0 0 |
localhost,nobody,info
amd64:/home/tdec # mysqlaccess -d mythconverg
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe
Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- +
--------------------
N N N N N N N N N N N N N N N N
N N N N N ? ? ? ? 0 0 0 |
localhost,nobody,mythconverg
amd64:/home/tdec # mysqlaccess -d test
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe
Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- +
--------------------
Y Y Y Y Y Y N N N N N Y Y Y N N
Y Y N N N ? ? ? ? 0 0 0 |
localhost,nobody,test
amd64:/home/tdec # mysqlaccess -d mysql
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe
Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- +
--------------------
N N N N N N N N N N N N N N N N
N N N N N ? ? ? ? 0 0 0 |
localhost,nobody,mysql
Rich,
Sorry I have to bug you again. You were correct in your message about my
problems with the mytyfilldatabase.
I'm trying to determine if my permissions are corrrect as well as the parameter
to start the server.
I am new to linux and mysql. Mythtv has my introduction to this new enviroment
so many obvious things are not
obvious for me :-(.
Above are all the databases I have in mysql.
Do you see any problems?
Should I change the User in the mythconverg to mythtv?
TIA.
Initially I though the hardest part was going to be the module vide/sound and I
was wrong.
Everything was easy until I start to deal with mysql. Well I will go step by
step until
the whole thing is solved.
Best regards,
-=terry(Denver)=-
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
